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.
This is a bug in the RA OEBS Agent.
This issue has been fixed in RA OEBS 4.2.1 - Planned release for December 13, 2018.
Workaround: Use the standard APPS user.