Threaded Promotion Does Not Go to Approval and System Hangs (Doc ID 1092536.1)

Last updated on SEPTEMBER 02, 2015

Applies to:

Oracle Retail Price Management - Version 12.0.8 and later
Information in this document applies to any platform.
Checked for relevance on 06-September-2013


We are experiencing a performance issue when processing a large amount of data (around 4000 Item/Locations) for promotions.  The system hangs and the user has to manually kill the session.

Steps to Recreate:

1. Ensure that multithreading of RPMTaskMDB is implemented.
2. LUW_COUNT = 1000 in RPM_BATCH_CONTROL table for:
3. Create a simple promotion with 4000 item/locations.
4. Approve the promotion.

Notice that the promotion does not get approved and the system hangs.


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