Invoice From A Consignment Item Sale Fails To Upload Into ReIM

(Doc ID 2334226.1)

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.

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

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