Running pin_ledger_report Twice For The Same Start And End Date Creates Duplicate Entries
(Doc ID 558929.1)
Last updated on OCTOBER 30, 2019
Applies to:Oracle Communications Billing and Revenue Management - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
-- Problem Statement:
A duplicate entry is created in ledger_report_accts_t table when running pin_ledger_report twice with the same input parameters.
-- Steps To Reproduce:
Note: Date Format: MM/DD/YY
1.Create an account with any service on 03/01/2008 and make sure every Resource ID has a GLID (General Ledger ID) assigned.
2. Set pin_virtual_time to 04/01/2008.
3. Run billing
4. From ~/sys/test directory, run the following command:
5. Use sqlplus to login to the Portal database, and check count of the following tables.
The count will be 1 for each table.
select count (*) from ledger_report_accts_t;
6. Repeat step #4
7. Repeat step #5, the count for each table will be 2.
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