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

(Doc ID 1359999.1)

Last updated on FEBRUARY 26, 2018

Applies to:

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


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.


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