Manage Global Account Reconciliation Using Account Reconciliation Cloud Ed 2

Account Reconciliation: Solution Overview

• Objectives
• General Ledger: Overview
• General Ledger: Components and Best Practice
• Account Reconciliation: Overview
• Account Reconciliation: Importance of Account Reconciliation
• Reconciliation Process: Non-System-Based Approach
• Reconciliation Process: Non-System-Based Approach: Illustration
• Reconciliation Process: Disadvantages of Non-System-Based Approach
• Oracle Cloud EPM Account Reconciliation: Key Capabilities
• Oracle Cloud EPM Account Reconciliation: Overview
• Reconciliation Compliance: Types of Compliance Validations
• Reconciliation Compliance Terminology – 1
• Reconciliation Compliance Terminology – 2
• Reconciliation Compliance Methods
• Balance Comparison Method
• Account Analysis Method
• Variance Analysis Method
• Reconciliation Compliance Process
• Transaction Matching: Overview
• Transaction Matching: Terminology
• Transaction Matching: Setups
• Transaction Matching: Workflow Process
• Transaction Matching: Ways of Matching
• Summary

Navigating Within Account Reconciliation

• Objectives
• User Roles
• Home: Log In to Account Reconciliation
• Home
• Home: Announcement Panel and Global Header
• Home: Navigator
• Home: Cards
• Home: Clusters
• Home: Dashboards Cluster
• Home: Application Cluster
• Home: Tools Cluster
• Settings and Actions Menu
• Settings and Actions Menu: Preferences – General
• Settings and Actions Menu: Preferences – Teams
• Settings and Actions Menu: Preferences – Notifications
• Filters: Overview
• Filters: Using Filters
• Filters: Filter View – Illustration
• Filters: Creating a New Filter
• Filters: Save a Filter
• Filters: Selecting Saved Filter
• Filters: Export Data to Excel File
• Views
• Views: List View
• Views: List View Customization
• Views: Pivot View
• Views: Customizing Pivot View
• Views: Chart View and Types
• Views: Chart View
• Views: Customizing Chart View
• Accessing Reconciliations
• Accessing Reconciliations: Worklist
• Accessing Reconciliations: Reconciliations
• Accessing Reconciliations: Dashboards
• Summary

Configuring Reconciliation Compliance

• Objectives
• Configuring Reconciliation Compliance
• Attributes: Overview
• Attributes: Data Types
• System Attributes: Overview
• Profile Segments: Overview
• Profile Segments: Creating Profile Segment
• Currency
• Currency: Define New Currency
• Currency: Rate Types
• Currency: Currency Rates
• Currency: Currency Rates – Illustration
• Currency: Currency Buckets – Illustration
• Organizations
• Organizations: Calendars – Overview
• Organizations: Calendars – Add New Calendar
• Organizations: Holidays Rules
• Organizations: Holiday: Add Holiday Rules
• Organization: Holiday – Importing Holiday List
• Organization: Creating Organizational Unit
• Organizational: Importing Organizational Units
• System Settings
• Teams
• Teams: Defining Teams
• Teams: Export and Import Team Data
• Teams: Export Team Data
• Periods: Overview
• Periods: Creating Periods
• Periods: Period Status
• Period: Viewing Period History
• Period: Editing and Deleting Periods
• Rules Overview
• Relationship Between Account Reconciliation
• Key Components
• Formats: Overview
• Formats: Reconciliation Compliance Formats
• Formats: Example – Balance Comparison Format
• Formats: Example – Account Analysis
• Formats: Design
• Format: Properties
• Format: Instructions
• Format: Add Attributes
• Format: Questions
• Format: Rules
• Profile: Overview
• Profile: Example
• Profiles: Properties
• Profiles: Instructions
• Profile: Workflow – Overview
• Profile: Workflow
• Profile: Currency
• Profile: Access
• Profile: Attributes
• Profile: Rules
• Profile: History
• Exporting Profiles
• Importing Profile
• Summary

Managing Reconciliations

