NewItemLocBatch Performs Unnecessary Lock Checks (Doc ID 1644930.1)

Last updated on JUNE 14, 2017

Applies to:

Oracle Retail Price Management - Version 13.2.6 and later
Information in this document applies to any platform.
Checked for relevance on 14-June-2017

Symptoms

Running Oracle Retail Price Management (RPM) 13.2.6 Batches.

You are experiencing a performance issue while running newitemlocbatch in Retail Price Management (RPM).
This appears to occur when the batch does conflict checking for event inheritance.

The issue can be reproduced at will with the following steps:
1. Create a promotion event for a particular dept.
2. Create data for newItemLocBatch including item-locs from this dept.
3. Run newItemLocBatch with tracing enabled.
Notice that the checks for locks takes a significant amount of time.



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