My Oracle Support Banner

Promotions Published Multiple Times When PromotionPriceChangePublishBatch Batch Is Multithreaded (Doc ID 2655538.1)

Last updated on APRIL 06, 2020

Applies to:

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

Symptoms

Promotions are published multiple times when PROMOTIONPRICECHANGEPUBLISHBATCH batch is multithreaded

Steps to reproduce:

  1.  Create and approve 8 simple promotions with same 4 items and different locations per promo.
  2.  Update the thread_num and thread_luw_count. Set THREAD_NUM to 2 and THREAD_LUW_COUNT to a lower value such as 2 or 6.
  3.  Check that the promotions are available in the RPM PAYLOAD tables
  4.  Execute PROMOTIONPRICECHANGEPUBLISHBATCH 
  5.  Check the RPM_PRICE_PUBLISH_DATA table. Notice that there are promotions that are to be published multiple times.

Cause

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
Symptoms
Cause
Solution
References


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