My Oracle Support Banner

Patching Readiness Report Adzddbcc Shows Several AR Tables In Section 20 (Doc ID 2537896.1)

Last updated on JULY 23, 2023

Applies to:

Oracle Receivables - Version 12.2.7 and later
Information in this document applies to any platform.

Goal

While performing an upgrade to 12.2.7, the execution output of script adzddbcc.sql is showing the below information:

DOC>  **********************************************************************
DOC>  SECTION-20  [full]
DOC>  **********************************************************************
DOC>  "Table must have an editioning view."
DOC>
DOC>   - P2: These tables may not be patched using online patching.
DOC>   - Fix:  Execute the table upgrade procedure.
DOC>       SQL> exec ad_zd_table.upgrade(table_owner, new_table_name)
DOC>   Note: Tables that are dynamically created by application runtime
DOC>         can be ignored.
DOC>   Note: Tables that end with "_A" are typically audit tables
DOC>         by the Audit Trail feature, and can be ignored.
DOC>   Note: This check is only active after Online Patching Enablement.
DOC>#


AR AR_CUSTOMER_PROFILES
AR AR_CUSTOMER_PROFILE_AMOUNTS
AR AR_CUSTOMER_PROFILE_CLASSES
AR AR_CUST_PROF_CLASS_AMOUNTS
AR HZ_CONTACT_RESTRICTIONS
AR RA_ADDRESSES_ALL
AR RA_CONTACTS
AR RA_CONTACT_ROLES
AR RA_CUSTOMERS
AR RA_CUSTOMER_RELATIONSHIPS_ALL
AR RA_SITE_USES_ALL

 

 Can the above tables be safely ignored or it is needed for the tables to have an editioning view ?

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


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