Ledger Report Export Taking Too Long with Numerous Segments Involved

(Doc ID 1082823.1)

Last updated on NOVEMBER 08, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version to [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