Seq # Configuration Item

Change Log
1 Open Items
2 Enable Offering
3 Role Creation
4 Assign Role
5 Data Access for Users
6 System Options
7 Discount Rate Index
8 Payment Template
9 Document Sequence
10 Lease Lookup
11 Setup Business Functions
12 Accounting Method
13 Approval Mechanism
14 DFF Creation
15 Mapping Set
16 Account Rule
17 Accounting Method
Oracle Fusion : Lease Accounting
Configuration Guide

Description Type
Mandatory
Optional
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Mandatory
Comments

Track any Open issues / items for discussion

 Change Log
Version Date Signed off by DM #(Ref)
(Change/Sign off)
Configuration Item Change Description DS User (requesting
change)
Client User (requesting
Change)
 Open Items
Item # Configuration Item Open Item
tems
DM # Issue Description
Comments
 Enable Offering for Lease Accounting
Navigation Home > My Enterprise > Offerings > Financials > Opt in Features
Type Mandatory
When needed Mandatory
Default Distributions
Column Name
Offering
Select Offering Lease Accounting

Select Features Create Property and Equipment lease

Lease Contract Activation
Lease Amendment for Scope Increase
Lease Amendment for Scope Decrease
Asset End Dates and Options
Lease Contract Import and Conversion
Lease Payment Processing
End of Lease Processing
Rapid Implementation for Lease
Accounting
Lease Disclosure and Transaction Report
g for Lease Accounting
Enterprise > Offerings > Financials > Opt in Features
Mandatory
Mandatory
Default Distributions
Enable
Enabled

Enabled
Enabled
Enabled
Enabled
Enabled
Enabled
Enabled
Enabled
Enabled
Enabled
 Roles Creation
Task Name Manage Job Roles
Type Mandatory
When needed Mandatory

Column Name Role Name Role Code Role Category

Data type Alphabetic Alphabetic

1 Lease Accounting Superuser Lease_Accounting_Superuser Financial - Job Role

2 Lease Contract Duty Lease_Contract_Duty Common - Job Roles

 Invoice Entry

Description Function Security Policy

Add Function Security Poicy

Lease Accounting Superuser Manager Lease Accruals

Manage Lease Configuration
Manage Lease Contract
Manage Lease Contract Data
Manage Lease Payment

Lease Contract Duty Manage Lease Contract

 Data Security Policy Role Hierarchy

CreateData Security Policy Role Name

Policy Name - Grant On Lease 1) Lease Contract Management

Data Resource - Business unit
Data set - Selecty by Instance Set 2) Lease Contract Management
Action - 1) Manage Lease Configuration 3) Manage Lease Contract
2) Manage Lease Contract
Condition - Access the Business Unit for
which the User is explicitly
authorized.

Policy name - Grant BU Lease Contract Duty

Data Resource - Business unit
Data Set - All Values
Actions - 1) Generate Amortization Schedule
2) Manage Lease Configuration
3) Manage Lease Contract
Condition - All Values
 Role Hierarchy

Role Code

ORA_FLA_LEASE_CONTRACT_DUTY_OBI
ORA_FLA_LEASE_CONTRACT_DUTY
FLA_MANAGE_CONTRACT_PRIV_OBI

Lease_Contract_Duty
 Assign Roles
Navigation Security console> Users> Search User> Add role
Type Mandatory
When needed Mandatory

Column Name Role Role Code

1 Lease Accounting Superuser Lease_Accounting_Superuser

2 Lease Contract Duty Lease_Contract_Duty
Assignable

Enabled
Enabled
 Data Access for User
Task Manage Data Access For Users
Type Mandatory
When needed Mandatory

Column Name User Name Role

Data type Select from LOV Select from LOV

Lease Accounting
1 Fusion_po Superuser
2 Fusion_po Lease Contract Duty
 Security Context Security Context Value

Select from LOV Select from LOV

Ledger OAB Primary Ledger

Ledger OAB Primary Ledger
 System Options
Task Name Manage Lease Accounting Configuration
Type Mandatory
When needed Mandatory