• Objectives
• Reconciliation Types
• Reconciliation Types: Individual Reconciliation
• Reconciliation Types: Summary Reconciliation
• User Roles and Their Tasks
• Manage Period Statuses
• Workflow Tasks for Services Administrator
• Creating Reconciliations: Overview
• Creating Reconciliations: From Periods
• Creating Reconciliations: From Profiles
• Creating Reconciliations: Using EPM Automate Command
• Creating Reconciliations: Missing Reconciliations
• Creating Reconciliations: Missing Reconciliations – Illustration
• Attachments: Overview
• Attachments: Actions
• Attachments: Roles and Permissions
• Attachments: Add Attachments to a Reconciliation
• Attachments: Edit or Delete
• Comments: Required Permissions
• Comments: Add Comments
• Manage Reconciliation: Life Cycle Overview
• Manage Reconciliation: Opening
• Reconciliations Actions: Reopen
• Manage Reconciliation: Summary
• Preparers Role: Workflow Tasks
• Preparers Role: Preparing Reconciliation
• Preparers Role: Submitting Reconciliations
• Reviewers Role: Workflow Task
• Reviewers Role: Approving or Rejecting Reconciliations
• Reconciliation Actions: Requesting Reassignment
• Reconciliations Actions: Reassigning Request – Illustrations
• Reconciliations Actions: Approve or Reject Reassignment Request
• Reconciliations Actions: Add Users to Reconciliations
• Group Reconciliation: Overview
• Group Reconciliations: Scenario
• Group Reconciliations: Example
• Group Reconciliations: Setup
• Group Reconciliations: Reconciliation View – Illustration
• Summary Reconciliations: Characteristics
• Summary Reconciliations: Setup
• Summary Reconciliations: Setup – Add Accounts
• Summary Reconciliations: Example
• Summary Reconciliations: Key Differences
• Summary

Importing Data into Account Reconciliation

• Objectives
• Data Integrations
• Methods of Loading Data into Account Reconciliation
• Set Up and Configure Data Integration: Overview
• Set Up and Configure Data Integration: Data Load Process
• Set Up and Configure Data Integration: Registering Applications
• Set Up and Configure Data Integration: Registering Applications – Category
• Set Up and Configure Data Integration: Creating Period Mappings
• Set Up and Configure Data Integration: Creating Period Mappings – Types
• Set Up and Configure Data Integration: Creating Category Mappings
• Set Up and Configure Data Integration: Creating Category Mappings –
• Global Mapping
• Set Up and Configure Data Integration: Creating Category Mappings –
• Application Mapping
• Creating Integration: Steps
• Creating File-Based Integration
• Creating File-Based Integration: Set File Import Options
• Creating File-Based Integration: General Details – Location Attributes
• Creating File-Based Integration: Mapping Dimensions
• Creating File-Based Integration: Mapping Members – Overview
• Creating File-Based Integration: Mapping Members – Mapping Types
• Creating File-Based Integration: Mapping Dimension Members: Add
• Creating File-Based Integration: Setting Options
• Running Integrations
• Running Integrations: Options tab
• Running Integration: Workbench
• Running Integration: Viewing Results in the Workbench
• Running Integration: Process Details
• Data Management
• Importing Data Using Data Management: Types of Data Load
• Importing Data Using Data Management
• Data Management Feature Migrated to Data Integration
• Data Management: Navigation
• Data Management: Setup Tab
• Data Management: Workflow Tab
• Importing Data Using Data Management: Import Format
• Importing Data Using Data Management: Import Format – Illustration
• Importing Data Using Data Management: Creating Location
• Importing Data Using Data Management: Creating Location – Illustration
• Importing Data Using Data Management: Mapping Member
• Importing Data Using Data Management: Mapping Member – Illustration
• Importing Data Using Data Management: Define Data Load Rules
• Importing Data Using Data Management: Define Data Load Rules – Illustration
• Importing Data Using Data Management: Run Data Load Rules
• Importing Data Using Data Management: View Process Details
• Importing Data Using Data Management: Workbench
• Using Bank Statement Formats for Data Load
• Using Bank Statement Formats for Data Load: Verifying BAI Bank
• Statement Balances
• Using Bank Statement Formats for Data Load: Registering Application
• Using Bank Statement Formats for Data Load: Enabling the Verify
• Statement Balance Option
• Importing Data into Account Reconciliation
• Importing Data into Account Reconciliation: Adding Data Load Definition
• Importing Data into Account Reconciliation: Balances – Import Mode
• Importing Data into Account Reconciliation: Executing Data Load
• Importing Data into Account Reconciliation: Executing Data Load – Illustration
• Importing Data into Account Reconciliation: Viewing Data Load Results
• Importing Data into Account Reconciliation: Account Reconciliation View
• Summary

