Transaction Discount Value is Calculated Incorrectly in LE_HST_TL Table for Layaway Pickup Transaction
Last updated on APRIL 05, 2017
Applies to:Oracle Retail Point-of-Service - Version 14.1.2 and later
Information in this document applies to any platform.
Transaction discount value is incorrectly updated in CP_DSC_MSC_TOT column of table LE_HST_TL for the layaway pickup transaction.
Steps to reproduce:
1. Create promotion BuyNofXforZ$off on transaction level.
2. Buy 2 quantity of 42 at 5 $ off .
3. Create layaway transaction ,Scan a Item:42 (Quantity=2) 5 $ discount got applied on both the quantity each of 2.5 $.
4. Now complete the transaction. In Mo_Mdfr_Rt_Prc column of TR_MDFR_SLS_RTN_PRC table two insert came of 2.5 $.
5. Now do layaway pickup of that layaway transaction again 2 insert came in TR_MDFR_SLS_RTN_PRC table of 2.5 $ discount each.
6. But in CP_DSC_MSC_TOT column of LE_HST_TL table has 10$ discount added whereas it should increase by 5 $ which is the discount amount.
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