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

Last updated on AUGUST 09, 2017

Applies to:

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

Symptoms

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.

Changes

 

Cause

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