Why Are Oracle Warehouse Management Invalid Objects APPS.WMS_EPC_PVT compile body 'MGD_IDCOMPONENT_VARRAY' must be declared Found? (Doc ID 2633780.1)

Last updated on MARCH 12, 2025

Applies to:

Goal

Need to resolve errors in Oracle Warehouse Management (WMS)
Errors for PACKAGE BODY APPS.WMS_EPC_PVT:

LINE/COL ERROR
-------- ----------------------------------------------------------------
1667/1 PL/SQL: Item ignored
1685/35 PLS-00201: identifier 'MGD_IDCOMPONENT_VARRAY' must be declared
2122/3 PL/SQL: SQL Statement ignored
2124/10 PL/SQL: ORA-00942: table or view does not exist
2150/3 PL/SQL: Statement ignored
2150/48 PLS-00364: loop index variable 'L_EPC_GEN_RULE_TYPES' use is  invalid
2151/3 PL/SQL: Statement ignored
2151/48 PLS-00364: loop index variable 'L_EPC_GEN_RULE_TYPES' use is  invalid

LINE/COL ERROR
-------- ----------------------------------------------------------------
2152/3 PL/SQL: Statement ignored
2152/48 PLS-00364: loop index variable 'L_EPC_GEN_RULE_TYPES' use is  invalid

2153/3 PL/SQL: Statement ignored
2153/48 PLS-00364: loop index variable 'L_EPC_GEN_RULE_TYPES' use is invalid

2155/3 PL/SQL: Statement ignored
2155/6 PLS-00364: loop index variable 'L_EPC_GEN_RULE_TYPES' use is
LINE/COL ERROR
-------- ----------------------------------------------------------------
2302/20 PL/SQL: Item ignored
2302/20 PLS-00201: identifier 'MGD_IDCOMPONENT_VARRAY' must be declared
2303/18 PL/SQL: Item ignored
2303/18 PLS-00201: identifier 'MGD_IDCODE' must be declared
2526/2 PL/SQL: Statement ignored
2526/26 PLS-00201: identifier 'MGD_IDCODE_UTL.EPC_ENCODING_CATEGORY_ID'  must be declared
 

Solution

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