My Oracle Support Banner

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 AUGUST 11, 2024

Applies to:

Oracle Internet Directory - Version 11.1.1.9.0 and later
Oracle 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


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