My Oracle Support Banner

INV_ECC_ACTIVITY_V Violation Reported In SECTION-26 Of EBS Online Patching Database Compliance Checker ( ADZDDBCC.sql ) (Doc ID 2878013.1)

Last updated on JUNE 21, 2022

Applies to:

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

Symptoms

1. Using the Online Patching Readiness Report in Oracle E-Business Suite Release 12.2 (Doc ID 1531121.1)

2. In the report output INV_ECC_ACTIVITY_V Violation Reported In SECTION-26

Sample Output of SECTION-26 from EBS Online Patching Database Compliance Checker Report Output

.....

 

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
DOC>         has been patched.
DOC>   - Fix:  Change the object to reference tables via the APPS table
synonym.
DOC>#

OWNER            OBJECT_NAME       OBJECT_TYPE      REFERENCED_OWNER REFERENCED_NAME
---------------- ------------------------------ ------------------- ---------------- ------------------------------
APPS             INV_ECC_ACTIVITY_V             VIEW                WMS             WMS_ACTIVITY_DETAILS >>>>>>
APPS             INV_ECC_ACTIVITY_V             VIEW                WMS      WMS_ELS_TRX_SRC  >>>>>

 

Changes

 Running EBS Online Patching Database Compliance Checker ( ADZDDBCC.sql ) as part of 12.2.X upgrade

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