OAE jobs aborting or unknown status: ErrorMsg: AwE-5001 Database Query Errors

Document ID : KB000089564
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
OAE jobs aborting or unknown status: ErrorMsg: AwE-5001 Database Query Errors
Resolution:
Detailed Description and Symptoms

After upgrading to Applications Manager v8 to SP13 Oracle OAE jobs are either Aborting or going into an 'Unknown' status.

Investigation

After inspecting the OAE_Objects.sql we found that there were changes made to the files in recent Service Packs and they were not applied to the application during the upgrade. 


Solution


New files were forwarded and the triggers were updated successfully.