Activity Stream

3 days ago
new user registration
Parasuraman Vaidyanathan joined our community! Welcome!
More than a week ago
new download
Kandasamy Nagappan downloaded Aging 4 buckets
new download
Kandasamy Nagappan downloaded Profile Option Values
new user registration
Kandasamy Nagappan joined our community! Welcome!
new user registration
Zakeer Shaik joined our community! Welcome!
More than 2 weeks ago
new user registration
Narasinga Chennuri joined our community! Welcome!
new download
Marek Skulski downloaded Aging 4 buckets
SQL Scripts
Profile Option values script
( 4 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...