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.
Additional grants are needed when connect to Oracle EBS versions 12.2.6+.
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.