Oracle Account Reconciliation (AR):

Administrator (3 days)

Learning Objectives

By the end of this course you will be able to create and manage Oracle’s Account Reconciliation Cloud applications to help streamline close processes and deliver insight about the real-time status of account reconciliations.

Course Description

Oracle Account Reconciliation helps manage account reconciliation processes. Find out how to keep track of preparer and approver assignments. Understand how workflow support for the account reconciliation process provides monitoring, reporting and analysis and get instant visibility into the progress and status of the reconciliation lifecycle.

This three-day course provides attendees with extensive hands-on experience of working with Oracle’s Account Reconciliation. Find out how to manage Account Reconciliation compliance processes and explore the automation of high volume/labour-intensive Transaction Matching.

Discover how to automate the preparation of large scale reconciliations and integrate results into the tracking features within Reconciliation Compliance. This powerful cloud service saves time with reconciliations while improving quality and reducing risk.

Explore how Task Manager can be used to define repeatable tasks as part of a structured workflow and use intelligent process automation (IPA) to run tasks without user intervention.

Learn how to use EPM Automate commands to create and automate various items in ARCS such as importing balances and transactions, and creating reconciliations.

Course Information

Audience: Implementation consultants, developers and technical system administrators

Duration: 3 days

Pre-requisites: None

Delivery method:

Advanced preparation: None

Recommended CPE credits: 21 credits 

Day Summary

Day 1: System Maintenance and Reconciliation Compliance: Navigation, worklists, configuration, periods, formats and profiles, adjustments, Data Management, exporting data, drill down, run reports, configuration, maintenance window and security.​

Day 2: Transaction Matching: Match types, data sources, transaction types, the matching process, reconciliations, importing data, auto matching, adjustments.

Day 3: Task Manager and EPM Automate: Creating templates and schedules, managing connections, export and import tasks, editing templates, intelligent process automation (IPA) dashboards and reports, EPM Automate.

Detailed Agenda

System Maintenance

  • Creating Applications

  • Application Configuration

  • Daily Maintenance

  • Security and Roles


Reconciliation Compliance

  • Access and Navigation

  • The Process for Reconciliation Compliance

  • Worklists and Reconciliations

  • Configuration Options

  • Create Periods

  • Create Predefined Formats

  • Create Profiles
    Profiles are used when creating reconciliations and determine the workflow access.

  • Create Reconciliations from Profiles
    Reconciliations are created for the selected period for all active profiles that have a frequency that matches the period.

  • Importing Pre-Mapped Data
    Transactions can be imported into a reconciliation.

  • Create and Extract Adjustments

  • Introducing Data Management
    Data Management is used with AR as the recommended way of loading high volumes of transactions.

  • Data Management Integration Setup

  • Export Data and Drill down

  • Changing a Period’s State

  • Closing and locking periods

  • Checking for Missing Reconciliations
    This action checks to ensure that reconciliations exist for all the necessary profiles.

  • Monitor the Status of Reconciliations

  • Use the Overview and Compliance Dashboards to monitor performance metrics.

  • Submitting, Approving and Rejecting Reconciliations

  • Updating Reconciliation Attributes

  • Reassignment Requests

  • Running Reports

  • Export Adjustments
    Export adjustments or transactions to create two-sided journal entries that can then be imported into your source system.

  • Create Global Adjustments and Support Attributes
    Discover how to create attributes that can be used for all adjustment, support and matching types in the ARCS application.

  • Map Attributes to Journal Attributes

  • Exporting Job history


Account Reconciliation and Task Manager
Define repeatable tasks as part of a structured workflow.

  • Create Templates

  • Managing Connections

  • Adding AR tasks to templates

  • Creating Schedules
    Once AR tasks have been integrated into a template, they can be deployed for use by creating schedules.

  • Intelligent Process Automation
    Use intelligent process automation (IPA) to run tasks without user intervention.

  • Export and Import Tasks

  • Task Manager Dashboards and Reports


EPM Automate
Learn how you can use EPM Automate commands to create and automate various items in ARCS such as importing balances and transactions and creating reconciliations.


This course is offered through our strategic partnership with Keyteach, using state-of-the-art technology and a live Cloud environment for hands-on labs. Contact us to schedule a private class, or view the public class schedule.

Color logo - no background.png