Item_loc Selling Retail Updated Incorrectly When Price Change And Clearance Reset Approved On Same Day

(Doc ID 2249905.1)

Last updated on APRIL 03, 2017

Applies to:

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


RMS item_loc selling retail is not updated correctly when a price change and clearance reset is created and approved on the same day.

Steps to reproduce :

  1. Create a clearance for an item and approve the same without reset date.
  2. Run the priceEventExecutionBatch and priceEventExecutionRMSBatch batch.
  3. Verify the RPM_FUTURE_RETAIL, ITEM_LOC, PRICE_HIST tables  has the clearance information.
  4. Advance the vdate and edit the clearance and add a clearance reset vdate+1.
  5. Create a price change for the same item with the effective date as vdate+1.
  6. Run the priceEventExecutionBatch and priceEventExecutionRMSBatch batch.
  7. The item_loc selling retail of RMS is not updated correctly . Price change record is not updated .




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