How Do You Correct Records Shown In Section 14 Of The ADZDDBCC Report?
(Doc ID 2649430.1)
Last updated on MARCH 04, 2024
Applies to:
Oracle Inventory Management - Version 12.2.6 and laterInformation 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
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 |