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

Last updated on MAY 15, 2024

Applies to:

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

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