ITEM_LOC Not Updated with Reset Record when Promotion Ends

(Doc ID 2020571.1)

Last updated on JUNE 09, 2016

Applies to:

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


In Oracle Retail Price Management (RPM) 13.2.8 and above, when a promotion ends, ITEM_LOC is not updated with the reset record in Retail Merchandising System (RMS).

Steps to Reproduce:

1. Log in to RPM.
2. Create and apply a clearance to an item/location combination without clearance reset.
3. Create and apply a promotion which applies to that item/location, which applies to Clearance items only.
4. Run Price Event Execution (PEE) & PEERMS batches.  Now the promotion is active.
5. Reset the clearance before the promotion ends.
6. Run PEE & PEERMS batches. Clearance reset is executed.
7. Promotion has ended as the clearance has ended.
8. Note that the promo_retail on item/loc has not been updated to be null in the ITEM_LOC table.  Instead, it is updated with the regular unit retail although the promotion has ended


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