Oracle Fusion Accounting Hub Implementing Oracle Fusion Accounting Hub

496 Pages·2014·4.75 MB·English

Oracle Fusion
Accounting Hub
Implementing Oracle Fusion
Accounting Hub
Release 9
Oracle® Fusion Accounting Hub Implementing Oracle Fusion Accounting Hub
Part Number E53221-01
Copyright © 2011-2014, Oracle and/or its affiliates. All rights reserved.
Authors: Kathryn Wohnoutka, Asra Alim, Tina Brand, Essan Ni Jirman, P. S. G. V. Sekhar, Barbara Snyder, Megan Wallace
This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by
intellectual property laws. Except as expressly permitted in your license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast,
modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by any means. Reverse engineering, disassembly, or
decompilation of this software, unless required by law for interoperability, is prohibited.
The information contained herein is subject to change without notice and is not warranted to be error-free. If you find any errors, please report them to
us in writing.
If this is software or related documentation that is delivered to the U.S. Government or anyone licensing it on behalf of the U.S. Government, the following
notice is applicable:
U.S. GOVERNMENT END USERS: Oracle programs, including any operating system, integrated software, any programs installed on the hardware, and/
or documentation, delivered to U.S. Government end users are "commercial computer software" pursuant to the applicable Federal Acquisition Regulation
and agency-specific supplemental regulations. As such, use, duplication, disclosure, modification, and adaptation of the programs, including any operating
system, integrated software, any programs installed on the hardware, and/or documentation, shall be subject to license terms and license restrictions
applicable to the programs. No other rights are granted to the U.S. Government.
This software or hardware is developed for general use in a variety of information management applications. It is not developed or intended for use in
any inherently dangerous applications, including applications that may create a risk of personal injury. If you use this software or hardware in dangerous
applications, then you shall be responsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure its safe use. Oracle
Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications.
Oracle and Java are registered trademarks of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners.
Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation. All SPARC trademarks are used under license and are trademarks or
registered trademarks of SPARC International, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo are trademarks or registered trademarks of
Advanced Micro Devices. UNIX is a registered trademark of The Open Group.
This software or hardware and documentation may provide access to or information on content, products and services from third parties. Oracle Corporation
and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third-party content, products, and services. Oracle
Corporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to your access to or use of third-party content, products,
or services.
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://www.oracle.com/pls/topic/lookup?
ctx=acc&id=docacc
Oracle customers have access to electronic support through My Oracle Support. For information, visit http://www.oracle.com/pls/topic/lookup?
ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you are hearing impaired.
Oracle Fusion Accounting Hub
Implementing Oracle Fusion Accounting Hub
Contents
Preface i
1 Fusion Accounting Hub Overview 1
Define Fusion Accounting Hub Configuration for Rapid Implementation: Overview ..................................................... 1
Creating an Oracle Fusion Accounting Hub Rapid Implementation Project: Worked Example .................................... 2
Oracle Fusion Accounting Hub Features: Overview ................................................................................................... 3
Oracle Fusion Accounting Hub: How It Works .......................................................................................................... 4
Accounting Configuration Offerings: Overview ........................................................................................................... 7
Implementation Options for Oracle Fusion Accounting Hub: Overview ....................................................................... 8
Setup Data Import and Export for Oracle Fusion Accounting Hub: Explained .......................................................... 10
Manage Application Implementation ........................................................................................................................ 17
2 Define Enterprise Structures for Fusion Accounting Hub 21
Enterprise Structures: Overview .............................................................................................................................. 21
Enterprise Structures Business Process Model: Explained ...................................................................................... 23
Global Enterprise Configuration: Points to Consider ................................................................................................ 26
Modeling Your Enterprise Management Structure in Oracle Fusion: Example .......................................................... 27
Running Diagnostic Tests for Enterprise Structures Setup Data: Explained .............................................................. 31
Define Common Financials Configuration for Rapid Implementation ........................................................................ 31
Define Initial Configuration with the Enterprise Structures Configurator .................................................................... 42
Define Enterprise for Fusion Accounting Hub .......................................................................................................... 50
Define Legal Jurisdictions and Authorities ............................................................................................................... 50
Define Geographies ................................................................................................................................................. 53
Define Legal Entities ................................................................................................................................................ 66
Oracle Fusion Accounting Hub
Implementing Oracle Fusion Accounting Hub
3 Define Financial Reporting Structures 75
Representing Your Enterprise Structure in Your Financial Reporting Structure: Overview ......................................... 75
Financial Enterprise Structure: How It Fits Together ................................................................................................ 75
Modeling Your Financial Reporting Structure in Oracle Fusion: Example .................................................................. 78
Manage Chart of Accounts ..................................................................................................................................... 82
Manage Value Sets ................................................................................................................................................. 97
Manage Account Hierarchies ................................................................................................................................ 102
Manage Account Combinations ............................................................................................................................ 121
Maintain Segment Value Attributes ....................................................................................................................... 122
Deploy Flexfields ................................................................................................................................................... 130
Manage Cross Validation Rules ............................................................................................................................ 140
Manage Chart of Accounts Mapping .................................................................................................................... 145
Manage DRM Synchronization .............................................................................................................................. 146
Manage Chart of Accounts Synchronization wtih DRM ......................................................................................... 147
Manage Accounting Hierarchies with DRM ........................................................................................................... 149
FAQs for Manage DQM Synchronization ............................................................................................................... 153
Define Calendars ................................................................................................................................................... 153
Manage Currencies ............................................................................................................................................... 157
Manage Conversion Rate Types ........................................................................................................................... 158
Manage Daily Rates .............................................................................................................................................. 162
4 Define Ledgers 165
Ledgers and Subledgers: Explained ...................................................................................................................... 165
Ledgers: Points to Consider ................................................................................................................................. 165
Financial Ledgers: How They Fit Together ............................................................................................................ 167
Creating Primary Ledgers: Example ...................................................................................................................... 170
Specify Ledger Options ........................................................................................................................................ 171
Review and Submit Accounting Configuration ....................................................................................................... 174
Assign Access to Ledger ...................................................................................................................................... 198
Manage Security ................................................................................................................................................... 199
Manage Reporting Currencies ............................................................................................................................... 210
Manage Ledger Sets ............................................................................................................................................ 213
Manage Accounting and Reporting Sequences .................................................................................................... 213
Manage Journal Approval Rules ............................................................................................................................ 219
Manage AutoPost Criteria Sets ............................................................................................................................. 221
Manage Journal Reversal Criteria Sets .................................................................................................................. 224
Oracle Fusion Accounting Hub
Implementing Oracle Fusion Accounting Hub
5 Define Period Close Components 227
Manage Period Close ........................................................................................................................................... 227
Manage Allocations and Periodic Entries .............................................................................................................. 231
Define Allocation Rules ......................................................................................................................................... 252
Define Allocation Rule Sets ................................................................................................................................... 266
Working with Point of View and Allocation Components ....................................................................................... 276
Generating Allocations and Periodic Entries Manually: Worked Example ................................................................ 282
Manage Revaluations ............................................................................................................................................ 283
6 Define Applications Coexistence Configuration 289
Integration with Oracle E-Business Suite and Oracle PeopleSoft: Overview ........................................................... 289
Transfer EBS Balances to Oracle Fusion Accounting Hub Reporting Cloud Service: Explained .............................. 290
Running the EBS Balances to Cloud Reporting Transfer: Examples ...................................................................... 291
Calendar Setup From EBS to Oracle Fusion GL: Explained ................................................................................... 292
Define Applications Coexistence Configuration FAQs ............................................................................................ 292
7 Define Accounting Transformation 295
Accounting Transformation Configuration: Overview .............................................................................................. 295
Analyze Accounting Events ................................................................................................................................... 304
Register Source Systems ...................................................................................................................................... 314
Implement Accounting Event Interfaces ................................................................................................................ 329
Create Accounting Integration ............................................................................................................................... 349
Manage Accounting Rules .................................................................................................................................... 356
Migrate the Configuration ...................................................................................................................................... 369
Secure Accounting Transformations ...................................................................................................................... 370
Create and Process Subledger Journal Entries ..................................................................................................... 371
8 Manage Subledger Accounting 373
Manage Subledger Accounting: Overview ............................................................................................................. 373
Create Accounting ................................................................................................................................................ 373
Create Subledger Journal Adjustment ................................................................................................................... 382
Review Subledger Journal Entry ........................................................................................................................... 385
Subledger Balances .............................................................................................................................................. 387
Advanced Features ............................................................................................................................................... 389
Manage Subledger Accounting Reporting ............................................................................................................. 391
Oracle Fusion Accounting Hub
Implementing Oracle Fusion Accounting Hub
9 Define and Maintain Intercompany Processing Rules 397
Manage Intercompany System Options ................................................................................................................ 397
Manage Intercompany Organizations .................................................................................................................... 398
Define Invoicing Options ....................................................................................................................................... 399
Manage Intercompany Balancing Rules ................................................................................................................ 400
Manage Ledger Balancing Options ....................................................................................................................... 410
Manage Intercompany Transactions ...................................................................................................................... 417
Reconcile Accounts .............................................................................................................................................. 427
10 Define Consolidations 429
Consolidation Method: Overview ........................................................................................................................... 429
Reporting Only Consolidation Method: Explained .................................................................................................. 429
Balance Transfer Consolidation Method: Explained ............................................................................................... 431
Reporting Only Versus Balance Transfer: Points to Consider ................................................................................ 432
Balance Transfers: Overview ................................................................................................................................. 433
Using Elimination Entries: Example ........................................................................................................................ 434
Performing Consolidations: Examples ................................................................................................................... 435
Reporting Consolidation with Multiple Levels: Examples ........................................................................................ 436
Preparing Eliminations: Examples .......................................................................................................................... 437
Financial Management Integration Option: Overview ............................................................................................. 442
Mapping Segments to Financial Management Dimensions: Explained ................................................................... 443
Configure ERP Integrator: Overview ...................................................................................................................... 445
FAQs for Manage Consolidations .......................................................................................................................... 445
11 Define Hyperion Financial Management Integration 447
Oracle Hyperion Financial Management: Overview ................................................................................................ 447
Integration with Hyperion Financial Management: Overview ................................................................................... 448
12 Define Budget Configuration 449
Budget Uploads: Overview .................................................................................................................................... 449
Importing Budget Data from a Flat File: Explained ................................................................................................ 450
Loading Data to the Budget Interface Table: Explained ......................................................................................... 452
Importing Budget Data from a Spreadsheet: Explained ......................................................................................... 453
Budget Correction with Oracle ADF Desktop Integrator: Explained ........................................................................ 455
Oracle Hyperion Planning: Overview ..................................................................................................................... 455
Integration with Hyperion Planning: Overview ........................................................................................................ 456
Oracle Fusion Accounting Hub
Implementing Oracle Fusion Accounting Hub
13 Define Financial Reporting 457
Simplified User Interface for Mobile Financial Reporting: Explained ........................................................................ 457
Mobile Financial Reporting Implementation: Points to Consider ............................................................................. 459
Financial Reporting Center: How It Works ............................................................................................................. 460
Setting Up Your Financial Reporting Center: Critical Choices ................................................................................ 462
Migrating Financial Reports: Instructions ............................................................................................................... 466
Financial Reporting Permissions in BI Catalog: Examples ...................................................................................... 467
Oracle Fusion General Ledger Predefined Reports ................................................................................................ 469
General Ledger Subject Areas, Folders, and Attributes: Explained ........................................................................ 474
FAQs for Define Financial Reporting ...................................................................................................................... 477
14 Define Extensions for Fusion Accounting Hub 478
Define Custom Enterprise Scheduler Jobs for Fusion Accounting Hub .................................................................. 478
Oracle Fusion Accounting Hub Preface
Implementing Oracle Fusion Accounting Hub
Preface
This Preface introduces information sources available to help you use Oracle Applications.
Oracle Applications Help
Use the help icon to access Oracle Applications Help in the application.
Note
If you don't see any help icons on your page, click the Show Help button in the global area. Not all pages have
help icons.
You can also access Oracle Applications Help at https://fusionhelp.oracle.com/.
Oracle Applications Guides
To find other guides for Oracle Applications, go to:
• Oracle Applications Help, and select Documentation Library from the Navigator menu.
• Oracle Help Center at http://docs.oracle.com/
Other Information Sources
My Oracle Support
Oracle customers have access to electronic support through My Oracle Support. For information, visit http://
www.oracle.com/pls/topic/lookup?ctx=acc&id=info or visit http://www.oracle.com/pls/topic/lookup?ctx=acc&id=trs if you
are hearing impaired.
Oracle Enterprise Repository for Oracle Fusion Applications
Oracle Enterprise Repository for Oracle Fusion Applications (http://fusionappsoer.oracle.com) provides details on assets (such
as services, integration tables, and composites) to help you manage the lifecycle of your software.
Documentation Accessibility
For information about Oracle's commitment to accessibility, visit the Oracle Accessibility Program website at http://
www.oracle.com/pls/topic/lookup?ctx=acc&id=docacc.
Comments and Suggestions
Please give us feedback about Oracle Applications Help and guides! - Send e-mail to:
[email protected]. - Click your user name in the global area of Oracle Applications Help,
and select Send Feedback to Oracle.
i
Oracle Fusion Accounting Hub Chapter 1
Implementing Oracle Fusion Accounting Hub Fusion Accounting Hub Overview
1
Fusion Accounting Hub Overview

