Activity Stream

Today
new comment, about 2 hours ago
Chris Hickey commented on the article Financials Accounting Hub - Basic setup steps (Part 2/2)
Hi All, We need to create state entries via FAH. Im assuming if I create an ...
2 days ago
new user registration
Diane Edwards joined our community! Welcome!
new user registration
Manas Ray joined our community! Welcome!
5 days ago
new user registration
Prashant Kalantri joined our community! Welcome!
More than a week ago
new comment
Vineet Verma commented on the article An introduction to the Financial Services Accounting Hub
Hi sven , I hope you are doing good. Is there any way to throw the same form...
new user registration
Vineet Verma joined our community! Welcome!
new user registration
Thijs Janssen 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...