Error Message :
ErrorMsg: AwE-5001 Database Query Error (6/21/17 9:57 AM)
An OAE job is run using Applications Manager.
Expected: The OAE job goes from Running to Finished.
Actual: The OAE job goes into a LAUNCH ERROR status and the following errors are shown in the AgentService*.log:
Root Cause: The triggers required for the Applications Manager OAE agent to submit jobs to the OAE database may not be updated.
OS Version: N/A
Fix Status: No Fix
Navigate to Object Admin> Administration> Agents> Select the OAE Agent > Edit
Ensure the OAE agent is in a Stopped status, then select "Update"
If this method is not working, the OAE triggers may need to be dropped, before they are updated:
Stop the OAE agent
Login into the Automation Engine Server command line.
Move into the master's directory $AW_HOME/sql
Log into the Oracle Apps database from SQL*Plus
> sqlplus [email protected]_string.
Run the script to drop the objects
Log back into the UC4 Gui navigate to Object Amdin>Administration>Agents>OAE>Edit>General>Update
If this completes successfully please start the OAE agent.