Create and Manage Rules

• Objectives
• Rule: Overview
• Rules: How Rules Work in ARCS
• Format and Profile Rules
• Adding Rules to Formats and Profiles
• Adding Rules to Formats
• Adding Rules to Profiles
• Format and Profile Rules: 1. Auto Approve Reconciliation
• Format and Profile Rules: 1. Auto Approve Reconciliation: Example
• Format and Profile Rules: 2. Auto Submit Reconciliation
• Format and Profile Rules: 2. Auto Submit Reconciliation: Example
• Format and Profile Rules: 3. Prevent Reconciliation Approval
• Format and Profile Rules: 3. Prevent Reconciliation Approval: Example
• Format and Profile Rules: 4. Prevent Reconciliation Submission
• Format and Profile Rules: 4. Prevent Reconciliation Submission: Example
• Format and Profile Rules: 5. Prevent Reconciliation Rejection
• Format and Profile Rules: 5. Prevent Reconciliation Rejection: Example
• Format and Profile Rules: 6. Require Reconciliation Attachment
• Format and Profile Rules: 6. Require Reconciliation Attachment: Example
• Format and Profile Rules: 7. Send Email on Update
• Format and Profile Rules: 7. Send Email on Update: Example
• Format and Profile Rules: 8. Create an Alert
• Format and Profile Rules: 8. Create an Alert: Example
• Format and Profile Rules: 9. Setting Attribute Value
• Format and Profile Rules: 9. Setting Attribute Value: Example
• Format and Transaction Rules
• Format and Transaction Rules: Implementation
• Format and Transaction Rules: 1. Copy Transaction from Prior Reconciliation
• Format and Transaction Rules: 1. Copy Transaction from Prior Reconciliation:
• Example
• Format and Transaction Rules: 2. Prevent Amount Edit Rule
• Format and Transaction Rules: 2. Prevent Amount Edit Rule: Example
• Format and Transaction Rules: 3. Prevent Transaction Delete
• Format and Transaction Rules: 3. Prevent Transaction Delete Rule: Example
• Format and Transaction Rules: 4. Prevent Transaction Save Rule
• Format and Transaction Rules: 4. Prevent Transaction Save Rule: Example
• Format and Transaction Rules: 5. Require Transaction Attachment Rule
• Format and Transaction Rules: 5. Require Transaction Attachment Rule:
• Example
• Format and Transaction Rules: Illustration
• Summary

Group Attributes

• Objectives
• Group Attributes: Overview
• Group Attributes: Uses and Benefits
• Configure Group Attributes: Reconciliation Compliance
• Configure Group Attributes: Transaction Matching
• Group Attribute Properties
• Defining Member Attributes
• Specifying Values for Group Member Attributes
• Exporting Group Attribute Member Values
• Importing Group Attribute Member Values
• Editing Group Attributes
• Deleting Group Attributes
• Deleting Group Attributes: Illustration
• Summary

Transaction Matching

