My Oracle Support Banner

NewItemLocBatch Performs Unnecessary Lock Checks (Doc ID 1644930.1)

Last updated on MARCH 13, 2019

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


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.




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

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