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

Last updated on SEPTEMBER 22, 2017

Applies to:

Oracle Quality - Version 12.0.0 and later
Information in this document applies to any platform.

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

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms