Invoice From A Consignment Item Sale Fails To Upload Into ReIM
Last updated on DECEMBER 01, 2017
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.
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