Implementation Guide for Oracle Self-Service E-Billing > Using the Reporting Engine >

Customizing Threshold Values for Batch Reporting

Oracle Self-Service E-Billling sets batch threshold values for Account Billing Overview and the Service Billing Overview reports by default. To implement this feature for other reports, you must specify the report threshold value, which determines the number of result set lines above which a report must process in batch mode instead of as an online download. Each report type uses this threshold value as follows:

• CSV. The report threshold value is the maximum number of output lines.
• PDF. A percentage of the batch threshold value (the default is 10%).
• XML. A percentage of the batch threshold value (the default is 20%).

For example, if the CSV report threshold is set to 3,000 result set lines, then a PDF threshold value set at 10% must process in batch mode when it has 300 or more result set lines

Table 42 shows the report XML file name and the report ID, found in the XML file, that you use to set batch report thresholds.

To specify a batch reporting threshold for a report

1. Add the following code before the <dataSource> tag in the report xml file, specifying the threshold value and the XML report ID:

   <batchCriteria threshold="10" reportId="batchCriteria_accounts">

   <query></query>

   <inputBindings name="input bindings name"></inputBindings>

   </batchCriteria>

2. You can also set the stopThreshold attribute. When you set the stopThreshold attribute, if the testing report result meets the stopThreshold value, the report engine withholds the report and displays the following message:

   The scope of the report you have requested is too large; reduce the number of periods, change your filter criteria, or change your hierarchy position.