RPM UI Session Threads Block Each Other (Lock Contention Issue) During Chunking Process (Doc ID 2034543.1)

Last updated on APRIL 12, 2017

Applies to:

Oracle Retail Price Management - Version 13.2.6 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.

Symptoms

In Oracle Retail Price Management (RPM) 13.2.x, the UI session experiences a lock contention issue during the conflict checking chunking process.  When you to create or edit a promotion which undergoes chunking, the threads which are processing the chunks block each other. This happens when the promo volume is high and only when chunking is involved.


Steps to Reproduce:

  1. Set up the Logical Units of Work (LUW) so you will get the promotion into the chunk conflict checking process.
  2. Set up a simple promotion that would go to the chunk conflict checking process.
  3. Populate the RPM_PE_CC_LOCK table with the element of the merchandise hierarchy (e.g., SKULIST or DEPT or DEPT/CLASS or DEPT/CLASS/SUBCLASS) and zone_id that you used to set up the promo in step 2.   Alternatively, you can see if the RPM_PE_CC_LOCK table is populated with some records and choose the merch hierarchy (e.g., SKULIST or DEPT or DEPT/CLASS or DEPT/CLASS/SUBCLASS) and zone_id to set up the promo in Step 2.
  4. Approve the promotion that you created in step 2 (and make sure that it is going to chunking).  You will see the lock contention issue.

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