Primary Accounting
Column Name Business Unit
Standard

Oman Arab Bank IFRS 16

 Default Currency Amortization Auto Lease Auto Asset
Ledger Name
Conversion Type Calculation Frequency Numbering Numbering

Corporate OAB Primary Ledger Periodic Amortization No No

 Lease
Payable
Transaction Import Preference
Integration
Approval
Enabled No Auto Approval Yes
 Discount Rate Index
Task Name Manage Lease Accounting Configuration
Type Mandatory
When needed Mandatory

Column Name Business Unit

Data type Alphabetic

Oman Arab Bank

Discount Rate Index

Index Name Effective date

Date
Alphanumeric
MM/DD/YYYY
4.4 Discount Rate 1/1/2019
Discount Rate Line
Discount Rate Final
Start date
Date
Yes/No
MM/DD/YYYY
4.4 Yes
 Payment Template
Manage Lease Accounting
Task Name Configuration
Type Mandatory
When needed Mandatory

Column *Business Unit Payment Template Name Template Type

Data type Select from valid business units Alphanumeric Select from LOV
(Business units sheet )
Oman Arab Bank Lease Payment Template Payment
 Active Payment Purpose Payment Type Frequency Liability Right Of Use
Select from LOV Select from LOV Select from LOV Select from LOV

Yes Rent Base Rent Anually Enabled Enabled

 Distributions
Ledger Account Name Code Combination
Select From LOV Select From LOV

OAB Primary Ledger Right of Use Adjustment Loss 001.9999.000972500.000.000000

OAB Primary Ledger Right of Use 001.9999.919012000.000.000000
OAB Primary Ledger Lease Liability 001.9999.962685000.000.000000
OAB Primary Ledger Interest Expense 001.9999.930883000.000.000000
OAB Primary Ledger Amortization 001.9999.946116000.000.000000
OAB Primary Ledger Accumulated Amortization 001.9999.969020000.000.000000
OAB Primary Ledger Payable Liability 001.9999.930802025.000.000000
OAB Primary Ledger Payable Clearing 001.9999.930802040.000.000000
OAB Primary Ledger Lease Expense 001.9999.930883001.000.000000
OAB Primary Ledger Non Compliance Expense 001.9999.930883002.000.000000
OAB Primary Ledger Gain or Loss 001.9999.962685002.000.000000
OAB Primary Ledger Forex Gain and Loss 001.9999.962685003.000.000000
OAB Primary Ledger Reserve 001.9999.962685000.000.000000
OAB Primary Ledger Accrued Liability 001.9999.936708000.000.000000
 Document Sequence
Task Name Manage Document Sequence
Type Mandatory
When needed Mandatory

Column Document Sequence Name

1 Lease Accounting Document

Lease Accounting Document: Assignment

Column Document Sequence Category Name

Select Values from dropdown

1 Lease Sequence Category
Sequence manage invoice tolerance

Application Module Type

Select Values from dropdown Select Values from dropdown Select Values from dropdown
Lease Accounting Lease Accounting Gapless

Method Start Date End Date

Select Values from dropdown DD/MM/YYYY DD/MM/YYYY
Automatic 1/1/2019
 Determinant Type Start Date End Date

Select Values from dropdown DD/MM/YYYY

Business Unit 1/1/2019

Business Unit Value

Select Values from dropdown
Oman Arab Bank
 Lease Lookup
Task Name Manage Lease Accounting Lookups
Type Mandatory
When needed Manatory

Lookup Type Meaning

Select Values from drop down 25 Characters (alphanumeric)

1 ORA_FLA_OPTIN_OPTION Lease Accounting opt-in

Financial generic Lookup Type : ORA_FLA_OPTIN_OPTION

Sr. No. Lookup code Reference data Set

1 FLA_ATTACH_LDR_FROM_UI Common Set

2 FLA_DFF_VALIDATION_ENABLED Common Set

3 FLA_GENERATE_SCH_ESS_THRESHOLD Common Set

4 FLA_LDR_REPORT_ENABLED Common Set

