RA OEBS job fails: ORA20096 ORACLE error 942 in FND_REQUESTSUBMIT_MLS_REQUEST

Document ID : KB000116395
Last Modified Date : 04/01/2019
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:
Additional grants are needed when connect to Oracle EBS versions 12.2.6+.
Resolution:
This issue has been fixed in RA OEBS 4.2.1 - Available for download. The latest script user_apps_setup.sql will need to be ran against the database to include all necessary grants. 

Workaround: Use the standard APPS user.