When Approving a Simple Promotion With High Volume of Data, Promo Remains in Conflict Checking Status (Doc ID 2081932.1)

Last updated on MAY 12, 2017

Applies to:

Oracle Retail Price Management - Version 13.2.4 and later
Information in this document applies to any platform.
Checked for relevance on 12-May-2017

Symptoms

In Oracle Retail Price Management (RPM) 13.2.4, when approving a simple promotion with a high volume of data, we observe that the promotion remains in conflict checking status, yet some of the item/locations are published.


Steps to Reproduce:

  1. Create a promotion header.
  2. Create a simple component.
  3. In Component Detail, add Dept/Class with equivalent of 6132 SKU level items, and Zone with equivalent of 196+ locations.
  4. Select 25% Discount that applies to Regular only.  Apply and Save.
  5. In Component screen, select 'Approve' and submit.
  6. After 10 hours, the promo is found stuck in Conflict Checking status.  Even though it is stuck, there 3000+ Item/Loc records have been published to RPM_ORPOS_SIMPLE_PROMO_PUBLISH table.  These would be exported to ORPOS with incomplete data.

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