Activity Stream

7 days ago
new download
Gunas Rams downloaded How to create conditional flexfields
new user registration
Gunas Rams joined our community! Welcome!
More than 2 weeks ago
new user registration
Mohit Agarwal joined our community! Welcome!
About 3 weeks ago
new user registration
Henry Jiang joined our community! Welcome!
About a month ago
new user registration
shirish ora joined our community! Welcome!
new user registration
T Sundaram joined our community! Welcome!
new user registration
Appoicfoors Appoicfoors Uggs Outlet joined our community! Welcome!
SQL Scripts
Profile Option values script
( 3 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...