Pricing Cost Is Calculated Incorrectly in FUTURE_COST Table, Without Regard to PRICE_COST_APPL_IND Value
(Doc ID 1361612.1)
Last updated on FEBRUARY 02, 2022
Applies to:Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.
In Retail Merchandising System (RMS), the FUTURE_COST table is calculating PRICING_COST without considering the PRICE_COST_APPL_IND value.
Steps to Recreate:
1. Create an item with UNIT_COST = 100
2. Create 2 BillBack Rebate deals.
First one = price cost apply indicator unchecked, value = 20
Second one = price cost apply indicator checked, value = 40
3. Run the deals batches (fcthreadexec, fcexec pre, fcexec)
4. Check the FUTURE_COST table.
The PRICING_COST = 40
Its calculation is as: 100 - 20 - 40 = 40
But, since PRICE_COST_APPL_IND = N for the first deal, the PRICING_COST should be 100 - 40 = 60.
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