5 FLA_LEASE_IMPORT_ESS_BATCH Common Set

6 FLA_PAYMENT_PRORATE_THRESHOLD Common Set

 Configuration
*Description Application
Level
250 characters
(alphanumeric)
Lease Accountig
Opt-in Options Lease Common Com User

Display Sequence Enabled Start Date End Date

3 Yes 1/1/2019

5 Yes 1/1/2019

2 Yes 1/1/2019

1 Yes 1/1/2019
4 Yes 1/1/2019

6 Yes 1/1/2019
 Meaning Description

Attach Lease Detail Report from the Attach Lease Detail Report from the
leases page leases page
Enable Descriptive flexfield
validation during lease action
No process fir import.
Threshold value of schedules to
submit Generate Schedules in ESS
500 mode
Lease Accounting lease detail report
Lease Detail Report Enabled enabled.
5000 Batch of leases to be import
Threshold for launching ESS program
when manage termination or
15 manage options is initiated.
 Setup Business Functions
Task Name Manage Business Unit Business Function
Type Mandatory
When needed Mandatory

Column *Name

Select from Available Options

Lease Accounting
Enable Primary Ledger Legal Entity

Yes OAB Primary Ledger Oman Arab Bank SAOC

 Accounting Method
Task Name Manage Accounting Methods
Type Mandatory
When needed Mandatory

Column Name Accounting Method

Select from Available options

1 XXOAB

Journal Entry Rule

Event Class Event Type
Set Assignment

Lease Accounting Lease Booking All

Lease Expense All
Lease Payment Approval All
Lease Revision All
Lease Termination All
hod

Effective Start
Rule Set Status Effective End date
Date

Lease Booking Active 1/1/2019

Lease Expense Active 1/1/2019
LeasePay Approval Active 1/1/2019
Lease Revision Active 1/1/2019
Lease Termination Active 1/1/2019
 Approval Mechanism
Manage Task Configuration For
Task Name Financials
Type Mandatory
When needed Mandatory

Create Approval Group

Column Name Task Option to select Approval Group
Select from available
Data type Search in column options Create

FinLeaseApproval Assignees> Go to Rule Lease Approval Group

Approval Rule
Column No. Task Option to select Create
1 FinLeaseApproval Assignees> Go to Rule General Rule

2 FinLeaseApproval Assignees> Go to Rule General Rule

3 FinLeaseApproval Assignees> Go to Rule General Rule

 Single Notification Setup

Column No. Task Option to select Task Aggregation

1 FinLeaseApproval Configuration Once Per Task
sm

Members
Add members in approval mechanism

2778
u2511

IF condition Then condition

FinLeaseApprovalPayloadTypeResponsibleU List Builder - Approval Group
serName is "2799" Response Type - Required
Approval Group - Lease Approval Group
All empty group - False
Rule Name - "Hassan_Lease ApprovalGroup"
Dimension ID - Null

FinLeaseApprovalPayloadTypeResponsibleU List Builder - Approval Group

serName is "2836" Response Type - Required
Approval Group - Lease Approval Group
All empty group - False
Rule Name - "Zuwaina_Lease ApprovalGroup"
Dimension ID - Null

FinLeaseApprovalPayloadTypeResponsibleU List Builder - Approval Group

serName is "U2645" Response Type - Required
Approval Group - Lease Approval Group
All empty group - False
Rule Name - "Omar_Lease ApprovalGroup"
Dimension ID - Null
 DFF creation
Manage Lease Accounting Transaction
Task Name Descriptive Flexfield
Type Mandatory
Mandatory (If Accounting needs to be done
When needed location wise)

Search below mentioned flexfield (Table) and Edit

Column No. Name Type

1 Lease Detail Descriptive Flexfield Descriptive Flexfield

Create a New Flexifield

Column No. Name Code

Location Code Location Code

n

Module Flexfield Code

Lease Transactrion FLA_LEASE_DETAILS

API Name Enabled Data Type

Location Code Yes Character

 Table Column Value Set Value Set Description

ATTRIBUTE_CHAR1 OAB BRANCH DEPT OAB BRANCH DEPT

 Prompt Display Type

