PIN_ERR_DEADLOCK Error - Pin_mass_refund On An Account With Multiple Billinfo's With Negative (Credit) Balances (Doc ID 2656651.1)

Last updated on APRIL 14, 2020

Applies to:

Symptoms

On Oracle Communications Billing and Revenue Management (OC-BRM/BRM) 7.5.0.22.0, when executing pin_mass_refund for an account having multiple billinfo's with negative (credit) balances, /item/refund is created for only one of the billinfo's and for the rest of them is failing with the following error.

Payment method for this account is "Credit card".

As an workaround pin_mass_refund can be executed multiple times until /item/refund is created for all eligible billinfo's.

Expectation is that all the "/item/refund" objects must be created in a single "pin_mass_refund" run.

The issue can be reproduced at will with the following steps:

1. set pin_virtual_time to be in sync with system time (4-feb-2020)
  pin_virtual_time -m0
  
2. Created an account with 2 CC billing profiles, each having a cycle charge. payment method is set as "credit card"

3. move pvt to 5-mar-2020
  pin_virtual_time -m2 030514442020
  
4. run pin_bill_accts :
  pin_bill_accts -verbose

5. run pin_collect:
  pin_collect -verbose -pay_type 10003 -vendor fusa -active
  
6. adjust (credit) each of two cycle forward events so that balance of each balance group will become negative

7. run pin_mass_refund:
  pin_mass_refund -active -pay_type 10003 -verbose

Changes

Cause

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