My Oracle Support Banner

Orphan Records in WF_ITEMS Table for Item Type 'WSHDEL' (Doc ID 2870988.1)

Last updated on OCTOBER 06, 2023

Applies to:

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


On : 12.2.5 version

Orphan records are getting created for item_type 'WSHDEL' in WF_ITEMS table. Corresponding delivery_ids does not exist in the system.
WSHDEL workflow had been created for a non existing delivery.
The deliveries do not exist in table WSH_NEW_DELIVERIES.

Expects that orphan records should not get created

The issue can be reproduced at will with the following steps:
1. Responsibility : Oracle Order Management
2. Navigate to Shipping > Release Sales Orders
3. Run Release sales Orders




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.