Financials Cloud

Enterprise Structures

Sreeni Devireddy
Platform Technology Solutions
Oracle Development

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted
Safe Harbor Statement
The following is intended to outline our general product direction. It is intended for
information purposes only, and may not be incorporated into any contract. It is not a
commitment to deliver any material, code, or functionality, and should not be relied upon
in making purchasing decisions. The development, release, and timing of any features or
functionality described for Oracle’s products remains at the sole discretion of Oracle.

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 3
Agenda
1 Enterprise Structures
2 Reporting Structures
3 Ledgers
4 Rapid Setup

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 4
Agenda
1 Enterprise Structures
2 Reporting Structures
3 Ledgers
4 Rapid Start

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 5
Enterprise Structures
Axes

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Enterprise Structures
Legal Axis – Legal Entity • Define a legal entity for each registered
company or other entity recognized in law for
which you want to record assets, liabilities,
expenses and income, pay transaction taxes, or
perform intercompany trading
• Required to publish specific and periodic
disclosures of your legal entities‘ operations
based on different jurisdictions' requirements
• Your legal entities can be identified as legal
employers and therefore, are available for use
in Human Capital Management (HCM)
applications
• Legal entities are mandatory

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Enterprise Structures • Segregate multiple businesses by their strategic objectives and
Managerial Axis measure their results
• Companies may choose to represent product lines, brands, or
geographies as their divisions
• Divisions are optional and can be represented with a hierarchy of
cost centers or by a second balancing segment value
• Business Unit is an unit of an enterprise that performs one or many
business functions that can be rolled up in a management hierarchy
• Normally, it will have a manager, strategic objectives, a level of
autonomy, and responsibility for its profit and loss
• Use business units in the following ways:
– Management reporting
– Processing of transactions
– Security of transactional data
– Reference data definition and sharing
• When a business function produces financial transactions, a
business unit must be assigned to a primary ledger, and a default
legal entity

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Enterprise Structures
Functional Axis
• Department is an organization with one or
more operational objectives or
responsibilities that exist independently of
its manager
• Has one or more workers assigned to it
• Departments are mandatory because they
track your employees

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Enterprise Structures
Example

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Enterprise Structures
Example

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Enterprise Structures
Equivalence

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Example
Enterprise Setup
101
100 (US1)
102

201
200 (US2)
V (Corp)
202

300 (SSC) 301

400 (CA) 401

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | 13

Demo
Legal Entity & Business Unit

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | 14

Agenda
1 Enterprise Structures
2 Reporting Structures
3 Ledgers
4 Rapid Setup

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 15
Reporting Structures
Example

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Chart of Accounts
Structure
• Plan carefully to create an account structure that
Number of segments meets the current needs of your organization and
Segment sequence anticipates future requirements.
Segment names • Can create up to 30 segments with a maximum of
Segment prompts 25 characters per segment
Segment labels • Best practices recommend 5 to 9 segments
Default values sets • Limit maximum length of all segments plus the
segment separator. The maximum allowed is 240
characters

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Chart of Accounts
Structure

Number of segments
Segment sequence
Segment names Company LoB Account Cost Center Intercompany

Segment prompts
Segment labels
Default values sets

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Chart of Accounts
• Primary Balancing
Structure • Second Balancing
• Third Balancing
• Cost Center
Number of segments • Natural Account
• Intercompany
Segment sequence • The primary balancing segment label is required
Segment names • The second and third balancing segment labels are optional and may not be
Segment prompts necessary, unless, for example, you need to balance at more than the legal
entity level for management reporting
Segment labels • Best practices recommend that you assign specific balancing segment values
Default values sets to each legal entity in your accounting configuration
• If you use a balancing segment to represent legal entities, you should
represent all of your legal entities with values in that same balancing segment
• If you would like to create consolidated management reporting across legal
entities, you can use a single ledger to represent multiple legal entities
• Add a cost center segment if you plan to add Assets or Expenses in the future,
as the chart of accounts cannot be modified

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Chart of Accounts
• Primary Balancing
Structure • Second Balancing
• Third Balancing
• Cost Center
Number of segments • Natural Account
• Intercompany
Segment sequence
Segment names
Segment prompts Primary Balancing Natural Account Intercompany

Segment labels Company LoB Account Cost Center

Cost Center
Intercompany

Second Balancing
Default values sets

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Chart of Accounts
Structure

Number of segments
Segment sequence
Segment names
Company Value Set Account Value Set Company Value Set

Company LoB Account Cost Center Intercompany

Segment prompts LoB Value Set CC Value Set

Segment labels
Default values sets

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Chart of Accounts
Structure Instance
• Is based on a COA Structure
• Inherits by default all the attributes of the chart of accounts structure
• All instances of the same structure share a common shape and have the same
segments in the same order
• However you can override the default value set assignments for your segments and
assign a unique account hierarchy

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

 Chart of Accounts Important!
