My Oracle Support Banner

Online Patching GSCC Report -> Base Column Name Must Be Unique Within 28 Bytes (Doc ID 2700478.1)

Last updated on AUGUST 31, 2020

Applies to:

Oracle Project Foundation - Version 12.2.2 and later
Information in this document applies to any platform.

Goal



Online Patching GSCC report -> Base column name must be unique within 28 bytes(PA)

After upgrading R12.1.3 to R12.2, when running global standard compliance checker report for online patching enablement, the following objects are under warning.

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
---------------- ------------------------------ ------------------------------------------------------------------------------------ ----------
PA PA_EI_DENORM ADJUSTED_EXPENDITURE_ITEM_ID 7
PA PA_EI_DENORM OVERRIDE_TO_ORGANIZATION_ID_ 7
PA PA_EI_DENORM_AR ADJUSTED_EXPENDITURE_ITEM_ID 7
PA PA_EI_DENORM_AR OVERRIDE_TO_ORGANIZATION_ID_ 7
 

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


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