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.

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.

  Note:

  If you are managing migration between two environments, and have custom reports, you may need to update the query definitions of the custom reports in the target environment. This is because the internal IDs for objects may change during the migration. However, in case of Oracle managed migration, there will not be any change in the internal object IDs, so query definitions need not be updated.