Invoice From A Consignment Item Sale Fails To Upload Into ReIM
(Doc ID 2334226.1)
Last updated on MAY 17, 2021
Applies to:Oracle Retail Merchandising System - Version 14.1 and later
Information in this document applies to any platform.
The Invoice information extracted from RMS to a flat file fails to upload into ReIM by the reimediinjector batch. Records are failing with DUP_VEND_DOC_NUM - Duplicate Vendor Document Number
1) Create a POSU file for two consignment items with 3 transactions. Lets Say Item A and Item B
Transaction 1: Item A /1 Qty
Transaction 2: Item B /1 Qty
Transaction 3: Item A /1 Qty
2) Process the sales file.
Actual result: TRAN_DATA table - only two receipts are created for three sales.
Expected result: TRAN_DATA table - 3 receipts for 3 sales.
3) Check the INVC_HEAD and INVC_DETAIL table. Notice that three invoice records created. PO 1/Item B and two PO 2/Item B records.
4) Run the EDIDLINV job to extract the Invoice information from RMS.
5) Process the extracted file in ReIM.
Result: PO 1/ Invoice got processed successfully. Two PO 2/Item B is failed with an error Duplicate Vendor Document Number.
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