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 NOVEMBER 09, 2017

Applies to:

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

Symptoms

On : 12.1.3 version, WMS, Shipping & Transportation

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 = 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 and item's on hand quantity deducted.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Data corruption, unable to reproduce this issue.

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