My Oracle Support Banner

E-Business Suite Upgrade Tool Database Compliance Checker (ADZDDBCC.sql) Reports Error "Index key size should be less than 3215." (Doc ID 2764474.1)

Last updated on MARCH 29, 2021

Applies to:

Oracle Bills of Material - Version 12.2.10 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 after upgrade to R12.2.2+
The following error is seen in Section - 37 for Bills of Material.
How do we resolve this?

Section - 37 reports

DOC> **********************************************************************
DOC> SECTION-37 [full]
DOC> **********************************************************************
DOC> "Index key size should be less than 3215."
DOC>
DOC> - P3: Possible runtime locking when patching this index. Application
DOC> users may see delayed response for transactions against these
DOC> tables while the index is being patched.
DOC> - Fix: Remove unnecessary columns from the index.
DOC> - Unfixed violations can be ignored.
DOC>#

OWNER INDEX_NAME TABLE_NAME INDEX_KEY_LENGTH
---------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------------------ ----------------
BOM BOM_COMP_ATTR_CTX_ASSOCS_CC

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


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