My Oracle Support Banner

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 FEBRUARY 03, 2020

Applies to:

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

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

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
Goal
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.