Enterprise Structure in Fusion Application – a backbone of Your Financials Implementation
The Enterprise Structures configuration deals with creating your GL structure & can be complete manually or using Enterprise Configurator, which is an interview-based tool to guide through the process of setting up a basic enterprise structure. By answering questions about enterprise, the tool creates a structure of divisions, legal entities, business units, and reference data sets that reflects your enterprise structure. Before we start looking at details of Enterprise structure, below is the Overall process in Fusion GL which will use the enterprise structure.
Financial enterprise structures are the entities that define the reporting, legal and business aspects of your enterprise
Enterprise structure now has a definition & an instance to allow users define various accounting representation.
Chart of accounts structure:
Building block of chart of accounts implementation, geared towards flexibility, minimizing setup efforts. Defines the number of segments, segment sequence, labels and default value set for each segment.
Chart of accounts structure instance:Also referred to as chart of accounts, Multiple charts of accounts can share the same structure, but each may be customized differently to fit your transactional and reporting requirements: Value set,
Account hierarchy, Dynamic combination creation
**Assuming reader is already familiar of it We will not go in much details of COA, Balancing segments, Calendars, Accounting method definitions & their setups.
Enterprise Structure can also be created using spreadsheet uploads enabling Functional users to use excel spreadsheet to model, discuss & finalize the structure before the setups are loaded into Oracle.
(1) Under the Financials offering locate the Define Chart of Accounts task grouping and navigate to the tasks needed to successfully bring your chart of accounts implementation into completion
Define Common Applications Configuration for Financials
Define Enterprise Structures for Financials
Define Financial Reporting Structures
Define Chart of Accounts
Manage Charts of Accounts
Manage Chart of Accounts Value Sets
Manage Account Hierarchies
Publish Account Hierarchies
Manage Account Combinations
Manage Segment Value Security Rules
Manage Cross-Validation Rules
Manage Chart of Accounts Mappings (1)
Manage Chart of Accounts Synchronization with DRM
Maintain Segment Value Attributes(2)
(2) Under the Financials offering locate the Define Calendars task grouping and navigate to the tasks needed to successfully bring your calendars’ implementation into completion
Define Common Applications Configuration for Financials
Define Enterprise Structures for Financials
Define Financial Reporting Structures
Define Calendars
Manage Accounting Calendars
Manage Transaction Calendars
(3) Under the Financials offering locate the Define Currencies task grouping and navigate to the tasks needed to successfully bring your currencies implementation into completion
Define Common Applications Configuration for Financials
Define Enterprise Structures for Financials
Define Financial Reporting Structures
Define Currencies
Manage Currencies
Manage Conversion Rate Types
Manage Daily Rates
(4) Under the Financials offering locate the task groupings below and navigate to the tasks needed to successfully bring your legal entity setup into completion
Define Common Applications Configuration for Financials
Define Enterprise Structures for Financials
Define Legal Jurisdictions and Authorities for Financials
Manage Legal Jurisdictions
Manage Legal Authorities
Manage Legal Addresses
Define Legal Entities for Financials
Manage Legal Entities
Manage Legal Entity Registrations
Define Legal Reporting Units for Financials
Manage Legal Reporting Units
Manage Legal Reporting Unit Registrations
(5) Under the Financials offering locate the Define Accounting Configurations iterative task list and navigate to the tasks needed to successfully bring your accounting configuration into completion
Define Common Applications Configuration for Financials
Define Accounting Configurations
Manage Primary Ledgers
Assign Legal Entities
Specify Ledger Options
Assign Balancing Segment Values to Legal Entities
Assign Balancing Segment Values to Ledger
Manage Reporting Currencies
Define Secondary Ledgers
Manage Secondary Ledgers
Specify Ledger Options
Complete Primary to Secondary Ledger Mapping
Assign Balancing Segment Values to Legal Entities
Assign Balancing Segment Values to Ledger
Manage Reporting Currencies
Review and Submit Accounting Configuration
(6) Under the Financials offering locate the Define Business Units iterative task list and the Maintain Common Reference Objects task grouping and navigate to the tasks needed to successfully bring your accounting configuration into completion
Define Common Applications Configuration for Financials
Define Business Units
Manage Service Provider Relationships
View Service Clients
View Available Asset Books
Specify Customer Contract Management Business Function Properties
Specify Supplier Contract Management Business Function Properties
Manage Business Unit Set Assignment
Assign Business Unit Business Function
Configure Procurement Business Function
Configure Requisitioning Business Function
Maintain Common Reference Objects
Define Reference Data Sharing
Manage Reference Data Sets
Manage Set Assignments for Set Determinant Type
Rapid implementation is a way to configure the Oracle Fusion Financial Enterprise and Financial Reporting Structures quickly using sheets in a workbook to upload lists of companies (legal entities), ledgers, business units, chart of account values, and other similar data. Once the sheets have been uploaded, the application creates your ledger, business unit, and other components.
Begin by downloading the Rapid Implementation for General Ledger workbook using the Create Chart of Accounts, Ledger, Legal Entities, and Business Units in Spreadsheet task on the Setup and Maintenance work area
1. Enter the data into the sheets.
2. Upload the xml files generated from the sheets.
3. Run the deployment process to finalize the chart of accounts configuration.
4. Upload the XML files generated from the sheets for the rest of the configuration
For Example following is a spreasheet example which can be deployed using process above.
Differences from R12
Related Concepts
Balance cubes which are Multidimensional structures that store your financial balances and enable high-speed, interactive financial reporting and analysis
• Balances cubes pre-aggregate your balances at every possible point of summarization, thus ensuring immediate access to financial data and obviating the need for an external data warehouse for financial reporting
-
A balances cube is uniquely identified by the combination of a chart of accounts and an accounting calendar. Average balances are tracked in a separate balances cube
-
Completing an accounting configuration launches a process to create or update balances cubes
-
If the combination of a ledger’s chart of accounts and calendar is new, the system creates a new balances cube. If your accounting configuration contains an average balance enabled ledger, an additional average balances cube is created
-
If the combination of a ledger’s chart of accounts and calendar already exists, the system simply adds the ledger(s) to the corresponding balances cube
-
Balances in the cubes are automatically maintained by the following general ledger processes: posting, open period and translation
Oracle Hyperion Data Relationship Management (DRM) is a data model-agnostic master data management solution that enables financial and analytical master data management. It can be used to synchronize charts of accounts values and hierarchies across multiple EBS and Fusion instances. Oracle provides integration between Hyperion DRM both the EBS General Ledger and the Fusion Accounting Hub. Integration between Oracle Fusion Accounting Hub and DRM provides the ability to synchronize charts of accounts values and hierarchies across multiple EBS and Fusion instances. Customers can maintain charts of accounts values and hierarchies centrally in a single application, DRM, and then propagate updates to multiple E-Business Suite (EBS) and/or Fusion instances.