OAE Agent in Errors Status

Document ID : KB000089588
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
OAE Agent in Errors Status
Resolution:
Detailed Description and Symptoms 

 After upgrading the Oracle Apps database the OAE Agent is in Errors status and you have trouble with compiling some of the Applications Manager OAE objects:

SQL> alter package apps.APPWORX_OAE_PK compile body;
 
 Warning: Package Body altered with compilation errors.
 
 SQL> show errors
 Errors for PACKAGE BODY APPS.APPWORX_OAE_PK:
 
 LINE/COL ERROR
 -------- -----------------------------------------------------------------
 0/0      PLS-00801: internal error [Unexpected fragile external
          reference.]


Solution

 

There is a manual update that needs to be performed:

1. Stop the OAE agent

2. Complete the following steps from the command line:

> cd $AW_HOME/sql/

> mv OAE_Objects.sql OAE_Objects_9i.sql

> mv OAE_Objects_10g.sql OAE_Objects.sql

3. Update the triggers for the OAE Agent in the GUI

When updating the Applications Manager database tables and triggers, submitting and processing of OA programs within the Oracle Applications instance(s) should be suspended. Stop or pause the corresponding OA Concurrent Manager component(s).
 
To update the tables and triggers, go to the OAE agent's definition. On the General tab, click the Update button shown in Figure A. It may take a few minutes for the update to complete. To view the log file from the update, click the View Log button. The log file in named OAECOPY_update.log and is located in the log directory of the OAE agent.

Restart the component(s) after successfully updating.