Italy Localization: Getting Error on Table JE_IT_EXEMPT_LETTERS While Running EBS Online Patching Database Compliance Checker (ADZDDBCC.sql) (Doc ID 2910948.1)

Last updated on JANUARY 29, 2023

Applies to:

Symptoms

PROBLEM
---------------
Getting Error related to table JE_IT_EXEMPT_LETTERS while running EBS Online Patching Database Compliance Checker (ADZDDBCC.sql).

ERROR
---------------
DOC> SECTION-22 [full]
DOC> **********************************************************************
DOC> "Base column name must be unique within 28 bytes."
DOC>
DOC> - P3: these columns cannot be revised using the same logical name
DOC> during online patching.
DOC> - Fix violations by renaming the column to a shorter base name.
DOC> SQL> alter table table_owner.table_name
DOC> rename column column_name to new_column_name;
DOC> SQL> ad_zd_table.patch(table_owner, table_name)
DOC> - Fixes can be deferred until there is a reason to patch the column.
DOC> Unused columns can be ignored.
DOC> Note: This check only works after Online Patching Enablement.
DOC>#

OWNER TABLE_NAME COLUMN_NAME_TO_28_CHARS MATCHES
---------------- ------------------------------ ---------------------------- ----------
AP JE_IT_EXEMPT_LETTERS RECEIPT_PROTOCOL_NUMBER_PART 2

STEPS TO REPLICATE
-----------------------
1. Perform EBS upgrade from R12.1.3 to R12.2.11.

2. Run EBS Online Patching Database Compliance Checker report.

    $AD_TOP/sql/ADZDDBCC.sql

3. Review the output and observe the error related to table JE_IT_EXEMPT_LETTERS under SECTION-22.

Changes

Cause

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