Activity Stream

Yesterday
new download, about 22 hours ago
Martyn Holmes downloaded Setup Transaction Types
new download
Vettrivelou Mounissamy downloaded Account Analysis with Subledger Detail
new download
Vettrivelou Mounissamy downloaded Account Analysis with Subledger Detail
new download
Vettrivelou Mounissamy downloaded Account Analysis with Subledger Detail
new download
Vettrivelou Mounissamy downloaded How to create conditional flexfields
new download
Vettrivelou Mounissamy downloaded XML Publisher Templates - R12.1.1
new user registration
Vettrivelou Mounissamy joined our community! Welcome!
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...