My Oracle Support Banner

VFM Deal Has No Turnover If Activated on Same Day As Price Change Effective Date (Doc ID 1914096.1)

Last updated on MARCH 08, 2019

Applies to:

Oracle Retail Merchandising System - Version 13.0 and later
Information in this document applies to any platform.


If a Vendor Funded Markdown (VFM) deal is created and made active on the same day as the clearance item price change is made effective, Retail Merchandising System (RMS) will not create any turnover or income for the deal.

Steps to Reproduce:

  1. Create a VFM deal and have it be active the next day. Add an item to the deal with stock on hand.
  2. Go to RPM and create a clearance for that item from the deal. Have the clearance be effective the same day as the active date for the deal.  Any reason code can be used.
  3. Go to Maintain Price Changes screen and open the submitted price change using the price change display ID. Choose the Edit button to approve the price changes.
  4. Select status=Approve and update the price change.  Note the status as approved.
  5. Run the batch
  6. Verify the table RPM_PRICE_CHANGE and notice the status changed to pricechange.state.executed.
  7. Verify the table RPM_EVENT_ITEMLOC and confirm that the record is created for the price change.
  8. Run the
  9. Notice that record from RPM_EVENT_ITEMLOC table is deleted, but no record in RPM_EVENT_ITEMLOC_DEALS is created.




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.