My Oracle Support Banner

Item_loc Selling Retail Updated Incorrectly When Price Change And Clearance Reset Approved On Same Day (Doc ID 2249905.1)

Last updated on MARCH 09, 2019

Applies to:

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


in 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 .


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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