My Oracle Support Banner

ORA-42305 only an Editioning view may replace - While compiling during 12.2.x upgrade (Doc ID 2623158.1)

Last updated on DECEMBER 23, 2019

Applies to:

Oracle Applications DBA - Version 12.2.9 and later
Information in this document applies to any platform.

Symptoms

Upgrading EBS Family Pack from 12.2.x to 12.2.9, patch is failing due to invtxin.odf failing to compile.

 

adworker##.log


Comparing objects in username INV with ODF file
/u01/oracle/ofscrp/fs1/EBSapps/appl/inv/12.0.0/patch/115/odf/invtxin.odf

Reading objects from ODF file

Reading table MTL_MATERIAL_TRANSACTIONS_TEMP ...
Reading table MTL_SERIAL_NUMBERS_TEMP ...
Reading table MTL_TRANSACTION_LOTS_TEMP ...

*** Reading objects from INV schema

Reading table MTL_MATERIAL_TRANSACTIONS_TEMP from INV schema ...
Reading table MTL_SERIAL_NUMBERS_TEMP from INV schema ...
Reading table MTL_TRANSACTION_LOTS_TEMP from INV schema ...

===== Table MTL_MATERIAL_TRANSACTIONS_TEMP all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N1 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N10 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N12 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N13 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N14 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N15 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N16 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N18 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N19 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N2 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N20 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N21 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N22 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N23 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N24 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N25 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N3 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N4 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N5 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N6 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_N8 all columns match.
===== Index MTL_MATERIAL_TRANS_TEMP_U1 all columns match.
Refreshing Editioning View
AD Worker error:
Error while executing statement

AD Worker error:
ORA-42305: only an Editioning view may replace an Editioning view
ORA-06512: at "APPS.AD_ZD_TABLE", line 1035
ORA-06512: at "APPS.AD_ZD_TABLE", line 1154
ORA-06512: at line 2

AD Worker error:

ERROR: Unable to generate editioning view due to the above error.

AD Worker error:
Unable to compare or correct tables or indexes or keys
because of the error above

Time when worker failed: Tue Nov 26 2019 09:16:12


 

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
References


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