EGO_ITEM_PVT Invalid With PLS-00302 And ORA-00904 (Doc ID 2224388.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

EGO_ITEM_PVT is invalid. Following are the error

ERROR
----------
Errors for PACKAGE BODY EGO_ITEM_PVT:

LINE/COL ERROR
-------- -----------------------------------------------------------------
2044/33 PL/SQL: Item ignored
2044/37 PLS-00302: component 'MTL_SYSTEM_ITEMS_B' must be declared
2139/7 PL/SQL: SQL Statement ignored
2139/42 PLS-00320: the declaration of the type of this expression is
  incomplete or malformed

2140/7 PL/SQL: ORA-00904: : invalid identifier
2143/7 PL/SQL: SQL Statement ignored
2148/44 PL/SQL: ORA-00904: "L_MASTER_ORG": invalid identifier
2148/44 PLS-00320: the declaration of the type of this expression is
  incomplete or malformed

Note: Do not use EGO Module but use Inventory module.

STEPS
-----------------------
Compile EGO_ITEM_PVT Package body

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