My Oracle Support Banner

ReIM Consignment Invoice Rejection (Doc ID 2677575.1)

Last updated on JUNE 11, 2020

Applies to:

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


There is a difference of header and detail units,INVC_DETAIL(INVC_QTY) is not matching with INVC_HEAD(TOTAL_QTY).
Sales process is missing few transactions while inserting into INVC_DETAIL.

With regular sales, a sale transaction without discount ( Eg: 20$) and a subsequent transaction for the same item/loc with a discount record (Sale Price, 15$, Discount amount = 5$), total cost and qty in the Header (invc_head) is updating properly, but not creating a child record for the second transaction which is causing discrepancy between invc_head and invc_detail.

Steps To Recreate:

1. Load a Sale (POSU File) - For store - STORE_A, Date - 10/28/18, with Sku (Item setup with inventory_ind = 'N' and merchandise_ind = 'Y' in Item Master). Qty = 1
  A tran code 1 and tran code - 20 created and an entry is made in invc_head and invc_detail. Invc Head, Total qty = 1

  Day = 1, Tran date= 10/28, Load the POSU without Discount Record
  Run Batch Jobs:
  $RETAIL_HOME/oracle/proc/src/uploadsales.ksh $UP /batch/rms/data/in/ss/POSU_STORE_A_20191028000001_20191028.1
  $RETAIL_HOME/oracle/proc/src/salesprocess.ksh $UP

2. Move the vdate, load another sale for same Store, item, but tran date = 10/29/18 (same week). This file has 2 transactions for the same item each with Qty = 1
  a. transaction 1, has no discounts, price in file matches to price in price hist
  b. transaction 2, has a discount (discount type = 1005, Employee discount)

  Now, both transactions are loaded into tran data, each with tran code - 1 and tran code. But, when it comes to invc* table, only invc_head updates with total qty = 3, but invc_detail, has only with qty = 2, missing a record for different price.
  Day = 2, 10/29, LOad the POSU with SKU, first record no Disc Record, second record for same SKU, but with Discount record

  Run Batch Jobs:
  $RETAIL_HOME/oracle/proc/src/uploadsales.ksh $UP /batch/rms/data/in/ss/POSU_STORE_A_20191029000001_20191029.1
  $RETAIL_HOME/oracle/proc/src/salesprocess.ksh $UP

3. Check Data
  select * from invc_head where invc_id = XXXX;
  select * from invc_detail where invc_id =XXXX;

  Header details do not match with Detail level details. It is supposed to create another record with a cost from transaction with discount record, but it didn't.
  Items are with merchandise_ind = 'Y' and inventory_ind = 'N'




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

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