Transactions stuck in Delivery Details with OM Interface = NO, but INV interface = YES (Doc ID 1537132.1)

Last updated on JUNE 21, 2023

Applies to:

Symptoms

WSH_DELIVERY_DETAILS shows many deliveries with OM Interfaced flag = N (no),  but INV interfaced flag = Y (yes)
This is not an expected state, since Interface Trip Stop processes OM Interface first, and if OM interface fails, INV interface is not attempted.
Customer needs to clean up this data inconsistency.

This issue was disclosed on an SR where many other delivery details were failing in Interface Trip Stop and both interfaced flags were N.
It is unclear whether ITS originally erred out or not, for these delivery details.

This would likely NOT prevent period close activities, since if Inventory Interface has completed successfully, there should not be any unprocessed shipping transactions in Inventory.

Changes

Cause

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