My Oracle Support Banner

SALESPROCESS.KSH Incorrectly Populate INVC_HEAD/INVC_DETAIL For Consignment Item (Doc ID 2721197.1)

Last updated on NOVEMBER 09, 2020

Applies to:

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

Symptoms

SALESPROCESS.KSH Incorrectly populate INVC_HEAD/INVC_DETAIL table for consignment item.

Steps To Recreate:

Scenario #1:

1.Find items with inventory_ind = N and Merchandise Ind = Y, and dept has profit_calc_type = 2 and purchase_type = 1.
2.Load POSU file for price - 19, qty = 1 and for Tran Date= 30-Apr-2019. you will see tran code = 1 and 20 in tran data. Take the ref_no_1 in tran _data from tran code = 20 record and check invc_head and invc_detail, total_merch_cost and total_qty matches to       invc_unit_cost and invc_qty in invc_detail. Run the following batches: uploadsales.ksh and salesprocess.ksh.
3. Load another POSU file for same location and item, tran date = 29-Apr-2019, for sale price = 18 and qty = 1. You will see another detail record created for the item with different cost and total_merch_cost and total_qty in invc_head gets updated. INVC_HEAD        and INVC_DETAIL both still matches. Run the following batches: uploadsales.ksh and salesprocess.ksh.
4. Now upload Sale Reversal, for tran date= 30-Apr-2019, sale price = 19, qty = -1, the invc_detail created in step#3, gets updated, invc_qty gets reduced, but total_merch_cost and total_qty in invc_head are increased by positive amount and Quantity instead of      reducing. Run the following batches: uploadsales.ksh and salesprocess.ksh.

Scenario #2:
1. Create a sale transaction with a consignment item for a store.
2. Notice the item entries in INVC_DETAIL table with the respective unit costs.
3. Upload transaction with the same item twice with different costs.
4. Notice that new entry for the item with different unit cost is not added to the INVC_DETAIL table.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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