Wrong Quantity Getting Updated In INVC_DETAIL Table For Consignment Item Sale or Return (Doc ID 2305605.1)

Last updated on SEPTEMBER 19, 2017

Applies to:

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

Symptoms

When trying to create multiple sale/return transactions for the same consignment item with same unit cost, the values from INVC_QTY column INVC_DETAIL table are incorrectly updated.
All unit cost value entries from INVC_QTY column INVC_DETAIL table are updated, instead of only the particular unit cost for which latest transaction has been done.


Steps to recreate:

  1. Create a sale/return transaction for consignment item.
  2. Run the necessary Retail Sales Audit (ReSA) and Retail Merchandising System (RMS) export/import batches.
  3. Check TRAN_DATA, INVC_HEAD, INVC_DETAIL and ORDHEAD tables.
  4. Again create a sale/return transaction for same item with different unit cost and run the necessary batches.
  5. Check again the mentioned tables (TRAN_DATA, INVC_HEAD, INVC_DETAIL and ORDHEAD)
  6. Create a sale/return transaction for same item and unit cost same as any one of the previous two unit costs.
  7. Run the necessary batches.
  8. Notice that in INVC_DETAIL table quantity got updated for all unit cost entries, instead of the particular unit cost for which latest transaction has been done.

Changes

 

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