1. Administering Account Reconciliation
  2. Performing Common Actions in Account Reconciliation Cloud
  3. Using Reports
  4. Generating Custom Reports
  5. Generating the Report

Generating the Report

Generating reports is the final step in the process. Once a Service Administrator has built the custom report, any user granted access can generate the report.

A Service Administrator can also use REST API commands to generate a report. For detailed information, see Generate Report for Account Reconciliation in REST API for Oracle Enterprise Performance Management Cloud. For large reports, the runAsync parameter for report generation in REST API allows reports to run asynchronously (value of true).

Note:

See Settings for Reports in Setting Up and Configuring Account Reconciliation.

To generate reports:

  1. From Home, select Reports.
  2. Select the report group from the drop down. You can use the quick Search option to find a report under a selected group.
  3. Select the reports you want to generate in the report group and then select the format:
    • XLSX - not supported for graphs.
    • HTML - not supported for graphs and charts.
    • PDF
    • CSV - does not use template and is better at faster data retrieval.

      Note:

      For reports that contain more than 10,000 records, it is recommended to use the CSV format.
    • CSV (Formatted) - is best suited for a simple data table with formatted data and does not support images, graphics, or styling in the template.

      Note:

      The CSV (Formatted) format takes additional time to generate the report to honor template formatting when compared to the CSV format. Therefore, you can select CSV to generate the data quickly or CSV (Formatted) to generate formatted template based data.

  4. Click Generate.
  5. Optional, if there are parameters to enter, select the value.

    Note:

    For more information on parameters, see Generate Report for Account Reconciliation in REST API for Enterprise Performance Management Cloud
  6. Click Generate.

    You will see a completed successfully message.

    Note:

    • You can use the Back button to preserve the parameter values that you have selected and regenerate the report.
    • You can use the Reset button to clear the parameter values that you have selected and regenerate the report.
  7. Select Open or Save File to save the ZIP file.

The report generation process uses a backend job framework that runs report jobs in the background. If the report has an error, for example, if the size is greater than the recommended size, you see a message stating the error in the Generate Report dialog before the report is generated. For reports with very large number of records, it is recommended to use filtering to break the report down to lesser records.