NewItemLocBatch Performs Unnecessary Lock Checks
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
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.
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