O'Reilly logo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Implementing Oracle Fusion General Ledger and Oracle Fusion Accounting Hub

Book Description

This Oracle Press guide shows how to implement key modules of Oracle Fusion Financials—General Ledger and Financials Accounting Hub—covering both the functional and technical aspects of this complete financial management solution.

Implementing Oracle Fusion Applications General Ledger & Financials Accounting Hub covers the core Oracle Financials products and components. All Oracle Financials products use Financials Accounting Hub “under the hood”, and this topic is featured in detail. The author team uses a sample deployment to illustrate the best practices and common pain-points an internal staff or outside consultant would experience. They show multiple ways of leveraging this complex suite of products within the heterogeneous data environment of real-world companies. The team explains and demonstrates the key concepts at the right level to reach the broadest audience.

  • Complete coverage of Oracle Fusion General Ledger and Accounting Hub
  • Fills the gap in Oracle documentation for this product
  • Explains how Oracle Fusion implementation will meet the needs and expectations of technical decision-makers and senior management
  • Authors have years of practical experience with custom development on Oracle Fusion technology and teaching those skills to others

Table of Contents

  1. Cover
  2. Title Page
  3. Copyright Page
  4. Dedication
  5. About the Authors
  6. Contents at a Glance
  7. Contents
  8. Acknowledgments
  9. Introduction
  10. 1 Project Initiation and Scope
    1. Listing the Bank’s Pain Points
      1. Business Process Pain Points
      2. Technical Pain Points
      3. Post-Analysis Decisions
    2. Finance System Selection for Finance Transformation
      1. Addressing the Business Process Pain Points
      2. Addressing the Technical Pain Points
    3. Scope of Financial Transformation
      1. Introduction of Common Global Chart of Accounts
      2. Introduction of Ledger Strategy
      3. Introduce Centralized Audits, Governance, and Security
      4. Budgeting, Intercompany, and Consolidation
      5. Fast Close of GL Periods
      6. Financial Reporting and Dashboards
    4. Summary
  11. 2 Introduction to General Ledger and Fusion Accounting Hub
    1. Overview of General Ledger (GL)
      1. Introduction of Accounting in Oracle Applications
      2. Ledger Accounts in Oracle Applications
    2. Overview of Fusion Accounting Hub
      1. Benefits of Using FAH
      2. Key Technology Enablers
    3. Summary
  12. 3 Implementation Project Plan Using Functional Setup Manager
    1. Functional Setup Manager
      1. Setup And Maintenance Work Area
      2. Key Concepts and Terminology Used in FSM
      3. Functional Setup Manager Process Flow
      4. Users of Functional Setup Manager
      5. Creating the ACME Bank Implementation Project
      6. Export and Import Processes of Setup Data
      7. Financials Rapid Implementation Configuration
    2. Summary
  13. 4 Enterprise Structure for Financials
    1. Overview of Enterprise Structure
      1. High-Level Components of Enterprise Structure
      2. How to Create Enterprise Structure
    2. Define ACME Bank Enterprise Structure
      1. ACME Bank Requirements
      2. Global Enterprise Structure for ACME Bank
      3. Define Enterprise
      4. Define Legal Jurisdictions and Authorities
      5. Define Legal Address
      6. Create Legal Entities, Legal Registrations, and Legal Reporting Units
    3. Geographies
    4. Summary
  14. 5 Financials Reporting Structure: Chart of Accounts Structures, Calendars, and Currencies
    1. Introduction to the Chart of Accounts Structure Concept
      1. An Example: Securities Trading Accounting Events Use Case
      2. Chart of Accounts and Multiple Segment Chart of Accounts Structure
    2. Core Fusion CoA Structures, Instances, and Other CoA Components
      1. CoA Building Blocks Overview
      2. CoA Structure Versus CoA Instance
    3. An Example: Key CoA Design Decisions
      1. ACME Chart of Account Design Considerations
      2. An Example: ACME Chart of Accounts Implementation Steps
      3. Create ACME Value Sets
      4. Define ACME CoA Structures
      5. Define ACME CoA Instances
      6. Create ACME Value Set Values
    4. The Remaining Cs: Calendars and Currencies
      1. ACME Implementation Calendar and Currency Requirements
      2. Creating Calendars in Fusion Financials
      3. Currencies in Fusion Applications
      4. Cross-Validation Rules
    5. Summary
  15. 6 Implement Ledgers and Business Unit
    1. Ledgers
      1. Types of Ledgers
      2. Assigning Legal Entities and Balancing Segments to Ledgers
    2. Business Units
      1. Implementation Considerations
      2. Reference Data Sets and Sharing Methods
    3. Understand the Big Picture: Enterprise, Ledgers, Legal Entities, Business Units and Their Association
    4. Define ACME Ledgers and Business Units
      1. Define Ledgers
      2. Define a Business Unit
    5. Chart of Accounts Mapping Feature
      1. Segment Rule
      2. Account Rule
      3. Overlap of Account Rule and Segment Rule
    6. Intercompany Accounting
      1. Types of Intercompany Processing Options
      2. Intercompany Balancing Rule Setup Example
    7. Summary
  16. 7 Security and Audit in Fusion Applications
    1. Business Requirements
    2. Security Overview in Oracle Fusion Applications
    3. Comparison of Security Model to Other Oracle ERP Products
    4. Architecture Components in Oracle Fusion Applications Security
      1. Oracle Internet Directory
      2. Oracle Identity Manager
      3. Authorization Policy Manager (APM)
      4. Oracle Platform Security Services
    5. Role Based Access Control (RBAC)
    6. Role Hierarchy
    7. Authentication in Fusion Applications
    8. Authorization in Fusion Applications
      1. Data Security
      2. APM User Interface
    9. Joiners, Movers, and Leavers
    10. System Auditing
      1. Configuring System Audit Policies
      2. Reporting on System Audit Policies
    11. Implementing the Business Requirements
      1. Create User ACMEUS01 and Related Roles
      2. Create User ACMEUS02 and Related Roles
      3. Create User ACMEUS03 and Their Roles
    12. Summary
  17. 8 Journals and Budgets
    1. Journals
      1. Types of Journals
      2. Overview of Journal Capture Methods
      3. Journal Entry Structure
      4. Journal Processing Cycle
    2. Create Journals for ACME Bank
      1. Business Requirements
      2. Create Actual Journals Through the Manual Journal Entry Form
      3. Create Statistical Journals
      4. Journal Approvals
    3. Budgets
      1. Budget Journals
      2. Overview of Budget Capture Methods
      3. ACME Budget Creation Process
      4. Create Budget Scenarios
      5. Create Budget Data Through a Spreadsheet
      6. Budget Data Security
    4. Summary
  18. 9 Oracle Fusion Accounting Hub
    1. Oracle Fusion Accounting Hub Overview
      1. Components of Fusion Accounting Hub
      2. Approach for Fusion Accounting Hub Implementation
      3. System Implementation Steps in FAH
    2. Steps to Implement Business Requirements for ACME
      1. Create Database Objects
      2. Configure Fusion Accounting Hub
    3. Summary
  19. 10 Consolidation
    1. The Consolidation Process
    2. Elimination Entries
      1. Scenario: Intercompany Transfer of Services
      2. Intercompany Sales of Inventory
    3. Different Consolidation Methods
      1. Report-Only Consolidations
      2. Balance Transfer Consolidations
      3. Oracle Fusion Hyperion Financial Management Consolidations
      4. Comparison of Report-Only Consolidation and Balance Transfer Consolidation
    4. Consolidation for ACME Bank
      1. Requirements
      2. Proposed Consolidation Method
      3. Consolidation Using the Balance Transfer Method from ACME Insurance Ledger to ACME US Ledger
    5. Summary
  20. 11 Allocations Using Calculation Manager
    1. Overview of GL Allocations
      1. Business Motivation for Using Allocations
      2. Relationship to Allocations’ Functionality in Other Oracle Products
    2. The Allocations Process and Oracle Essbase Cube
      1. High-Level Allocation Journals Generation Process Flow
      2. Multidimensional View of GL Balances
    3. Step-by-Step Example
      1. Business Requirements and Accounts Setup
      2. Cost Center Hierarchy Creation Prerequisite
      3. Allocation Rule Creation Walkthrough
      4. Generate Allocation Journals
    4. Summary
  21. 12 Period Close
    1. Period Close and Accounting Cycle Overview
      1. Trial Balance
      2. Adjustment Entries
    2. Dealing with Foreign Currency Balances: Revaluations and Translations
      1. An Example: Configuring Revaluations
    3. Putting It All Together
    4. Summary
  22. 13 Building Financial Reports and Analysis Dashboards
    1. Different Types of Reports in Fusion Financials
      1. Data Sources in Fusion Financials
    2. Financial Reporting Studio Fusion Edition
      1. Installing Financial Reporting Studio
      2. Build GL Report Using Financial Reporting Studio
    3. Account Monitor
      1. Account Groups
    4. OTBI (Oracle Transaction Business Intelligence)
      1. Create a Simple OTBI Report
    5. BI Publisher Reports in Fusion Applications
      1. Scheduling Capabilities in BI Publisher
      2. Bursting the Report Output with Multiple Delivery Options
      3. Templates for Formatting the Output
      4. Report Output
      5. Create a BI Publisher Report to List Journal Batches for the Last Day
    6. Smart View
      1. Building a Simple Report Using Smart View
    7. Account Inspector
    8. Summary
  23. A Create Implementation Users
    1. Steps to Create an Application User
    2. Changes to Security Model in Fusion R10
  24. Index