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 JULY 05, 2019

Applies to:

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

Symptoms

ACTUAL BEHAVIOR

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.


EXPECTED BEHAVIOR

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


STEPS

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

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.