My Oracle Support Banner

DSNO File Contains Incorrect Item Cross Reference Value (EDI OUTBOUND 856) (Doc ID 1678513.1)

Last updated on JULY 02, 2018

Applies to:

Oracle Shipping Execution - Version 11.5.10.2 to 12.2.4 [Release 11.5.10 to 12.2]
Information in this document applies to any platform.

Symptoms

As part of the Order Fullfillment process, we are generating EDI outbound files for ASNs (EDI 856). Some trading partners have issues in the DSNO file generated.
The DSNO file has the incorrect item cross reference value. This is causing our trading partner to reject the files sent.



Actual Behavior
-------------------
Customer orders an item either by ISBN OR EAN.
Corresponding values for each type in Item cross reference table is maintained.
If the customer places the order by ISBN, then DSNO file should show corresponding cross reference value.
Currently what is happening is it is picking any one of the cross references while generating the file.
The DSNO file has the wrong value in line 90, record 7000, column 898.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Order Management Super User Responsibility
2. Create and book order with item cross reference
3. Shipping> Releases Sales Order
4. Transactions > Ship Confirm
5. DSNO file has incorrect cross reference value

Changes

 

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!


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