Inventory Interface Failing for Some Deliveries (Doc ID 754528.1)

Last updated on AUGUST 31, 2016

Applies to:

Oracle Shipping Execution - Version 11.5.10.1 to 12.1.3 [Release 11.5.10 to 12.1]
Information in this document applies to any platform.
***Checked for relevance on 18-Feb-2012***
***Checked for relevance on 10-SEP-2014***
Executable:WSHINTERFACE - Interface Trip Stop


Symptoms

On 11.5.10.2 in Production:
When running the interface trip stop the following error occurs.


ERROR
P_MODULE_NAME ==> wsh.plsql.WSH_SHIP_CONFIRM_ACTIONS.INV_INTERFACE_TRIP_STOP
msg_buffer ==> Inventory Interface could not process some of the lines in the batch as they are locked by another process.


STEPS
The issue can be reproduced at will with the following steps:
1. Enter order
2. Book and pick order/lines
3. Run Ship confirm and Interface trip stop for delivery

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