Location Test List of Values

 Mapping Set
Manage Mapping Sets ( Lease
Task Name Accounting)
Type Mandatory
When needed Mandatory

Create Mapping set

Column No. Name Short Name

Location Mapping Set LMS

 Output Type Subledger application Input Sources

Lease Detail Alphanumeric Descriptive

Segment Lease accounting Flexfield 1
 Chart of Accounts Segment OAB Chart of Account Mapping
Input Output

OAB Chart of Accounts Branch Department 3101 3101

3102 3102
3111 3111
3112 3112
3113 3113
3114 3114
3115 3115
3116 3116
3117 3117
3118 3118
3119 3119
3152 3152
3153 3153
3154 3154
3155 3155
3156 3156
3157 3157
3158 3158
3159 3159
3160 3160
3161 3161
3162 3162
3163 3163
3121 3121
3122 3122
3123 3123
3124 3124
3125 3125
3126 3126
3127 3127
3128 3128
3129 3129
3130 3130
3131 3131
3132 3132
3136 3136
3137 3137
3138 3138
3139 3139
3140 3140
3141 3141
3142 3142
3144 3144
3145 3145
3146 3146
3147 3147
3148 3148
3149 3149
3151 3151
3106 3106
3110 3110
3108 3108
3109 3109
3104 3104
3107 3107
3183 3183
 Create Account Rule
Task Name Manage Account Rules
Type Mandatory
When needed Mandatory

Column No. Name Short Name

Lease Location Rule LLR

count Rule

Description Chart Of Accounts Rule Type

Lease Location Rule OAB Chart of Accounts Segment > Branchs Department
 Rule

Value Type - Mapping Set

Value - Location Mapping Set
 Accounting Method
Task Name Manage Subledger Journal Rule Set
Type Mandatory
When needed Mandatory

Column Name Event Class

Lease Booking 1 Lease Booking

Lease Expense 1 Lease Expense
Lease Impairment 1 Lease Impairment
Lease Revision 1 Lease Revision
Lease Termination 1 Lease Termination
Lease Pay Approval 1 Lease Pay Approval

Task Name Manage Accounting Methods

Type Mandatory
When needed Mandatory
Journal Entry Rule set
Column Accounting Rule
Assignment
Lease Accounting
XXOAB
nting Method

Event Type Chart of Accounts Subledger Application

All OAB Chart Of Accounts Lease Accounting

All OAB Chart Of Accounts Lease Accounting
All OAB Chart Of Accounts Lease Accounting
All OAB Chart Of Accounts Lease Accounting
All OAB Chart Of Accounts Lease Accounting
All OAB Chart Of Accounts Lease Accounting

Create
Event Class Event Type Rule Set

Lease Booking All Lease Booking

Lease Expense All Lease Expense
Lease Payment Approval All Lease Payment Approval
Lease Revision All Lease Revision
Lease Termination All Lease Termination
Lease Booking All Lease Booking 1
Lease Expense All Lease Expense 1
Lease Payment Approval All Lease Payment Approval 1
Lease Revision All Lease Revision 1
Lease Termination All Lease Termination 1
 Status Accounting Date

Active Accounting Event Date

Active Accounting Event Date
Active Accounting Event Date
Active Accounting Event Date
Active Accounting Event Date
Active Accounting Event Date

Create
Status Effective Start

Active 1/1/2000
Active 1/1/2000
Active 1/1/2000
Active 1/1/2000
Active 1/1/2000
Active 3/1/2000
Active 3/1/2000
Active 3/1/2000
Active 3/1/2000
Active 3/1/2000
 Description Rule Branch Department

For All Line types

Lease Accounting Header Lease Location Rule
Lease Accounting Header Lease Location Rule
Lease Accounting Header Lease Location Rule
Lease Accounting Header Lease Location Rule
Lease Accounting Header Lease Location Rule
Lease Accounting Header Lease Location Rule

Effective End Date

2/1/2000
2/1/2000
2/1/2000
2/1/2000
2/1/2000