FMW RCU Fails In 19c Database ORA-00942: table or view does not exist . ORA-06512: at "SYS.DBMS_ISCHED"
(Doc ID 2564229.1)
Last updated on MARCH 06, 2023
Applies to:
Oracle Internet Directory - Version 11.1.1.9.0 and laterOracle Fusion Middleware - Version 11.1.1.9.0 and later
Information in this document applies to any platform.
Symptoms
Problem Summary
---------------------------------------------------
FM (OID 12.2.1.3.0) RCU fails in 19c database (19.3.0.0.0)
Problem Description
---------------------------------------------------
Warning: Package Body created with compilation errors.
Errors for PACKAGE BODY OLADD:
714/13 PL/SQL: SQL Statement ignored
714/25 PL/SQL: ORA-00942: table or view does not exist
And
ERROR at line 1:
ORA-27486: insufficient privileges
ORA-06512: at "SYS.DBMS_ISCHED", line 9387
ORA-06512: at "SYS.DBMS_ISCHED", line 9376
ORA-06512: at "SYS.DBMS_ISCHED", line 175
ORA-06512: at "SYS.DBMS_ISCHED", line 9302
ORA-06512: at "SYS.DBMS_IJOB", line 196
ORA-06512: at "SYS.DBMS_JOB", line 168
ORA-06512: at "ODS.TSPURGE", line 62
ORA-06512: at line 3
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |