My Oracle Support Banner

adzdexrpt Script Output for Online Patching Enablement Showing Error ORA-42307 for AR_IREC_USER_ACCT_SITES_ALL (Doc ID 2689681.1)

Last updated on OCTOBER 04, 2023

Applies to:

Oracle iReceivables - Version 12.2 and later
Oracle Applications DBA - Version 12.2.10 to 12.2.10 [Release 12.2]
Information in this document applies to any platform.

Symptoms

When running the script adzdexrpt.sql, as part of the flow for Online Patching Enablement during upgrade to 12.2.x, the following error appears in the output file adzdexrpt.txt

Phase                      DDL ID Status       SQL                                                Error
-------------------- ------------ ------------ -------------------------------------------------- --------------------------------------------------
UPGRADE_TABLE               12017 ERROR        begin ad_zd_table.upgrade('AR',                    ORA-42307: columns of an Editioning view may only
                                               'AR_IREC_USER_ACCT_SITES_ALL'); end;               refer to base table columns


Steps to Reproduce:

  1. Run script adzdexrpt.sql as part of the flow for Online Patching Enablement during upgrade to 12.2.x

 

Changes

 

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
Changes
Cause
Solution


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