Structure Instance • Have a one to one
mapping between a chart
COA Structure of accounts structure and
instance
Company Value Set Account Value Set Company Value Set

Company LoB Account Cost Center Intercompany

• In other words, do not
have multiple instances
LoB Value Set CC Value Set
associated with the same
structure

COA Structure Instance - Corporate COA Structure Instance - Subsidiary

Account Value Set Account Subsidiary Value Set
Account Hierarchy Company Value Set Account Hierarchy Company Value Set
Company Value Set Company Value Set

Company LoB Account Cost Center Intercompany Company LoB Account Cost Center Intercompany

CC Value Set LoB Value Set CC Value Set

LoB Value Set
CC Management Hierarchy CC Geographical Hierarchy

Dynamic Insertion Disabled Dynamic Insertion Enabled

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Chart of Accounts Company Value Set

Company LoB
Account Value Set

Account Cost Center

Company Value Set

Intercompany

Value Sets LoB Value Set CC Value Set

• Create (empty) value sets first, then add the sets to your structure / instance and then define the
values for the value set
• Share the same value sets across multiple charts of accounts to facilitate consolidation if the values
are the same and have the same meaning
• You must use independent validation and the data type of character for your chart of accounts value
sets.
• Remember security is enabled at the value set level and applies to all segments that use that value set
• If security rules are applied to the shared value set used for both the company and intercompany
segments, you can experience problems with intercompany values used to record transactions with
balancing segment values outside the values that are use for the legal entities in your ledger

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Chart of Accounts Company Value Set

Company LoB
Account Value Set

Account Cost Center

Company Value Set

Intercompany

Value Attributes LoB Value Set CC Value Set

• If you select Yes for Summary (Parent), the application does

not post to the accounts created using that value even if
Allow Posting is set to Yes.
• Account Type, Third Party Control Account, Reconcile, and
Financial Category attributes are only available on the
Natural Account segment values
• The Financial Category is a seeded list and you can add
additional values.
• Summary: Yes indicates this value is a parent value.
• Allow Posting: Enter Yes to enable posting to the account. If
set to No, you cannot post to the account
• Allow Budgeting: Enter Yes to perform budgeting for
accounts with this segment value. If you are defining a parent
segment value, you must enter No.

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Chart of Accounts Company Value Set

Company LoB
Account Value Set

Account Cost Center

Company Value Set

Intercompany

Value Attributes LoB Value Set CC Value Set

• Third Party Control Account

– Enter Customer, Supplier, or Yes for the Third Party
Control Account to designate the account as a Control
Account.
– Access to this account can be restricted to Oracle
Payables, Receivables, and Inventory, for which Subledger
Accounting automatically creates detailed balances.
– Do not specify the account as a control account if you
want to use the account for all Oracle Fusion
Applications.
– Restrict Manual Journal option prevents using the
account in manual GL journal entries, but allows the
account in manual subledger accounting journal entries.
• Reconcile: Enter Yes for Reconcile to allow reconciliation for
natural accounts that should balance to zero
• Financial Category: Used with Oracle Transaction Business
Intelligence reporting to further identify groups of accounts

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Chart of Accounts Company Value Set

Company LoB
Account Value Set

Account Cost Center

Company Value Set

Intercompany

Hierarchies LoB Value Set CC Value Set

• Create hierarchies (trees) to identify managerial, legal or

geographical relationships between your value set values
• A given segment can have multiple hierarchies and each
hierarchy can have multiple versions
• Define date effective tree versions to reflect organizational
changes within each hierarchy over time
• Create multiple hierarchies for different purposes
• Publish multiple hierarchies to balances cubes to allow for
financial reporting and analysis of past, present, or future
data

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Chart of Accounts Company Value Set

Company LoB
Account Value Set

Account Cost Center

Company Value Set

Intercompany

Hierarchies LoB Value Set CC Value Set

• Important!
• Always create at least two hierarchy versions before creating any financial reports or
allocations. This will force the fully qualified member name path to be generated and
refers to the full tree name and tree versions. This will minimize report maintenance
if you must add tree versions in the future
• Best Practices (Doc ID 1520970.1)

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Chart of Accounts
• Securing a value set denies access to all values by default.
Security & Validations Create conditions and assign them to specific data roles to
control access to your segment values.

Account Combinations • Applies at the value set level. If a value set is secured, every
usage of the value set in a segment is secured
Segment Value Security
• Cross Validation Rules whether a value of a particular segment
Cross Validation Rules can be combined with specific values of other segments
• Use cross-validation rules in combination with dynamic
insertion
• Differs from segment validation, which controls the values you
can enter for a particular segment
• Revise cross-validation rules at any time, but remember that
they only prevent the creation of new invalid account
combinations
• Cross-validation rules do not affect existing accounts

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Demo
Chart of Accounts

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | 30

