RPM Promotion Injector Gets Deadlocks (ORA-60) And Foreign Key Violations (ORA-2292)
Last updated on DECEMBER 03, 2017
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
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