ORA-06512: At "APPS.CZ_LOCALIZED_TEXTS_TP1" Running Patch 17919161 (Doc ID 1962261.1)

Last updated on OCTOBER 17, 2022

Applies to:

Symptoms

On : 12.2.4 version, Install & Upgrade Issues

atch 17919161 fails to compile plls

running 12.2.4 upgrade patch, but it fails in the worker log as follows:


-----------------------
applied the patch and still the same error for db objects
patch fails for below fmx
INVIDTMP.fmx
FRM-30064: Unable to parse statement select sil.description, sif.concatenated_segments, sil.inventory_item_id from mtl_system_items_vl sil, mtl_system_items_kfv sif where sil.organization_id = :parameter.org_id and sil.inventory_item_flag = 'Y' and sif.inventory_item_id = sil.inventory_item_id and sif.organization_id = sil.organization_id order by sil.description.
ORA-04063: view "APPS.MTL_SYSTEM_ITEMS_VL" has errors
Record Group MTL_ITEM_DESCRIPTIONS
Form: INVIDTMP
FRM-30085: Unable to adjust form for output.


INVIDITM.fmx
ERROR generating form "forms/US/INVIDITM.fmx" from input file

FRM-30064: Unable to parse statement select sil.description, sif.concatenated_segments, sil.inventory_item_id from mtl_system_items_vl sil, mtl_system_items_kfv sif where sil.organization_id = :parameter.org_id and sil.inventory_item_flag = 'Y' and sif.inventory_item_id = sil.inventory_item_id and sif.organization_id = sil.organization_id order by sil.description.
ORA-04063: view "APPS.MTL_SYSTEM_ITEMS_VL" has errors
Record Group MTL_ITEM_DESCRIPTIONS
Form: INVIDITM
FRM-30085: Unable to adjust form for output.


SQL> alter view MTL_SYSTEM_ITEMS_VL compile;

Warning: View altered with compilation errors.

SQL> show erro view MTL_SYSTEM_ITEMS_VL
Errors for VIEW MTL_SYSTEM_ITEMS_VL:

LINE/COL ERROR
-------- -----------------------------------------------------------------
0/0 ORA-00904: "B"."DEFAULT_MATERIAL_STATUS_ID": invalid identifier
SQL>

Cause

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