My Oracle Support Banner

Ship Sets Causing Pick Release To Fail - Error in Routine WSH_USA_INV_PVT.Update_Inventory_Info (Doc ID 2585486.1)

Last updated on MARCH 07, 2023

Applies to:

Oracle Shipping Execution - Version 12.2.6 and later
Oracle Order Management - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

Pick release is failing for order lines having ship sets with the following error:


ERROR
-----------------------

msg_buffer ==> Error in Routine WSH_USA_INV_PVT.Update_Inventory_Info,  Oracle Error - 100
ORA-01403: no data found
            U:Error in Routine WSH_USA_INV_PVT.Update_Inventory_Info,  Oracle Error - 100
ORA-01403: no data found
          Exiting WSH_UTIL_CORE.ADD_MESSAGE (03/13/2019 01:55:17 PM,  0 seconds)
        Exiting WSH_UTIL_CORE.DEFAULT_HANDLER (03/13/2019 01:55:17 PM,  0 seconds)
        Unexpected error has occured. Oracle error message is ORA-01403: no data found


STEPS
-----------------------
1. Order Management Super User Responsibility

2. Navigate to MENUPATH > Shipping > Release Sales Orders

3. Pick Release Order having Ship Set associated on the Lines.

Cause

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
Symptoms
Cause
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.