Organization Structure

EBS Multi Org Fusion Enterprise

Structure
Enterprise KLM
Business Group KLM_BG Legislative Data groups KLM_LDG
Divisions (Optional) KLM_US_DIVISION
Primary Ledger KLM_US_PL Primary Ledger KLM_US_PL
Legal Entity KLM_LE Legal Entity KLM_LE
Operating Unit KLM_OU Business Unit KLM_BU
Distribution Centers KLM_DC
(Optional)
Inventory Inventory KLM_Inv
Sub-Inventory KLM_Inv Sub-Inventory
Locator Locator

Legislative Data groups is equal to Business Groups. In EBS we can create number of Business
Groups on country based. In Fusion we have only one Enterprise for one Instance. Legislative
Data groups is consider as a Business Group.
In EBS employee information is maintain at business groups like Jobs, positions, Grades and
employee numbers base on country specific. In Fusion employee information is maintain at
Enterprises level. If you want to maintain country specific employee information like Jobs,
positions, Grades and employee numbers, we need create Legislative groups.
In EBS Division need to be create under COA. In Fusion we can create Division under COA ,
apartment from that we can also create Division under Enterprise
There is no Distribution Centers in EBS. In Fusion we have Distribution Centers which is
distributing material to customer.
Fusion Security/Roll Based Access EBS
Control(RBAC)
Job Roll is equal to Menus (Payables Manager)
Duty Roll is equal to Sub-Menus(Invoice entry)
Functions
Data Roll is equal to AP Super User Responsibility
Assign PL and OU to Responsibility to Access
transactions ( AP Resp+PL+BU)
Abstract Roll is equal to Employee (HCM)
Data roll assign to User in Fusion

1.Implementation User Creation in Oracle Identity

Manager
Note: The very first user you need to create before you can create an Implementation
Project is an Implementation User, such as an Application Implementation Consultant.
 In Fusion we have two types of users. One is Implantation user and another is
Employee user. Implantation user can do only configuration and Employee user can do
transactions.
1. Login with your fusion login user id and password. (This user must be a super
user, such as FAADMIN.)
2. Select Navigator> Setup and Maintenance
3. From the All Tasks tab, enter in the Name field Manage Implementation Users.
Note: You are searching for this task name directly
OR
Financials  Define Implementation Users  Create Implementation Users

1. Click the Go to Task icon for this task. This opens Identity Manager.
2. Click on the Administration link on the top right hand corner of the main page.
3. Click Create User and enter the following:
 First Name
 Last Name
 Email
 User Login
 Password
 Confirm Password
 Organization- Xellerate Users.
 User Type: Choose Anything
 Click on Save
2. Roles Assignment
1. Click the Roles tab.
2. In the Roles tab, the ALL USERS role will already be assigned by default.
3. Click Assign icon to bring up the window to search for additional roles to add to
the user.
 Application Implementation Consultant
 IT Security Manager
 OIMAdministrators
 Human Capital Management Application Administrator
 Human Resource Manager
 Employee (This is needed for Scheduled Processes to show up on the
Navigator.)
3. Create Implementation Project
Setup and Maintenance Manage Implementation Projects
Click on ‘Manage Implementation Projects’ under Tasks
Click on ‘New’ Icon to create a new implementation project.
Name : OFF Implementation Project
 Code : OFF_IMPLEMENTATION_PROJEC (Code will get generated automatically)
 Description : OFF Implementation Project
 Click on ‘Next’ button
 Include Implementations tasks within each main folder and sub folder.
 Click on ‘Save and Open Project’
 Click on ‘Done’ button

4. Run User and Roles synchronic program

Financials  Define Common Applications Configuration for Financials  Define
Synchronization of Users and Roles from LDAP  Run User and Roles Synchronization
Process
Note: This program is similar to Replicate Seed Data in R12 which will assign Job roles to user
and Defaults standard properties
5. Manager Location
Financials Define Common Applications Configuration for Financials  Define Enterprise
Structure for Financials Define Enterprise for Financials  Manage Locations
Click on Go To Task
  Click on + button to create Location

Effective Start Date : It will defaut

Location Set : Common Set ( it is better to create your own Data Reference Set)
Name : OFF US Corporate
Code : OFF US Corporate
Country : United States
  Enter Address details

Click on Save
 Click on Submit
 Click on Yes button warning message box
Click on Done
6. Setup Enterprise
Financials Define Common Applications Configuration for Financials  Define
Enterprise Structure for Financials Define Enterprise for Financials  Manage
Enterprise HCM Information
Click on ‘Go to Task’ Icon

 Click on ‘Edit’ dropdown button and select ‘Correct’ button

 Change the Name to OFF Corporation
 Select Location ‘OFF US Corporation’ from the list of values.
 Click on ‘Submit’ button