• Objectives
• Transaction Matching: Overview
• Transaction Matching: Benefits
• Transaction Matching: Use Cases – 1
• Transaction Matching: Use Cases – 2
• Transaction Matching: Use Cases – 3
• Transaction Matching: Use Cases – 4
• Transaction Matching: Terminology
• Transaction Types in Transaction Matching: Illustration
• Transaction Matching: Status
• Transaction Matching: Reconciliation Methods
• Setting Up Transaction Matching
• Setting Up Transaction Matching: Match Types – Overview
• Transaction Matching: Creating Match Types
• Match Types: Properties
• Match Types: Data Sources
• Match Types: Data Sources – Illustration
• Match Types: Data Sources – Attribute
• Match Types: Transaction Types
• Match Types: Match Process – Overview
• Match Types: Match Process – Properties
• Match Types: Match Process: Rule Types
• Match Types: Match Process – Rules
• Match Types: Match Process – Rule Examples
• Match Types: Match Process – Create Rules
• Match Types: Match Process: Manual Match
• Running Auto Match: Overview
• Match Types: Match Process – Auto Match
• Match Types: Match Process – Auto Match Illustration
• Match Types: Match Process: Auto Match – Filtering Transactions
• Match Types: Match Process: Auto Match – Grouping Transactions
• Match Types: Match Process – Default Adjustment Values
• Duplicate and Reorder Auto Match Rules in Transaction Matching
• Setting Up Formats For Transaction Matching
• Setting Up Profile for Transaction Matching
• Exporting Match Types
• Importing Match Types
• Running Auto Match: Workflow
• Running Auto Match: Illustration
• Matching: Overview
• Importing Transaction to Data Source: Overview
• Importing Transactions to Data Source: File Format
• Importing Transactions to Data Source: Create File
• Importing Transactions to Data Source: Run Import
• Importing Premapped Balances to Data Source: Overview
• Importing Premapped Balances to Data Source: Import
• Matching: Matching and Transaction Tab View
• Matching: Matching Dialog
• Matching: Overview Tab
• Suggested Matches: Overview
• Suggested Matches: Matching and Transaction Tab
• Suggested Matches: Suggested Match Tab
• Suggested Matches: Transactions Matches Tab
• Unmatched Transaction
• Unmatched Transaction: Adjustments
• Reports: Balance Report Summary
• Reports: Balance Report Transaction
• Searching Transactions in Transaction Matching: Features
• Searching Transactions in Transaction Matching: Illustration
• Summary

Balancing Rules

• Objectives
• Five Golden Balancing Rules
• Golden Rule #1: Unmatched
• Golden Rule #2: Unmatched
• Golden Rule #3: Matched – Two Sources
• Golden Rule #3: Matched – Single Source
• Golden Rule #4: Matched – All After Period End Date
• Golden Rule #5: Matched – Two Sources
• Golden Rule #5: Matched – Single Source
• Golden Rule #5: Matched – Adjustments
• Golden Rule #5: Matched – Two Sources & Adjustments
• Matching and Period End Date: Real-Time Scenarios
• Real-Time Scenario: Timing Delay
• Real-Time Scenario: Imperfect Match
• Real-Time Scenario: Discrepancy
• Real-Time Scenario: 4
• About Cosmetic and Non-Cosmetic Changes
• Cosmetic Changes to Transactions in Transaction Matching: Overview
• Cosmetic Changes to Transactions in Transaction Matching
• Non-Cosmetic Changes to Transactions in Transaction Matching: Overview
• Non-Cosmetic Changes to Transactions in Transaction Matching
• Closed Through Date
• Locked Through Date
• Reverse Adjustments
• Reverse Adjustments: Example
• Summary

Alerts Management

• Objectives
• Alerts: Overview
• Alert Types: Overview
• Creating an Alert Type
• Creating Alert Types: Illustration
• Creating Alert Types: Properties
• Creating Alert Types: Instructions
• Creating Alert Types: Workflow
• Creating Alert Types: Viewers
• Creating Alert Types: Questions
• Creating Alert Types: Attributes
• Creating Alert Types: History
• Creating Alerts: From Alerts
• Creating Alerts: From Reconciliations
• Creating Alerts: From Matching
• Creating Alerts: Illustration
• Viewing Alerts
• Viewing Alerts: Alert Actions
• Alert Actions and Available Roles
• Updating Alerts
• Alert Rules: Overview
• Creating Alert Rules: Process flow at each level
• Creating Alert Rules: New Rule
• Summary

