My Oracle Support Banner

Pending Interface Flag For Trip Stop Resets To Null Due To Inventory Interface Flag Is Null in WSH_DELIVERY_DETAILS Table (Doc ID 2324137.1)

Last updated on JUNE 07, 2021

Applies to:

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



Find that the order data is in the following status when viewing the HTMomse.sql order output:

-Order line is closed.
-Associated Delivery Detail is in a shipped status.
-Delivery is closed.
-Trip stop is closed with pending interface flag value = null.
-OM Interface flag = Y for the delivery detail.
-INV Interface flag = P or N for the delivery detail.

In the Shipping Transaction Form, the delivery detail shows the 'Next Step' as 'Run Interfaces'.
When attempting to run Interface Trip Stop, the delivery is unavailable to select in the parameters.
The item's on hand quantity has not been deducted for the line's ordered quantity.


Expect the delivery detail status to be interfaced OM and Inventory and item's on hand quantity deducted.


The issue cannot be reproduced at will due to data corruption.


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

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