Define Fusion Accounting Hub Configuration for
Rapid Implementation: Overview
Use the Define Fusion Accounting Hub Configuration for Rapid Implementation task list to streamline your setup configuration
to focus only on the critical setup steps. The rapid implementation task list minimizes the time needed for you to complete
your key setups and enable the day-to-day use of Oracle Fusion Accounting Hub applications.
The rapid implementation task list includes tasks that are:
• Critical setup tasks for initial setup.
• Setup steps that are required by most users.
To create an implementation project that includes the Define Fusion Accounting Hub Configuration for Rapid Implementation
task list, use the Manage Implementation Projects page in the Setup and Maintenance work area. The application
implementation manager can customize the task list and assign and track each task.
Note
You are not restricted to only the setup configuration in the rapid implementation task list. You can manually add
the standard Fusion Accounting Hub offering task lists and tasks to your rapid implementation project to change
and update your setup.
Task Lists
The Define Fusion Accounting Hub Configuration for Rapid Implementation task list contains the following task lists:
Task List Description
Define Enterprise Structures Configuration for Rapid Define the enterprise structures configuration for Oracle
Implementation Fusion Accounting Hub rapid implementation that
  includes financial and enterprise structures.

Define Accounting Entry Configuration for Rapid Define the accounting entry configuration for Oracle
Implementation Fusion Accounting Hub rapid implementation that
  includes accounting transformation rules for transactions
