RA OEBS job fails: ORA20096 ORACLE error 942 in FND_REQUESTSUBMIT_MLS_REQUEST

Document ID : KB000116395
Last Modified Date : 28/09/2018
Show Technical Document Details
Issue:
After upgrading to OEBS application version 12.2.7, an OEBS Agent job fails. The job report has the following error:

java.sql.SQLException: ORA-20096: ORACLE error -942 in FND_REQUEST.SUBMIT_MLS_REQUEST
Cause: FND_REQUEST.SUBMIT_MLS_REQUEST failed due to ORA-00942: table or view does not exist.
 
Cause:
This is a bug in the RA OEBS Agent. 
Resolution:
This issue has been fixed in RA OEBS 4.2.1 - Planned release for December 13, 2018.

Workaround: Use the standard APPS user.