Adzddbcc.sql : Showing Objects ECE_INO_X and EC_DSNO_EXT as NON-Compliant
(Doc ID 2858181.1)
Last updated on MARCH 25, 2022
Applies to:
Oracle EDI Gateway - Version 12.2.10 and laterOracle Shipping Execution - Version 12.2.10 and later
Information in this document applies to any platform.
Goal
Upgraded system from EBS 12.1.3 to EBS 12.2.10
During online patching, finds objects exists in EBS violation report adzddbcc.sql in Section 26 that are showing as NON-Compliant.
From File Name: adzddbcc.lst
DOC> **********************************************************************
DOC> SECTION-26 [minimal]
DOC> **********************************************************************
DOC> "Query/DML statements must access tables via the APPS table synonym."
DOC>
DOC> - P2: These objects may operate incorrectly after the referenced table has been patched.
DOC> - Fix: Change the object to reference tables via the APPS table synonym.
OWNER OBJECT_NAME OBJECT_TYPE REFERENCED_OWNER REFERENCED_NAME
APPS ECE_INO_X PACKAGE BODY WSH WSH_NEW_DELIVERIES
APPS EC_DSNO_EXT PACKAGE BODY XXQA XXQA_MECH_RESULTS_DETAIL
APPS EC_DSNO_EXT PACKAGE BODY XXQA XXQA_MECH_RESULTS_HEADER
How can one make above objects compliant or can one ignore these objects?
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 |