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

Last updated on NOVEMBER 09, 2015

Applies to:

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

Symptoms

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

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