Pending Interface Flag For Trip Stop Resets To Null Due To Inventory Interface Flag Is Null in WSH_DELIVERY_DETAILS Table
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.
On : 12.1.3 version, WMS, Shipping & Transportation
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.
Expect the delivery detail status to be interfaced and item's on hand quantity deducted.
The issue can be reproduced at will with the following steps:
1. Data corruption, unable to reproduce this issue.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms