My Oracle Support Banner

While Applying Patch 23588491, Encountered An Error Running MSCZDUPG.sql - ORA-20001: Cannot upgrade existing table from Patch Edition: MSC_ITG_COLUMN_MAP (Doc ID 2958757.1)

Last updated on JULY 02, 2023

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Following Note 2552181.1 - Interoperability Notes: Oracle E-Business Suite Release 12.2 with Oracle Database 19c
In Section 2.1 Before the Database Installation, patch 23588491 is required for 12.2.4 only

When attempting to apply patch 23588491:R12.MSC.C  - the following error occurs.

MAIN PATCH u23588491.log SHOWS

Time is: Tue Jun 27 2023 16:38:40
ATTENTION: All workers either have failed or are waiting:
FAILED: file MSCZDUPG.sql on worker 1.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Current time is: Tue Jun 27 2023 16:38:40


WORKER 1 LOG SHOWS

sqlplus -s APPS/***** @/apps/ORAPROD/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/apps/ORAPROD/fs1/EBSapps/appl/msc/12.0.0/patch/115/sql/MSCZDUPG.sql '
Connected.

PL/SQL procedure successfully completed.

BEGIN AD_ZD_SEED.UPGRADE('MSC_ITG_COLUMN_MAP'); END;

*
ERROR at line 1:
ORA-20001: Cannot upgrade existing table from Patch Edition: MSC_ITG_COLUMN_MAP
ORA-06512: at "APPS.AD_ZD", line 26
ORA-06512: at "APPS.AD_ZD_SEED", line 65
ORA-06512: at "APPS.AD_ZD_SEED", line 1427
ORA-06512: at line 1



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


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