Data Loading Using EPM Automate and Web Services

• Objectives
• EPM Automate Overview and Utility Commands
• EPM Automate Overview
• Automating Repeatable Tasks
• Downloading and Installing EPM Automate: Windows
• Downloading and Installing EPM Automate: Linux/UNIX/macOS X
• Launching EPM Automate: Windows
• Launching EPM Automate: macOS X, Linux
• Launching EPM Automate: Login – Windows
• Launching EPM Automate: Login – Linux
• EPM Automate Utility Commands
• EPM Automate Commands Specific to ARCS
• EPM Automate Utility Command: createreconciliations
• Importing Pre-Mapped Balances Using EPM Automate
• Importing Pre-Mapped Balances or Transactions: Types of Data
• Importing Balances Using EPM Automate Command:
• importPreMappedBalances
• Importing Transactions Using EPM Automate Command:
• importPreMappedTransactions
• Importing Pre-Mapped Transactions for Transaction Matching: Using
• epmautomate
• Using REST APIs in Account Reconciliation
• Using REST APIs in Account Reconciliation: Overview
• URL Structure for Account Reconciliation
• Executing REST API Job in Account Reconciliation
• Importing Pre-Mapped Balances: Reconciliation Compliance Using
• REST API
• Importing Pre-Mapped Transactions: Reconciliation Compliance Using
• REST API
• Importing Pre-Mapped Balances: Reconciliation Compliance Using
• REST API
• Importing Balances (Reconciliation Compliance) Using REST API:
• Data Management
• Importing Pre-Mapped Transactions: Transaction Matching Using
• REST API
• Summary

EPM Digital Assistant

• Objectives
• Oracle Digital Assistant: Overview
• Understanding Digital Assistant
• Digital Assistant in EPM Business Process
• Configure ODA for Account Reconciliation
• Home: Digital Assistant
• Default Tasks Configured in Account Reconciliation
• Using Digital Assistant in Account Reconciliation
• Using Digital Assistant: Add Comment to Reconciliations
• Using Digital Assistant: View Reconciliation Balance
• Using Digital Assistant: View and Update Period Status
• Customizing Skills for Account Reconciliation
• Summary

Visualizing and Analyzing Data

• Objectives
• Views: Overview
• View Types
• Objects for Which Views Are Available
• Views: Illustration
• Chart View: Overview
• Chart View: Properties – Types of Charts
• Chart View: Illustration
• Chart View: Properties
• Chart View: Layout
• Chart View: Chart Axis
• Chart View: Legend
• Pivot View: Overview
• Pivot View: Properties and Layout
• Pivot View: Illustration
• List View: Overview
• Customizing List Views
• Custom Dashboards: Overview
• Opening Custom Dashboards
• Viewing Custom Dashboards
• Custom Dashboards: Edit (Design) Mode
• Creating Custom Dashboards
• Creating Custom Dashboards: Configure Settings – Properties
• Creating Custom Dashboards: Configure Settings – Access
• Custom Attributes
• Balance Attributes: Overview
• Creating Balance Attributes
• Process flow – Balance Attributes
• Balance Attributes: Data Aggregation
• Calculated Balance Attributes in Custom Report Queries
• Best Practices for Using Balance Attributes
• Predefined Reports
• Predefined Reports: Illustration
• Generating Custom Reports
• Generating Custom Reports: Step 1 – Creating a Query
• Generating Custom Reports: Step 1 – Adding a Parameter Query to a Report
• Generating Custom Reports: Step 1 – Generating a Query
• Generating Custom Reports: Step 2 – Creating a Template
• Generating Custom Reports: Step 3 – Creating a Report Group
• Generating Custom Reports: Step 4 – Creating a Report Definition
• Generating Custom Reports: Step 5 – Generating the Report
• Summary