My Oracle Support Banner

Conflict Checking InsertS Records Into RPM_PROMO_ITEM_LOC_EXPL For Details With CC Error. (Doc ID 2294666.1)

Last updated on NOVEMBER 02, 2020

Applies to:

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


RPM_PROMO_ITEM_LOC_EXPL has records for worksheet promo component .

Steps to recreate:

  1. Create a regular item with price 10$.
  2. Create a Fixed price promotion for two location A and location B.
    • Location A with price 6 $.
    • Location B with price 20 $.
  3. Select both the component and approve the same.
  4. Note: The component with location B price 20 $ will not get approved due to CC error:"event_must_cause_price_to_decrease".
  5. Bring the location A component back to worksheet.
  6. Swap location A component fixed price to 20$ and then make location B component fixed price to 6$.
  7. Approve the both the component. The location A component stays in worksheet status with no conflict check message.
  8. Verify the table RPM_PROMO_ITEM_LOC_EXPL it has the information for 20$ for location A which is incorrect.


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.