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');

Return to : Oracle Database, SQL, Application, Programming Tips