Layered Markdown Resets Create Duplicate Records in RPM_CLEARANCE_RESET (Doc ID 2406273.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Symptoms

In RPM 14.0.3, When a clearance reset is performed for multiple clearances against the same Parent Item/Diff/Store combination duplicate records are inserted in RPM_CLEARANCE_RESET.

Steps to reproduce:
--------------------------

1. Create an item with 2 colors C1 and C2 with regular price of $100.
2. Range it to store L1.
3. Now create the markdown M1 on color C1 at color - location level ( C1-L1) for $80.
4. Move VDATE to VDATE+2.
5. Now create the layered level markdown M2 on color C1 at color - location level ( C1-L1) for $50.
6. Move VDATE to VDATE+6 and make M2 effective.
7. Now reset both markdowns M1 and M2.
8. Notice that duplicate SKU-location records created in RPM_CLEARANCE_RESET.

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.