Oracle Financial Consolidation Hub User's Guide

Skip Headers

Title and Copyright Information

Send Us Your Comments

Preface

About Oracle Financial Consolidation Hub

Oracle Financial Consolidation Hub Overview

The Oracle Financial Consolidation Hub Solution

Quick Reference

Setting Up Oracle Financial Consolidation Hub

Oracle Financial Consolidation Hub Setup Overview

Setting Up Users

Setting Up Users

Setting Up Oracle Enterprise Performance Foundation

Setting Up Oracle Enterprise Performance Foundation

Tasks

Using Oracle General Ledger with Oracle Enterprise Performance Foundation

Setting Up Entities

Setting Up Entities

Selected User Interface Elements for Setting Up Entities

Spreadsheet Loader

Setting Up Categories

Setting Up Categories

Category Definitions

Selected User Interface Elements for Setting Up Categories

Setting Up Consolidation Methods

Setting Up Consolidation Methods

Selected User Interface Elements for Setting Up Consolidation Methods

Setting Up Consolidation Rules

Setting Up Consolidation Rules

Selected User Interface Elements for Setting Up Consolidation Rules

Consolidation Rule Steps

Balancing a Consolidation Rule

Additional Data Types

Examples of How Consolidation Rules Work

Eliminate Investment in Subsidiary

Setting Up Intercompany Rules

Setting Up Intercompany Rules

Matching

Suspense Handling

Additional Data Types

Example of How an Intercompany Rule Works

Setting Up Calendar Maps

Setting Up Calendar Maps

Setting Up Translation

Overview of the Translation Method

Translation Method

Entering Ending and Average Rates

Historical Rates

Translation Example

Setting Up Consolidation Hierarchies

Consolidation Hierarchies Overview

Setting Up Consolidation Hierarchies

Consolidation Hierarchy Structures

Updating Consolidation Hierarchies

Duplicate Hierarchies for Restatements and What-if Analysis

Multiple Parents

Hierarchy Group

Submitting Data

Overview of Data Submission

Monitoring Data Submission

Setting Up Data Submission for Oracle Sources

Submitting Data for Oracle Sources

Oracle Source Example

Setting Up Data Submission for External Sources

Submitting Data for External Sources

Selected User Interface Elements for Submitting Data for External Sources

Running Consolidations

Running Consolidations

Submitting Consolidations

Preparing Data for Analytical Reporting

Purging Archived Consolidations

Adjustments

Adjustments

Updating Adjustments

Disabling Adjustments

Selected User Interface Elements

Write back to General Ledger

Accounting for Acquisitions and Disposals

Accounting for Acquisitions and Disposals

Create Accounting for Consolidation Hierarchy Changes

Manually Entering Acquisition and Disposal Entries

Calculating Acquisition and Disposal Entries

Selected User Interface Elements for Acquisition and Disposal Rules

Write Back Consolidation Results to Oracle General Ledger

Write Back Consolidation Results to Oracle General Ledger

Selected User Interface Elements for Writing Back Consolidation Results to Oracle General Ledger

Write Back Examples

Viewing Reports

Viewing Reports

Consolidation Trial Balance Report

Consolidation Entries Report

Intercompany Matching Report

Data Submission Trial Balance Report

Data Submission Data Loaded Report

Data Submission Impacted Balances Report

Hierarchy Listing Report

Value Set Map Validation Report

Write Back to General Ledger Report

Setting Up Analytical Reporting

Analytical Reporting Overview

Setting Up Analytical Reporting

Creating and Sharing Reports

Setting Up Excel Add-in

Setting Up Excel Add-in

Reports

Saved Selections

Security

Excel Add-in Configuration Options

Creating Custom Queries with Excel Add-In Version 3

Security

Security Overview

Role-Based Security

Function-Based Security

Integrating with Oracle Internal Controls Manager

Integrating with Oracle Internal Controls Manager

Setup for Integration with Internal Controls Manager

Creating Auditable Units

Enabling Certification for a Consolidation Hierarchy

Creating Business Process and Financial Statement

Monitoring Financial Statement Certification Status

Monitoring Organization Certification Status

Integrating with Approvals Management

Integrating with Approvals Management Overview

Setup for Integrating with Approvals Management

Using Approvals Management with FCH Adjustments

WebADI Spreadsheets

WebADI Spreadsheets

Requirements

Downloading WebADI Spreadsheets

Uploading WebADI Spreadsheets

WebADI Selected User Interface Elements

Concurrent Programs

Concurrent Programs

Business Events

Business Events

Adjustment Upload using XML

Adjustment Upload using XML

Data Submission Upload using XML

Data Submission Upload using XML

Profile Options

Profile Options

Custom Adjustment Validation Specifications

Custom Adjustment Validation Specifications

Index

Oracle Financial Consolidation Hub User's Guide

Contents