My Oracle Support Banner

How Do You Correct Records Shown In Section 14 Of The ADZDDBCC Report? (Doc ID 2649430.1)

Last updated on MAY 15, 2020

Applies to:

Oracle Inventory Management - Version 12.2.6 and later
Information in this document applies to any platform.

Goal

The E-Business Suite Upgrade Tool Database Compliance Checker ((ADZDDBCC.sql)) has been run.

Refer to:
    <Note 2389640.1> - 12.2 E-Business Suite Upgrade Tool Database Compliance Checker (ADZDDBCC.sql) Reports Invalid Objects After the Online Patching Enablement Patch (13543062:R12.AD.C) Is Applied At The 12.2.0 Level

There are entries in Section-14 related to Oracle Inventory

How do we correct these?

For example, the  following is  seen

DOC>  **********************************************************************
DOC>  SECTION-14  [minimal]
DOC>  **********************************************************************
DOC>  "Table Synonym must point to the editioning view, not the table,
DOC>   if the editioning view exists."
DOC>
DOC>   - P2: Code that references these synonyms may operate incorrectly
DOC>         once the table is patched with revised columns.
DOC>   - Fix: Execute the table upgrade procedure.
DOC>       SQL> exec ad_zd_table.upgrade(table_owner, table_name)
DOC>   - Unused synonyms can be ignored or dropped.
DOC>#

OWNER             SYNONYM_NAME                    TABLE_OWNER   TABLE_NAME
----------------    ------------------------------         ----------------       ------------------------------
APPS                MTL_TXN_REQUEST_LINES     INV                     MTL_TXN_REQUEST_LINES




Solution

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
Goal
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.