My Oracle Support Banner

Patch Fails Due to Errors Like "ORA-04063: view "APPS.MTL_SYSTEM_ITEMS_VL" has errors" or "MCC_TRACKING_CODE": invalid identifier" (Doc ID 2503118.1)

Last updated on MARCH 12, 2021

Applies to:

Oracle Inventory Management - Version 12.1.3 and later
Oracle Item Master - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Errors like the following may be seen in the adpatch logs when applying a patch (<Patch 26728381> in this case):

object APPS.MTL_SYSTEM_ITEMS_VL is invalid
----------------------------
ORA-04063: view "APPS.MTL_SYSTEM_ITEMS_VL" has errors
----------------------------
ORA-904: "B"."MCC_TRACKING_CODE": invalid identifier

 

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.