Invoice From A Consignment Item Sale Fails To Upload Into ReIM (Doc ID 2334226.1)

Last updated on APRIL 19, 2023

Applies to:

Symptoms

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

Steps:
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.

Cause

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