Account Reconciliation Cloud (ARCS)

Oracle Account Reconciliation (ARCS): Administrator (3 days)


Implementation consultants, developers, system administrators

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 Cloud 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.

Day summary

  1. System Maintenance and Reconciliation Compliance: Navigation, worklists, configuration, periods, formats and profiles, adjustments, Data Management (FDMEE), exporting data, drill down, run reports, configuration, maintenance window and security.
  2. Transaction Matching: Match types, data sources, transaction types, the matching process, reconciliations, importing data, auto matching, adjustments. 
  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.

Major Topics 

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 (FDMEE) is used with ARCS 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

Transaction Matching
Automate the preparation of high volume reconciliations and analyze the results so you can spend more time on exceptions to the reconciliation process.

  • Create Match Types 
    Defines the structure of the data as well as the rules used for matching.

  • Define Data Sources 
    Enables the comparison of transactions from multiple data sources.

  • Create Transaction Types 
    Facilitates the creation of adjustments within a reconciliation.

  • Define the Matching Process

  • Create Formats and Profiles

  • Create Reconciliations
    Once formats and profiles have been set up, reconciliations can be created manually or by using EPM Automate.

  • Import Data
    Discover how to import both transactions and balances.

  • Run Auto Match 
    Find out how the auto-match routine can run either manually or automatically after an import.

  • 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

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

  • Create Templates

  • Managing Connections

  • Adding ARCS tasks to templates

  • Creating Schedules
    Once ARCS 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.

Detailed course agenda / Justification for your manager 

ARCS Page 1 

CPE Sponsors

Course title: Oracle ARCS: Administrator

Duration: 3 days

Audience: Implementation consultants, developers and system administrators

Delivery method: Classroom (group - live)

Advanced preparation: None

Recommended CPE credits: 21 credits - Computer software and applications

Programme level: Intermediate

Keyteach is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. Registration ID No 115820. State boards of accountancy have the final authority on the acceptance of individual courses for CPE credit. Any complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website:

Oracle Account Reconciliation Cloud
ARCS Training Courses