Agenda
1 Enterprise Structures
2 Reporting Structures
3 Ledgers
4 Rapid Setup

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 31
Reporting Structures
Example

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Ledgers
4C’s

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Ledgers
Secondary Ledgers

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Ledgers
Secondary Ledgers
• If the primary and secondary ledgers use different:
– Charts of accounts, the chart of accounts mapping (segment & account mapping
rules) is required to instruct the system how to propagate journals from the source to
the target chart of accounts
– Accounting calendars, the accounting date is used to determine the corresponding
non-adjusting period in the secondary ledger. The date mapping table provides the
correlation between dates and non-adjusting periods for each accounting calendar
– Ledger currencies, currency conversion rules are required to instruct the system on
how to convert the transactions, journals, or balances from the source representation
to the secondary ledger

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Ledgers
Secondary Ledgers – Conversion levels
• Adjustments only secondary ledger is an
incomplete accounting representation that only
holds manual or automatic adjustment journal
entries from General Ledger or Oracle Fusion
Subledger Accounting
• This conversion level requires that the secondary
ledgers share the same chart of accounts,
accounting calendar, and currency with its primary
ledger
• A complete accounting representation is achieved
by creating a report that includes both the primary
and secondary ledger data together.

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Ledgers
Reporting Currencies – Conversion levels

• Do not use journal or subledger level reporting

currencies if your organization only needs to
translate your financial statements to your parent
company's currency for consolidation purposes.
Standard translation functionality meets this need
• A full accounting representation of your primary
ledger is maintained at the subledger level
reporting currency
• Secondary ledgers cannot use subledger level
reporting currencies

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Ledgers
Legder Sets
• Enables you to group multiple ledgers that
share the same chart of accounts and calendar
combination to increase the efficiency of your
period close, security administration, and
reporting
• Allows you to treat multiple ledgers as one
• For example, you can open and close periods
for multiple ledgers in a ledger set in a single
submission by submitting the new Open and
Close Periods programs from the Submit
Request form

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Ledgers
Best Practices
• You should standardize on single corporate Chart of Accounts
• If you have global Chart of Accounts for all countries, you may use reporting
currencies rather than Secondary Ledgers
• If you need local statutory reporting plus corporate operational reporting, you can
use secondary ledgers to support a different COA
• If your ledgers share same COA and Calendar, you can group them into a Ledger Set
for shared operations (e.g., close, allocations, reporting etc)

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Demo
Ledgers
101
100 (US1)
102

201
200 (US2)
V (Corp)
202

300 (SSC) 301

400 (CA) 401

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | 40

Agenda
1 Enterprise Structures
2 Reporting Structures
3 Ledgers
4 Rapid Setup

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. | Oracle Confidential – Internal/Restricted/Highly Restricted 41
Rapid Implementation for Fusion Financials
Why?
• A way to get customers live in the minimum amount of time
• Capture the absolute minimum amount of data required
• Use the 80/20 rule
• Default the most common options
• Hide complex and advanced set up
• Advanced configurations can be added later where required
• Also applicable for setting up Demos, Test envs., Conference Room Pilots, etc

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Rapid Implementation Spreadsheets
Coverage
• Chart of Accounts, including value sets, value set values, structures and structure instances
• Account hierarchies, including trees and tree versions
• Accounting calendars
• Legal entities, including legal addresses, registrations, and identifiers
• Primary ledgers, with legal entity assignments to primary balancing segment values
• Business Units
• Account Defaulting
• Financial Sequences

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Rapid Implementation Spreadsheets
Steps
– [Link] Chart of Accounts, Ledger, Legal Entities, and Business Units in Spreadsheet
• Download the rapid implementation spreadsheet template.
• Populate the setup data and generate two zip files ([Link] and
[Link])
– [Link] Chart of Accounts:
• Invoke the Create Enterprise Structure process from the Scheduled Process page
• Upload your first file, [Link] as parameter to the process
– [Link] Chart of Accounts:
• Open the Manage Chart of Accounts Instance page.
• Select the chart of accounts and deploy the chart of accounts
– [Link] Ledger, Legal Entities, and Business Units:
• Invoke the Create Enterprise Structure process from the Scheduled Process page with the upload
data file as a parameter.
• Upload your second file, [Link] as parameter to the process

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Rapid Implementation for Fusion Financials
Other Spreadsheets
• Account Code Combinations
• Cross Validation Rules
• Segment Value Security

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |

Rapid Implementation
Demo

Copyright © 2014, Oracle and/or its affiliates. All rights reserved. |