Generating the Report

Generating reports is the final step in the process. After a Service Administrator has built the custom report, any user or group or team 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 Financial Consolidation and Close and Tax Reporting 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).

To generate reports:

  1. From the Home Page, click Reports.

  2. Click the Task Manager Reports tab.
  3. Select the report you want to generate. You can use the quick Search option to find a report under a selected group.
  4. For Output Format, select from the following:
    • xlsx: Not supported for graphs.
    • html: Not supported for graphs and charts.
    • pdf
    • csv: Does not use a 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) output option 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.

  5. Click Generate.
  6. Enter the Name, and then select the Schedule and Period from the drop down menus.
  7. Click Generate.

    When done, the system displays a "Completed Successfully" status message.

    Note:

    • Click Back to preserve the parameter values that you have selected and regenerate the report.
    • Click Reset to clear the parameter values that you have selected and regenerate the report.
  8. Select Open with 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 fewer records.