Unsuccessful Row Construction Error When Delivering Receipt Via Mobile Device

(Doc ID 401220.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Inventory Management - Version: 11.5.10 to 11.5.10.CU2 - Release: 11.5 to 11.5.10
Oracle Warehouse Management - Version: 11.5.10 to 11.5.10.2   [Release: 11.5 to 11.5.10]
Information in this document applies to any platform.
***Checked for Relevance 30-APR-2010***

Symptoms

On 11.5.10.2 after applying any one following Patches 5205374, 5142875, 5257946 or really any Patches that changes the version of the INVITPSB.pls from 115.132  to a later version.
Now you are receiving the error message:
"Unsuccessful Row Construction" when tabbing into the subinventory field when
doing the deliver transaction for a receipt via the mobile device (RF scanner - telnet).

Enabling the MWA Server Log Files as per <> How to Enable WMS / MSCA Logging?
shows the following error in the system.log:


(Thread-11) java.sql.SQLException: ORA-04068: existing state of packages has been discarded
ORA-04063: package body "APPS.INV_UI_ITEM_SUB_LOC_LOVS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1
java.sql.SQLException: ORA-04068: existing state of packages has been discarded
ORA-04063: package body "APPS.INV_UI_ITEM_SUB_LOC_LOVS" has errors
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at line 1


Similarity when trying to do a Subinventory Transfer through Form this error is returned:

ORA04068 existing state of packages has been discarded
ORA04063 package body APPSINV_VI_ITEM_SUB_LOC_LOVS_has error
APP INV 05319 internal error in user exit XACT qty 1. 


Run the following SQL to confirm if the package is invalid and the version:

select ds.text ||' - '||do.status ||' - '||do.object _type
from dba_source ds
, dba_objects do
where ds.name = 'INV_UI_ITEM_SUB_LOC_LOVS'
and ds.line=2
and ds.name = do.object_name
and ds.type = do.object_type;
This should return the following:

OBJECT_TYPE         STATUS
Package                      Valid
Package Body            Invalid


Recompiling the Package Body will generate the following error:
SQL> alter package APPS.INV_UI_ITEM_SUB_LOC_LOVS compile body;

Warning: Package Body altered with compilation errors.

SQL> show err
Errors for PACKAGE BODY APPS.INV_UI_ITEM_SUB_LOC_LOVS:

LINE/COL ERROR
-------- -----------------------------------------------------------------
463/9 PL/SQL: SQL Statement ignored
465/11 PL/SQL: ORA-00904: "A"."LOCATOR_SEGMENTS": invalid identifier
478/9 PL/SQL: SQL Statement ignored
480/11 PL/SQL: ORA-00904: "LOCATOR_SEGMENTS": invalid identifier
529/9 PL/SQL: SQL Statement ignored
531/11 PL/SQL: ORA-00904: "A"."LOCATOR_SEGMENTS": invalid identifier
547/9 PL/SQL: SQL Statement ignored
549/11 PL/SQL: ORA-00904: "LOCATOR_SEGMENTS": invalid identifier
591/12 PL/SQL: SQL Statement ignored
593/7 PL/SQL: ORA-00904: "A"."LOCATOR_SEGMENTS": invalid identifier
610/16 PL/SQL: SQL Statement ignored
612/7 PL/SQL: ORA-00904: "LOCATOR_SEGMENTS": invalid identifier
622/17 PL/SQL: SQL Statement ignored
624/7 PL/SQL: ORA-00904: "LOCATOR_SEGMENTS": invalid identifier
637/12 PL/SQL: SQL Statement ignored
639/5 PL/SQL: ORA-00904: "A"."LOCATOR_SEGMENTS": invalid identifier
655/16 PL/SQL: SQL Statement ignored
657/4 PL/SQL: ORA-00904: "LOCATOR_SEGMENTS": invalid identifier
668/17 PL/SQL: SQL Statement ignored
670/4 PL/SQL: ORA-00904: "LOCATOR_SEGMENTS": invalid identifier


The line and column will vary depending on the version of $INV_TOP/patch/115/sql/INVITPSB.pls (in this case 115.132.115100.2) you have.


Changes

Any Patches applied on 11.5.10.2 that changes the version of INVITPSB.pls from 115.132 to a later version. This problem does not occur if you have previously ran the "Generate Stock Locator Flexfield definition for Mobile transactions" Concurrent Request.

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