My Oracle Support Banner

Questions on RPM_PE_CC_LOCK Table (Doc ID 1630870.1)

Last updated on DECEMBER 04, 2023

Applies to:

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

Purpose

 Initially, got an error when trying to "Create a clearance for tomorrow at price zone".

Found locking records in RPM_PE_CC_LOCK table and could solve the problem by purging those records.

A series of questions followed....

Questions and Answers

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
Purpose
Questions and Answers
 When or in which scenario are records written to the lock table?
 Is it used for handling only user conflict errors? What else?
 Is there any systematic process to remove the locks?
 If it is not a systematic purging, what should be the right actions to do the purge from a business perspective?
 For what conflict check types are locks created?
 In which failure scenarios, will the locks not be removed?
 How do you clean the locks properly?
References

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