Duplicate Price Records are Created in RPM_CLEARANCE_PAYLOAD Table for Back to Back Clearances (Doc ID 2000545.1)

Last updated on JUNE 09, 2016

Applies to:

Oracle Retail Price Management - Version 13.0.6 and later
Information in this document applies to any platform.

Symptoms


When a new clearance is defined for the next day of a previous clearance reset date, duplicate price records are created in the Retail Price Management (RPM) clearance payload table.


Sample Steps to Reproduce:

  1. Assume VDATE="Apr-08-2015" and use item '100000391'.
  2. Create the following clearance (clearance display ID is 10201/clearance_id is 563) with 10% off for one item/store:
Start date: Apr-08-2015
End date: Apr-12-2015

      3. Approve it.
      4. Run the following command; two records are found:

SELECT * FROM RPM_CLEARANCE_PAYLOAD WHERE ITEM = '100000391';

10242 15394 564 100000391 123 S 12-APR-15 17.7778 EA USD 564
10243 15394 563 100000391 123 S 08-APR-15 16 EA USD 564

      5. Move VDATE to "Apr-10-2015"
      6. Maintain the clearance created in step 1.  Change the reset date and out of stock date to "Apr-10-2015".
      7. Run query:

SELECT * FROM RPM_CLEARANCE_PAYLOAD WHERE ITEM = '100000391';
10244 15396 564 100000391 123 S 10-APR-15 17.7778 EA USD 564
10242 15394 564 100000391 123 S 12-APR-15 17.7778 EA USD 564
10243 15394 563 100000391 123 S 08-APR-15 16 EA USD 564

      8. Create a new clearance for the same item/location with the following data:

Clearance_display_id = '567'/Clearance_id = 10202'
Start date: Apr-11-2015
end date: Apr-12-2015

      9. Approve it.
    10. Run the following to identify duplicate records:

SELECT * FROM RPM_CLEARAMCE_PAYLOAD WHERE ITEM = '100000391';

10244 15396 564 100000391 123 S 10-APR-15 17.7778 EA USD 564
10242 15394 564 100000391 123 S 12-APR-15 17.7778 EA USD 564
10243 15394 563 100000391 123 S 08-APR-15 16 EA USD 564
10245 15398 564 100000391 123 S 12-APR-15 17.7778 EA USD 564
10246 15399 567 100000391 123 S 12-APR-15 17.7778 EA USD 567
10247 15399 566 100000391 123 S 11-APR-15 14.2222 EA USD 564
10248 15399 566 100000391 123 S 11-APR-15 14.2222 EA USD 567

Cause

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