My Oracle Support Banner

RPM Promotion Injector Gets Deadlocks (ORA-60) And Foreign Key Violations (ORA-2292) (Doc ID 1917158.1)

Last updated on FEBRUARY 22, 2019

Applies to:

Oracle Retail Price Management - Version 13.2.6 and later
Information in this document applies to any platform.


Rpm promotion injector gets deadlocks (ORA-60) and foreign key violations ORA - 2292

Instructions to Re-create :

1. Set up the same item/locs as 2 different components detail in the same promo_id.
2. Change rpm_batch_control table to run the injector batch in 2 threads and luw count as 1
3. Make sure one component fails with some validation and other passes
4. Run injector price event batch.
Note :- batch fails with unique constraint error




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.