Deadlock Error If Usage Loading (Pin_rel) And Bill Run Are Executed Concurrently (Doc ID 1359999.1)

Last updated on MARCH 29, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.0 and later
Information in this document applies to any platform.
*** Checked for relevance on 09-09-2013 ***

Goal

Some of the bills are not generated in production if usage loading (pin_rel) and bill run (pin_bill_day) are executed concurrently.
Deadlock error messages in the logs indicate that some of the DB tables are locked by the pin_rel process.
We are running pin_rel with loading method Direct and as per our understanding, this will lock the partition of some of the tables while loading successfully rated CDRs.


Solution

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