Running pin_ledger_report Twice For The Same Start And End Date Creates Duplicate Entries
Last updated on AUGUST 12, 2013
Applies to:Oracle Communications Billing and Revenue Management - Version 220.127.116.11.0 to 18.104.22.168.1 [Release 7.2.1 to 7.3.1]
Information in this document applies to any platform.
-- Problem Statement:
The 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 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.
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