Package EGO_ITEM_PVT Fails to Compile Due to Error: ORA-00904: "L_MASTER_ORG": invalid identifier (Doc ID 2226014.1)

Last updated on JANUARY 23, 2017

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Package EGO_ITEM_PVT fails to compile (i.e. is invalid).
As a results, the EGO_ITEM_PUB API cannot be called/used.

The following errors are returned when trying to compile the package:

PLS-00302: component 'MTL_SYSTEM_ITEMS_B' must be declared
PL/SQL: Item ignored
PLS-00320: the declaration of the type of this expression is incomplete or malformed
PL/SQL: ORA-00904: : invalid identifier
PL/SQL: SQL Statement ignored
PLS-00320: the declaration of the type of this expression is incomplete or malformed
PL/SQL: ORA-00904: "L_MASTER_ORG": invalid identifier
PL/SQL: SQL Statement ignored

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms