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

Generating Custom Reports

You can create custom reports in addition to using the predefined reports in Reconciliation Compliance or Transaction Matching.

The Service Administrator can create custom reports by default. Other users who are assigned the Reconciliation Manage Reports role can also create custom reports. See Account Reconciliation Application Roles in Administering Access Control for Oracle Enterprise Performance Management Cloud.

Building custom reports in either Reconciliation Compliance or Transaction Matching involves the following steps:

  • Create a query whose definition can then be exported as an XML file. For a Reconciliation Compliance or Transaction Matching query, see Creating a Query.

  • Create a template (which must be in RTF format) by importing the XML file into Word. See Creating a Template

  • Set up a report group to group individual reports. See Creating a Report Group

  • Optionally, set up the report definition. See Creating a Report Definition

  • Once a custom report has been built, the service administrator or other users given access can generate the report which uses both the query and the template you created. The report can be set with a default output of XLSX, HTML, PDF, CSV, or CSV (Formatted). See Generating the Report

    Note:

    PDF output will limit the number of columns it can display to the width of the paper size selected. If you have more columns that can fit on your selected paper size, we advise you to use another output format like html or xlsx.