Snipplr - theonlyalterego

(SQL) Oracle Find Profile Values for User

Fri, 10 Aug 2012 04:24:23 GMT

find what profile values are set for a particular user

(SQL) Oracle AP-SLA-GL Link Query

Sat, 21 Jan 2012 09:04:39 GMT

AP-SLA-GL Link Query

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

Sat, 21 Jan 2012 08:33:10 GMT

can be used to track Oracle Apps concurrent program performance

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

Sat, 21 Jan 2012 07:38:14 GMT

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

Fri, 23 Dec 2011 05:53:20 GMT

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

Wed, 26 Oct 2011 06:40:55 GMT

A slight adaptation on the sql in the Oracle Forum

(Windows Registry) how to compare IE security zone settings

Fri, 14 Oct 2011 04:36:48 GMT

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

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

Fri, 29 Jul 2011 04:36:08 GMT

OFP is the database environment

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

Thu, 28 Jul 2011 01:37:20 GMT

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

Fri, 24 Jun 2011 05:50:01 GMT

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

Thu, 26 May 2011 00:17:22 GMT

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

Sat, 06 Nov 2010 05:55:56 GMT

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

Wed, 20 Oct 2010 07:36:35 GMT

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

Tue, 14 Apr 2009 15:10:32 GMT

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

Tue, 26 Aug 2008 09:45:22 GMT

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

Thu, 14 Aug 2008 14:25:17 GMT

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

Mon, 11 Aug 2008 16:01:10 GMT

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

Mon, 11 Aug 2008 15:46:40 GMT

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