My Oracle Support Banner

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

Last updated on JANUARY 16, 2018

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

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
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.