You need to do the following if you get an error saying oracle error 1 in create_event_db_trigger.

The user is missing packages APPS_DDL, APPS_ARRAY_DDL

1. cd $AD_TOP/admin/sql

2. Run adappss.pls

3. Run adappsb.pls
 

Multi-Org and Customization

When you pick a responsibility, the Oracle Applications assign a ORG_ID value to that responsibily based on the MO:Opearting Unit Profile Option. You can access the data from tables based on that ORG_ID value.

To assign a particular ORG_ID to your session use following for a SQL*Plus session:
SQL> execute dbms_application_info.set_client_info('')

To assign a particular ORG_ID to your session use following for a Oracle*Reports:
In the pre-report trigger call: SRW.USER_EXIT('FND SRWINIT');

Have a Oracle Question
Do you have an Oracle Question?

Oracle Books
Oracle Certification, Database Administration, SQL, Application, Programming Reference Books

Oracle Application
Oracle Application Hints and Tips

Oracle Home
Oracle Database, SQL, Application, Programming Tips