REL12.2 AP: Online Patching Database Objects Standards Violations AP (Doc ID 1918338.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version 12.2 and later
Information in this document applies to any platform.
***Checked for relevance on 13-Jan-2016***

Symptoms

After having completed the 12.2.3 upgrade,
executed online patching database objects standards violations report - DBCC report-
Report has listed few objects which are owned by AP.


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

DOC> **********************************************************************
DOC> SECTION-15
DOC> **********************************************************************
DOC> "Synonym must point to an object"
DOC>
DOC> - P3: broken synonyms cause clutter and confusion
DOC> - Fix or drop these synonyms
DOC>#

OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME
---------------- ------------------------------ ---------------- ------------------------------
APPS AP_TAX_RECVRY_RATES_S AP AP_TAX_RECVRY_RATES_S
APPS AP_TAX_RECVRY_RULES_S AP AP_TAX_RECVRY_RULES_S

APPS AP_PAYMENT_DISTS_MRC_V AP AP_PAYMENT_DISTS_MRC_V_ALL
APPS AP_RECON_DISTS_MRC_V AP AP_RECON_DISTS_MRC_V_ALL



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
---------------- ------------------------------ ---------------------------- ----------
AP AP_INVOICE_LINES_ALL AIL_DISTRIBUTION_LINE_NUMBER 2




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