My Oracle Support Banner

Sales Order Additional Information Form is Showing Delivery Data Related to Other Sales Orders (Doc ID 2713070.1)

Last updated on MARCH 09, 2021

Applies to:

Oracle Order Management - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms



ACTUAL BEHAVIOR
When we see the deliveries data from sales order > actions > additional information some of the deliveries lines are showing which are not associated with that sales order.
On analysis we found that the ones which are not related to sales order and still showing are of the source RTV from wsh_delivery_detail because looks like the source_header_id for source OE and RTV are same. How to avoid is overlapping of source_header_id between the sources and how to make sure Sales order shows data only from source OE from wsh_delivery_details.

 

EXPECTED BEHAVIOR
Expect to see only specific Sales Order data.

STEPS
The issue can be reproduced at will with the following steps:
1. Responsibility: Order Management Super user
2. Navigate: Orders Workbench, Order Organizer > Query Sales Order > Actions > Additional Information >
3. You can see some of the deliveries lines are showing which are not associated with that sales order.

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.