Price Change and Clearance Overlapping a Promotion Is Recalculated Incorrectly in SIM (Doc ID 2073734.1)

Last updated on APRIL 20, 2021

Applies to:

Symptoms

In Store Inventory Management (SIM), Price Change and Clearance overlapping a Promotion is recalculated incorrectly.


Steps to Reproduce:

1. Select an item-location combination
2. Create a simple promotion
3. Create a price change or a clearance in Retail Price Management (RPM) for the same item location combination for a date overlapping the promotion
4. Note that the unit retail for the promotion in RK_PRICE_CHANGE table is calculated correctly
5. Bring the promotion back to worksheet status and re-approve the promotion with modification to unit retail
6. Note the unit retail for the promotion in RK_PRICE_CHANGE table is incorrectly updated

Changes

Cause

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