Running Parallel Instances Of Pin_bill_day Script Results In Duplicate Invoices
Last updated on DECEMBER 14, 2017
Applies to:Oracle Communications Billing and Revenue Management - Version: 126.96.36.199.0
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
POID_ID0 BILL_NO ACCOUNT_OBJ_ID0 BILL_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