Activity Stream

SQL Scripts
Profile Option values script
( 0 Votes )
General E-Business Suite - SQL Scripts
Written by Jouke de Groot   
Monday, 10 December 2007 12:01

Profile Option values are extremely important ... and difficult to extract from the system. As far as I am aware, the only standard report is the 'User Profile Option Values' report.

So a while ago I created a SQL script to extract them from the database. I usually export the output to Excel to do the actual analysis.

Read more...
 
Initializing an Apps environment in a SQL session
( 0 Votes )
General E-Business Suite - SQL Scripts
Written by Jouke de Groot   
Thursday, 22 November 2007 22:00

In order to select data from Oracle Apps views it is necessary to initialize an environment by setting the context of an organization, reponsibility and user. This can be done in TOAD or Oracle's free equivalent, Oracle SQL Developer.

Read more...