My Oracle Support Banner

ADZDPSUM.sql Returns an 'NON-EXISTENT' Referenced Type on CSR_RULES_B (Doc ID 2720898.1)

Last updated on OCTOBER 20, 2020

Applies to:

Oracle Scheduler - Version 12.1.3 and later
Information in this document applies to any platform.


User is running the Online Patching Readiness Report (adzdpsum.sql) to prepare for upgrade from EBS 12.13 to 12.2. The only schema listed  in the output is CSR (Oracle Scheduler). Per the report output recommendation the file adzdpman.sql is executed. The query returns a row for a NON-EXISTENT referenced type for the table CSR_RULES_B under the CSR schma with referenced owner of APPS. The synonym in APPS appears to point accurately to the table in CSR.
OWNER         NAME                    TYPE            REFERENCED_OWNER              REFERENCED_NAME                 REFERENCED_TYPE
=======   =====                =====         ==============         =============           ================
 CSR             CSR_RULES_B       TABLE                    APPS                               XMLTYPE                                 NON-EXISTENT    

Will this record cause any issues and does it need to be fixed?


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

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