Ledger Report Export Taking Too Long with Numerous Segments Involved
Last updated on NOVEMBER 08, 2016
Applies to:Oracle Communications Billing and Revenue Management - Version 184.108.40.206.0 to 220.127.116.11.0 [Release 7.3.1]
Information in this document applies to any platform.
***Checked for relevance on 29-Mar-2013***
Checked for relevance on 08-Nov-2016.
A configuration defines 156 segments to be exported with 5 reports each. There were a total of 263 segments (including the 156 to be exported).
When running the export for a posting period, 3 of the 5 reports per segment took multiple minutes each to execute, even with no data associated to that segment (ever). The aggregate time to complete the export has varied from several hours to over a day just after one posting period of 100,000 accounts.
The problem has been tracked to 3 specific report types:
1. Unbilled Unearned
2. Billed Unearned
3. Prev Billed Earned
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