Deadlock Issue While Running Pin_deferred_act (Doc ID 2618738.1)

Last updated on JULY 26, 2022

Applies to:

Oracle Communications Billing and Revenue Management - Version 12.0.0.1.0 and later
Information in this document applies to any platform.

Pin_deferred_act runs into a deadlock issue when it has to execute two scheduled actions in the below scenario.

Scenario:

Collections scenario is configured with two custom actions
An account is created and billed
After due date for payment, pin_collections_process is executed and the account enters Collections
Now there are two deferred actions created which are to be executed on the same day at the same time
On the deferred date, pin_deferred_act is executed to call the deferred actions
Below error seen in dm_oracle pinlog:

	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

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.