RTVs Are Not Flowing to ReIM in Case of Duplicate EXT_REF_NO Field in INVC_HEAD Table (Doc ID 1639800.1)

Last updated on OCTOBER 01, 2015

Applies to:

Oracle Retail Merchandising System - Version 12.0.10.5IN and later
Information in this document applies to any platform.

Symptoms

When attempting to run Electronic Data Interchange (EDI) upload batch the following error occurs:


Steps To Recreate:
1. Create 2 Return To Vendors (RTV's) with duplicate authorization number for the supplier for the same day.
2. Dispatch the RTV.
3. Run EDIDLINV batch( Edi Download batch).
3. Run the EDI Upload batch.Batch aborts with an error message.
4. Error will be mentioned as " 2014-01-02 04:50:49,109 ERROR [main] com.retek.reim.batch.ediupinv.threading.EdiUpload - Error: EDIUpload: The Vendor Document Number [2345670000-CRDNRQ-AUTH#102] is duplicate. Vendor Document Numbers have to be unique to the file and the vendors current document numbers in the system. Line: 23 order number:{3} and External Doc ID:{4}"

Cause

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 hundreds of Community platforms