Check Periodic Alert Request fails with error ORA-06550 (Doc ID 2201596.1)

Last updated on MARCH 08, 2023

Applies to:

Symptoms

After following <Note 1361842.1>, re-testing was made but Check Periodic Alert Request failed again with the following log details:.

ERROR

Check Periodic Alert Request fails with error ORA-06550

After following <Note 1361842.1>, re-testing was made but Check Periodic Alert Request failed again with the following log details:

APP-FND-01564: ORACLE error 6550 in alusmoac

Cause: alusmoac failed due to ORA-06550: line 1, column 12:
PLS-00201: identifier 'MO_GLOBAL.SET_ORG_ACCESS' must be declared
ORA-06550: line 1, column 12:
PL/SQL: Statement ignored.

The SQL statement being executed at the time of the error was: begin MO_GLOBAL.SET_ORG_ACCESS(:0,null,'M'); end; and was executed from the file &ERRFILE.
APP-ALR-04102: Internal SQL error occurred. (ROUTINE=aleuac) (FILE=alr/lib/alechk.c) (LINE=236)
APP-ALR-04070: Oracle Alert was unable to update the success flag in ALR_ALERT_CHECKS or ALR_ACTION_SET_CHECKS in file alr/lib/alepea.c in routine alepaa on line 1217. Check that both tables exist.
ORACLE error 942 in AFPRSR-Resubmit_Time

Cause: AFPRSR-Resubmit_Time failed due to ORA-00942: table or view does not exist


The SQL statement being executed at the time of the error was: and was executed from the file .
ORA-00942: table or view does not exist

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.