Running Parallel Instances Of Pin_bill_day Script Results In Duplicate Invoices

(Doc ID 731884.1)

Last updated on DECEMBER 14, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version:
This problem can occur on any platform.


-- Problem Statement:
When pin_bill_day script runs in more than one instance, some invoice objects get duplicated.

-- Steps To Reproduce:
1. Create 2 accounts.
2. Run pin_bill_day in 2 instances, simultaneously for first billing cycle.
3. A duplicate invoice object will get created which can be seen in database for the same bill object.

The following query shows the dublicate object:

select poid_id0,bill_no,account_obj_id0,bill_obj_id0 from invoice_t where account_obj_id0

356771      B1-182     12345                         359778
370061      B1-236     12345                          361023
363006      B1-182     12345                         359778
367565      B1-186     12345                         357218


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