7. Manage Legal Jurisdictions

Financials Define Common Applications Configuration for Financials  Define Enterprise
Structure for Financials Define Legal Jurisdictions and Authorities for Financials Manage
Legal Jurisdictions >Click on Go To Task

Click on + button to create Jurisdictions

Name : OFF US Jurisdiction

Territory : United States
Identifying : Yes
Legal Entity Registration : TRN
Legal Reporting Unit Registration Code : TAN Number

Click on ‘Save and Close’ button

8. Manage Legal Addresses

Financials Define Common Applications Configuration for Financials  Define Enterprise
Structure for Financials Define Legal Jurisdictions and Authorities for Financials Manage
Legal Addresses > Click on Go To Taks
  Click on ‘+’ Icon. It will open the below screen.
 Create Legal Entity Address for OFF US Corporation
 Click ‘OK’ button.

 Click on ‘Save and Close’ button

9. Manage Legal Entity

Financials Define Common Applications Configuration for Financials  Define Enterprise
Structure for Financials Define Legal Entities for Financials Manage Legal Entity
Click on Go To Task
  Legal Entity : Select ‘Create New’
 Click on ‘Apply and Go to Task’ button

 Click on ‘+’ Icon to Create Legal Entity

Enter the below details

Country : United States
Name : OFF Computers
Legal Entity Identifier : OFF Computers
Legal Address : (Address created in earlier step)
Enable Payroll statutory unit
Enable Legal employer
ETN or TRN: OFFCOMTRN
Legal Reporting Unit Registration Number: OFFCOMTRN
Click on ‘Save and Close’ button.
 Select Legal Entity to define the scope of the tasks.

 Legal Entity: Select and Add

 Click on Apply and Go To Task

 Search OFF Computers Legal Entity

 Click on Save and Close
 Legal Entity will get defaults for below tasks
10. Manage Legal Entity Registrations

11. Define Chart of Accounts (COA) Value Sets

Financials Define Common Applications Configuration for Financials  Define Enterprise
Structure for Financials Define Financial Reporting Structures Define Chart of Accounts
 Manage Chart of Accounts Value Sets

 Click on + button to create Value Sets

 Create values set for Company, Department, Account segments as mentioned below
12. Define Chart of Accounts Structures
Financials Define Common Applications Configuration for Financials  Define Enterprise
Structure for Financials Define Financial Reporting Structures Define Chart of Accounts
 Manage Chart of Accounts Structures > Click on Go To Task

 Perform blank search by clicking on ‘Search’ button

 It will display General Ledger Accounting Flexfield information and Also it will enable Manage
Structures, Manage Structure Instances, and Deploy Flexfield buttons in enable mode

 Click on ‘Manage Structures’ button and click on ‘+ Create’ button.

 Structure Code : OFF COA Structure

 Name : OFF COA Structure
 Description : OFF COA Structure
 Delimiter : ‘-‘
 Click on Save button

 + Create button will enable under Segments section

 Click on + create button to create Key Flexfields Segment like Company, Department
and Account
Segment Code : Company
API Name : company
Name : Company
Description : Company
Short Prompt : Company
Sequence Number: 1
Prompt : Company
Display Width : 2
Column Name : SEGMENT1
Default Value Set Code: OFF Company
Segment Labels: Primary Balancing Segment
Click on ‘Save and Close’ button
Note: Create other segments similarly
13. Define Chart of Accounts Structure Instances
Financials Define Common Applications Configuration for Financials  Define Enterprise
Structure for Financials Define Financial Reporting Structures Define Chart of Accounts
 Manage Chart of Accounts Structure Instance > Click on ‘Go to Task’ Icon

 Click on ‘Search’ button and it will open the below screen. ‘Manage Structure Instances’ will get
enabled.
 Click on ‘Manage Structure Instances’ button
  Click on ‘Create’ Button.

Enter the below details

Structure Instance Code: OFF COA Structure Instance
API Name : OFF COA Structure Instance
Name : OFF COA Structure Instance
Description : OFF COA Structure Instance
Enable Dynamic combination creation allowed
Structure Name : OFF COA Structure (Select from drop down)
Segment Codes will be displayed.

 Click on Edit Icon and make necessary changes required for the value sets. And give
default values in order to get the value defaulted for any segment value while creating
account code combination
 Click on OK and Save and Close
 Click on Done

14. Deploy Chart of Accounts (COA) Structure

Financials Define Common Applications Configuration for Financials  Define Enterprise
Structure for Financials Define Financial Reporting Structures Define Chart of Accounts
 Manage Chart of Accounts Structure Instance

 Click on ‘Go to Task’ button.

 Click on ‘Search’ button in order to enable ‘Deploy Flexfield’ button

 Click on ‘Deploy Flexfield’ button.
 System will submit the process to perform validation.

 Once the process completes, system will display the below message
 Click on OK button
  Deployment Status should be enable