sourced from external systems.

Define Ledger Configuration for Rapid Implementation Define the configuration for Oracle Fusion General
  Ledger rapid implementation that includes general
ledger and intercompany.

Define Financial Reporting Center Configuration for Define the configuration for Financial Reporting Center
Rapid Implementation rapid implementation that includes setup for financial
1
Oracle Fusion Accounting Hub Chapter 1
Implementing Oracle Fusion Accounting Hub Fusion Accounting Hub Overview
Task List Description
  reporting and integration with planning and financial
management applications.

Define Financials Security Configuration for Rapid Define the configuration for user and data roles setup for
Implementation Oracle Fusion Financials rapid implementation.

Note
The Open First Period task is a required task and is also part of the Define Fusion Accounting Hub Configuration
for Rapid Implementation task list.
Creating an Oracle Fusion Accounting Hub Rapid
Implementation Project: Worked Example
This example shows how to create an implementation project for the Oracle Fusion Accounting Hub rapid implementation
task list.
The following table summarizes key decisions for this scenario:
Decision to Consider In This Example
What Oracle Fusion applications are included in this The Oracle Fusion applications being implemented are:
implementation?
  • General Ledger
• Subledger Accounting
• Financial Reporting Center
Are the setup requirements unique to this organization? No

Can the rapid implementation task lists and tasks be Yes
used for this implementation?  

Creating the Implementation Project
1. Navigator > Setup and Maintenance work area > Manage Implementation Projects link.
2. Click Create.
3. Enter Implementation Project-FAH_Rapid_Implementation in the Name field.
4. Enter a Description.
2