Russia Localizations: CLE:Inventory Issue Order program completing in error (Doc ID 2598762.1)

Last updated on OCTOBER 14, 2019

Applies to:

Symptoms

CLE:Inventory Issue Order program completing in error

ERROR
-----------------------
SQLException encounter while executing data trigger....
java.sql.SQLException: ORA-06550: line 2, column 1:
PLS-00201: identifier 'CLEF141_INV_IOR_PKG.P_LEGAL_ENTITY_ID' must be declared
ORA-06550: line 2, column 1:
PL/SQL: Statement ignored
ORA-06550: line 3, column 1:
PLS-00201: identifier 'CLEF141_INV_IOR_PKG.P_ESTABLISHMENT_ID' must be declared
ORA-06550: line 3, column 1:
PL/SQL: Statement ignored
ORA-06550: line 4, column 1:
PLS-00201: identifier 'CLEF141_INV_IOR_PKG.P_CONC_REQUEST_ID' must be declared
ORA-06550: line 4, column 1:
PL/SQL: Statement ignored
ORA-06550: line 5, column 1:
PLS-00201: identifier 'CLEF141_INV_IOR_PKG.P_DELIVERY_ID' must be declared
ORA-06550: line 5, column 1:
PL/SQL: Statement ignored
ORA-06550: line 6, column 1:
PLS-00201: identifier 'CLEF141_INV_IOR_PKG.P_PRINT_CUST_ITEM' must be declared
ORA-06550: line 6, column 1:
PL/SQL: Statement ignored
ORA-06550: line 7, column 1:
PLS-00201: identifier 'CLEF141_INV_IOR_PKG.P_PRINT_MODE' must be declared
ORA-06550: line 7, column 1:
PL/SQL: Statement ignored
ORA-06550: line 8, column 1:
PLS-00201: identifier 'CLEF141_INV_IOR_PKG.P_SORT' must be declared
ORA-06550: line 8, column 1:
PL/SQL: Statement ignored
ORA-06550: line 9, column 1:
PLS-00201: identifier 'CLEF141_INV_IOR_PKG.P_FREIGHT_CODE' must be declared
ORA-06550: line 9, column 1:
PL/SQL: Statement ignored
ORA-06550: line 10, column 1:
PLS-00201: identifier 'CLEF141_INV_IOR_PKG.P_ORGANIZATION_ID' must be declared
ORA-06550: line 10, column 1:
PL/SQL: Statement ignored
ORA-06550: line 11, column 1:
PLS-00201: identifier 'CLEF141_INV_IOR_PKG.P_QUANTITY_PRECISION' must be declared
ORA-06550: line 11, column 1:
PL/SQL: Statement ignored

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create a Sales Order.
2. Perform Shipment for against the SO.
3. Submit request 'CLE:Inventory Issue Order'.
4. Notice that request completes in error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users are unable to file statutory reports to Tax authorities.

Cause

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