15. Define COA Segment Value Set Values

Financials Define Common Applications Configuration for Financials  Define Enterprise
Structure for Financials Define Financial Reporting Structures Define Chart of Accounts
 Manage Chart of Accounts Structure Value Set Values > Click on ‘Go to Task’ Icon

 Enter Value Set Code: OFF

 Click on Search button
 Select Value Set Code and click on Manage Values
 Click on ‘+ Create’ Icon

 Define Values and Value Attributes. Click on ‘Save and Close’ button.

 Create other values for that segment and click on ‘Done’ button.
 Repeat the above steps for the rest of the segments values
 Define values for Account segment for account type Asset, Liability, Expense, Revenue, Owner’
Equity.

 Click on Account Segment to define Account segment Values:

 To define parent values, select summary as ‘Yes’, Allow Posting and Allow budgeting as ‘No’.
  To define child values, select summary as ‘No’, Allow Posting and Allow budgeting as ‘Yes’.
 Click on ‘Save and Close’ button.

Click on ‘Save and Close’ button and ‘Done’ button.

16. Define Account Hierarchies

( Note: It is optional, If we are defining parent and child relationship then only use this
functionaliy)
Financials Define Common Applications Configuration for Financials  Define Enterprise
Structure for Financials Define Financial Reporting Structures Define Chart of Accounts
 Manage Account Hierarchies > Click on ‘Go to Task’ Icon
  Click on ‘Create’ Icon

Name : OFF Account Hierarchy

Code : OFF Account Hierarchy
Tree Structure: Accounting Flexfield Hierarchy

 Bind_ValueSetCode: OFF Account

 Click on ‘Save’ button and Next button
  Click on Next button

 Click on ‘Submit’ button

 Search Tree Name: OFF

 Click on drop down button beside ‘Create’ button
 Click on Create Tree Version

Tree Name : OFF Account Hierarchy

Tree Code : OFF Account Hierarchy

Name : OFF Account Hierarchy_Version2017

Effective Date :
Click on Next button
 A message box would be display as mentioned below
 Click on OK

 Click on + button

 Select Data Source : Accounting Flexfield Hierarchy for Parent Values

 Select all the parent for which you want to create child values.
 Click double arrow button to select values in select mode

 Click on OK button
c

 Click on submit button

17. Publish Account Hierarchies
Financials Define Common Applications Configuration for Financials  Define Enterprise
Structure for Financials Define Financial Reporting Structures Define Chart of Accounts 
Publish Account Hierarchies > Click on ‘Go to Task’ Icon

 Search for Value Set ‘OFF Account’

 Keep the cursor on Tree Version and Enable ‘Publish’
 Click on ‘Publish’ button

 Click on OK button

 Click on ‘Save and Close’ button

Navigate to : Scheduled Process and verify whether Publish Chart of Account Hierarchy program
successful

18. Define Calendar

Financials Define Common Applications Configuration for Financials  Define Enterprise
Structure for Financials Define Financial Reporting Structures Define Calendars  Manage
Accounting Calendars > Click on ‘Go to Task’ button

 Click on ‘ + Create’ Icon

Name: OFF Calendar
Description: OFF Accounting Calendar
Start Date: E.g: 4/1/2017 ( Calendar start Date)
Adjustment Period Frequency: Once at year end
Period Frequency: Monthly
Separator: ( -)
Format MMMYY-Calendar year
First Period: Apr-17
Click on Next

 Periods will get created automatically

 Change Adjustment period name if require.

 Click on Save and Close
  Click on Done

19. Define/Enable Currencies

Financials Define Common Applications Configuration for Financials  Define Enterprise
Structure for Financials Define Financial Reporting Structures Define Currencies  Manage
Currencies > Click on Go To Task

 Search the Currency: USD and Enable check box

20 . Currency Rate Type
Financials Define Common Applications Configuration for Financials  Define Enterprise
Structure for Financials Define Financial Reporting Structures Define Currencies  Manage
Conversion Rate Type

21 . Currency Daily Rates

Financials Define Common Applications Configuration for Financials  Define Enterprise
Structure for Financials Define Financial Reporting Structures Define Currencies  Manage
Daily Rate
 OR

Navigator-> General Accounting->Period Close->Manage Currency rates

ADFDI template will get downloaded and system prompt will appear. In ADFDI template, user is required
to provide the login credentials again. Click on Yes button.
22. Define Primary Ledger
Financials Define Common Applications Configuration for Financials  Define Ledgers 
Define Accounting Configurations  Manage Primary Ledgers > Click on ‘Go to Task’ Icon.
  Click on ‘+ Create’ Icon.

Provide the below details

