My Oracle Support Banner

Inventory Interface Failing for Some Deliveries (Doc ID 754528.1)

Last updated on MARCH 12, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.