theonlyalterego


Member since 08/11/2008

17 snippets

85 profile views

1 Comment(s) Posted

View their favorites

Profile

Achievement

first submission:submitting first snipplet

theonlyalterego's Recent Snippets



« Prev 1 Next »
find what profile values are set for a particular user
0 19 posted 7 years ago by theonlyalterego
AP-SLA-GL Link Query
0 36 posted 8 years ago by theonlyalterego
can be used to track Oracle Apps concurrent program performance
0 31 posted 8 years ago by theonlyalterego
This query will retrieve a list of the parameters and value sets based on a provided concurrent program user name
0 31 posted 8 years ago by theonlyalterego
Query to find the most recent logins for a particular user ( find 1 years worth )
0 29 posted 8 years ago by theonlyalterego
A slight adaptation on the sql in the Oracle Forum
0 22 posted 8 years ago by theonlyalterego
IE Zone Analyzer allows comparing/importing/exporting of IE security zones
1 30 posted 8 years ago by theonlyalterego
OFP is the database environment
0 33 posted 8 years ago by theonlyalterego
Very useful sql to find which responsibility has access to a report or request.
0 48 posted 8 years ago by theonlyalterego
I found this today and it's very useful for finding the responsibility key when trying ot run OAF from JDev.
0 67 posted 8 years ago by theonlyalterego
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.
0 37 posted 9 years ago by theonlyalterego
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 )
1 149 posted 9 years ago by theonlyalterego
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....
0 18 posted 10 years ago by theonlyalterego
Sample code from processFormRequest to pop up new window via javascript. worth noting: this is not recommended as it can break the OAF page.
0 39 posted 11 years ago by theonlyalterego
A quick pl/sql command to select from the MDS using the Oracle JDR_UTILS package.
0 23 posted 11 years ago by theonlyalterego
« Prev 1 Next »