12.2 Online Enablement Report Section 22 Reports Issue with XLA_DISTRIBUTION_LINKS Table

(Doc ID 2017158.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms



After having completed the 12.2.3 upgrade,
executed online patching database objects standards violations report - DBCC report-
Report has listed one object which is owned by XLA.

Post upgrade below tables with column name more than 28 characters in the
ebs online patching enablement report, here is an extract from the report:

VIOLATIONS
-----------

DOC> **********************************************************************
DOC> SECTION-22
DOC> **********************************************************************
DOC> "Base Column Name must be unique within 28 bytes"
DOC>
DOC> - P2: these columns cannot be revised using the same logical name
DOC> using 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 does not work prior to Online Patching Enablement.
DOC>#

OWNER TABLE_NAME COLUMN_NAME_TO_28_CHARS MATCHES
---------------- ------------------------------ ---------------------------- ----------
...
XLA XLA_DISTRIBUTION_LINKS SOURCE_DISTRIBUTION_ID_CHAR_ 5
...



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms