Snipplr

(SQL) Oracle Find Profile Values for User - theonlyalterego

Fri, 10 Aug 2012 04:24:23 UTC

find what profile values are set for a particular user

(SQL) Oracle AP-SLA-GL Link Query - theonlyalterego

Sat, 21 Jan 2012 09:04:39 UTC

AP-SLA-GL Link Query

(SQL) Oracle - get concurrent program runtime / eval performance - theonlyalterego

Sat, 21 Jan 2012 08:33:10 UTC

can be used to track Oracle Apps concurrent program performance

(SQL) Query to find Parameters and Value Sets associated with a Concurrent Program - theonlyalterego

Sat, 21 Jan 2012 07:38:14 UTC

This query will retrieve a list of the parameters and value sets based on a provided concurrent program user name

(SQL) Oracle SQL - get a list of most recent user logins - theonlyalterego

Fri, 23 Dec 2011 05:53:20 UTC

Query to find the most recent logins for a particular user ( find 1 years worth )

(SQL) Oracle - Find which users have FND Diagnostic profile value set - theonlyalterego

Wed, 26 Oct 2011 06:40:55 UTC

A slight adaptation on the sql in the Oracle Forum

(Windows Registry) how to compare IE security zone settings - theonlyalterego

Fri, 14 Oct 2011 04:36:48 UTC

IE Zone Analyzer allows comparing/importing/exporting of IE security zones

(Bash) Oracle - compile report / compile forms on linux - theonlyalterego

Fri, 29 Jul 2011 04:36:08 UTC

OFP is the database environment

(SQL) Oracle - Find all responsibilities and concurrent program names based on the executable Name - theonlyalterego

Thu, 28 Jul 2011 01:37:20 UTC

(SQL) Oracle - sql to find what responsibility can run a request / report - theonlyalterego

Fri, 24 Jun 2011 05:50:01 UTC

Very useful sql to find which responsibility has access to a report or request.

(PL/SQL) Oracle Application - List Responsibilities and Responsibility Keys that are assigned to a user - theonlyalterego

Thu, 26 May 2011 00:17:22 UTC

I found this today and it's very useful for finding the responsibility key when trying ot run OAF from JDev.

(SQL) Oracle Applications - Find Application (Module) Long Name from Short name - theonlyalterego

Sat, 06 Nov 2010 05:55:56 UTC

use this SQL query to find out an applications full name (aka long name) and/or application id based on the application short name. This can obviously be re-written to perform the reverse.

(Windows PowerShell) Windows DIR - List only the filenames of all files in a directory - theonlyalterego

Wed, 20 Oct 2010 07:36:35 UTC

I found this today and don't want too lose it. In windows the following command will create a text file named fileListing.txt which will contain a list of all the files in the current directory ( including fileListing.txt )

(SQL) Oracle SQL - Select OAF File version history - theonlyalterego

Tue, 14 Apr 2009 15:10:32 UTC

This sql query will select the past version information about a given file from the database. An example would be searching for %ApprovalHistoryVOImpl% would return all past version numbers (in the database) for the ApprovalHistoryVOImpl.class file. This is useful for checking which patch versions of a file have been applied to a given database.

(Bash) OAF - XML Exporter - Export Personalization to custom directory - theonlyalterego

Tue, 26 Aug 2008 09:45:22 UTC

code to export personalization to a server side directory. covered in the dev guide, this is just an example.

(Bash) Linux Rename File to Current Date/Time - theonlyalterego

Thu, 14 Aug 2008 14:25:17 UTC

(Java) OAF - Controller Code to create Javascript popup window - theonlyalterego

Mon, 11 Aug 2008 16:01:10 UTC

Sample code from processFormRequest to pop up new window via javascript. worth noting: this is not recommended as it can break the OAF page.

(Other) OAF - Retrieve a Region/Page from Oracle MDS - theonlyalterego

Mon, 11 Aug 2008 15:46:40 UTC

A quick pl/sql command to select from the MDS using the Oracle JDR_UTILS package.