Name : OFF US Primary Ledger
Description : OFF US Primary Ledger
Chart of Accounts : OFF COA Structure Instance
Accounting Calendar : OFF Calendar
Currency : USD – US Dollar
Accounting Method : Standard Accrual
Click on ‘Save and Edit Task List’ button

 Click on Done

22. Assign Legal Entities

 Financials Define Common Applications Configuration for Financials  Define Ledgers
 Define Accounting Configurations  Assign Legal Entities > Click on Go to task
 Select Assign Legal Entities option
 Primary Ledger: Select and Add
 Click on ‘Apply and Go to Task’ button

 Select OFF US Primary Ledger.

 Click on ‘Save and Close’ button.
 It will open the below screen. Click on ‘+ Add’ Icon.

 search Legal Entities (OFF Computers). Select ‘Done’ button.

 Click on ‘Save and Close’ button.

23. Define Ledger Options
Financials Define Common Applications Configuration for Financials  Define Ledgers 
Define Accounting Configurations  Specify Ledger Options > Click on ‘Go to Task’ button.

 Journal Language: American English

 Retained Earnings Account:
 All other required ledger options as per the requirement.

 Click on Save and Close

24. Assign Balancing Segment Values to Legal Entity
Financials Define Common Applications Configuration for Financials  Define Ledgers 
Define Accounting Configurations  Assign Balancing Segment Values to Legal Entities > Click
on ‘Go to Task’ button

 Keep the cursor on Legal Entity and click on ‘ + Create’ icon. It will open the below screen.
 Select Company Value: 10.
 Click on ‘Save and Close’ button

 Follow above steps to assign Other Balancing Segment values

25. Review and Submit Accounting Configuration
Financials Define Common Applications Configuration for Financials  Define Ledgers 
Define Accounting Configurations  Review and Submit Accounting Configuration > Click on ‘Go
to Task’ Icon

 Click on Submit Button

 Click on OK button
 Create Accounting Configuration process will run
Navigate to Scheduled Process and verify the below programs completed normal

26. Open GL Period

Financials Define Common Application Configurations for Financials Define Ledgers Define
Secondary Ledgers  Open First Period > Click on Go to Task

Select Parameters
 Data Access Set: OFF US Primary Ledger
 Ledger or Ledger set: OFF US Primary Ledger
 Period: Apr-17
 Click on Submit button
Navigate to: Scheduled process and Verify Open General Ledger Period program complete Successes

27. ROLES and SECURITY

Roles

Financials -> Define Common Applications Configuration for Financials -> Define Implementation
Users -> Provision Roles to Implementation Users > Click on Go to Task
Click on Administration at right side of the screen

 Click on Advanced Search - Users

 Enter User Login: FFinance

 Click on search button
  Click on Roles tab

 Click on Assign button

 Enter: OFF US Primary Ledger

 Click on search button
Select roles and click on Add button
 Financial Analyst OFF Primary Ledger
 Controller OFF Primary Ledger
 Chief Financial Officer OFF Primary Ledger
 General Accountant OFF Primary Ledger
 General Accounting Manager OFF Primary Ledger
 XX GL Analyst OFF Primary Ledger
Below steps are optional to view Application roles

28.Duty Role (Application Roles) ( Sub-Manu)

These are kind of duties performed by individual employees, like invoice entry, invoice approval, journal
creation, payment processing etc. these are the individual tasks performed by employee. One employee
can perform multiple duties. These are also called as application roles, the definition of these roles are
maintained in APM(Authorization policy Manager).

Go to Setup and Maintenance search for Manage Duties in search text box
APMSearch for Application Roles in FSCM as shown below to view the list of Application Roles
29. Job Role (External Roles) - (Menu)
These are the collection of duties performed by individual, like payables manager is responsible for
invoice creation, invoice approval, payment processing etc. Multiple duties can roll into one job role. For
example

Go to Setup and Maintenance search for Manage Duties in search text box
APMSearch for Application Roles in FSCM as shown below to view the list of Application Roles
30. Abstract Role ( Employee)
These roles are associated with a user irrespective of the Job they perform within an enterprise.
Therefore abstract roles are at a higher level spanning various jobs, and hence their name abstract.
Examples are Employee Role, Temporary Staff role, Manager etc. It inherits duty role but does not
contain security policies. These roles are assigned to the user by system automatically, for example while
Employee creation, Procurement Agent creation etc. The abstract roles can be identified by the Role
Name ending with ‘ABSTRACT’
31. Data Role ( Responsibility +PL+OU)
A data role defines components of data within which a job is performed. The data role inherits the job
role that describes the job. For example, a data role entitles a user to perform a job in a business unit
and data roles are implemented as job roles for a set of data. The data role inherits abstract or job
roles and is granted data security privileges. Data roles carry the function security privileges inherited
from job roles and also the data security privilege granted on database objects and table rows.

31. Journal Creation and Posting