Functional Setup Manager File Upload

Create and Upload Setup Files

You need to use the following steps to download the .csv format files, fill up the relevant information, and upload the files to Lease Accounting:

Manage Lease Accounting Configuration:

Sign in using the user role: Financial Application Administrator.
Navigate to the Setup and Maintenance page from the My Enterprise menu.
Change the functional area to Financials from the functional area list.
Click Lease Accounting.
On the 'Manage Lease Accounting Configuration' task, click Actions > Export to CSV.
Click Create.
Click Export only Template files option in the Export Data Setup to CSV File page.
Click Submit.
Click Ok and review the log when it is ready.
Download the compressed file from Ready for Download.
Extract the downloaded file to get 6 setup files (5 .csv) files.
Fill up all the required information in the .csv files. Compile all the six files into a compressed file.
Click Actions > Import Setup Data from CSV file.
Browse for the compressed file and Click Submit to create the setup data.

The following are the CSV files:

ORA_FLA_DISCOUNT_INDEX_RATES_csv
ORA_FLA_DISCOUNT_INDEX_INDEXES_csv
ORA_FLA_PAYMENT_TEMPLATE_ACCOUNTS_csv
ORA_FLA_PAYMENT_TEMPLATE_csv
ORA_FLA_SYSTEM_OPTIONS_csv

You can use the information in these files to upload system options, discount rate indexes, and payment term templates.

Note: Even if you are uploading only the system options, the input compressed file must contain all the six files (five .csv and one .xml).

You can use the same infrastructure to upload multiple objects for setups such as 6 or 10 different discount rate indexes.

You can update the setups by exporting the setup data and then making changes and importing the compressed file.

Manage Payment Increase Configuration:

The setups for the payment increase configuration for CSV file uploads are also available for the following:

Agreement Templates
Payment Increase Indexes

System Options

You use the system options to create the business unit for lease creation. It is a prerequisite.

You set up the system options to do the following processes:

Capture compliance standards options
Capture calculation options
Capture auto-numbering options
Create additional calendar for "Daily" calculations
Set the Inventory Item Master for setting up Equipment Leases
Enable Payables integration

You must provide the following system options information among other attributes:

Org Name: The business unit name.
Ledger Name: The ledger identifier in General Ledger.
Primary Regime: You must select the primary accounting standard. The valid options are IFRS16 and ASC842. The accounting for compliance leases and their balances are generated according to the selected accounting standard.
Secondary Regime: You must only select the secondary accounting standard if you need to comply with both standards. If the primary is IFRS16, the secondary will be ASC842 if both accounting standards are applicable for reporting and vice versa.
Interest Calculation Method: The interest calculation method is 'Daily Compounding Interest.'

Lease Accounting converts the periodic interest rate of 5% per annum to the daily compound interest rate. It employs the rate in the PV and Interest Expense calculations. The formula to convert rate is (1+R%) ^ (1/360 or 1/365) - 1.
Amortization Method: You can choose the 'Periodic' or 'Daily' amortization method.

In periodic amortization, the expense is uniform for all full periods.

Lease Accounting calculates and applies a daily rate based on the total number of days in that calendar period in daily amortization. You can select a custom calculation calendar for daily amortizations or use the GL calendar. Daily amortization only supports the 'Days/Month' proration for the lease.
Default Currency Conversion Type: The currency conversion type.
Calendar Name: The name of the GL calendar. You can provide a user-defined calendar like 4-4-5 for deriving calculations only for daily calculations. You can use your GL calendar for reporting and other General Ledger activities.
Item Master Organization Name: The identifier for the inventory item master. You can use an item from the Item Master reference for creating the equipment lease's assets.
Auto Asset Number Flag: The identifier to enable auto-numbering of the asset.
Auto Lease Number Flag: The identifier to enable auto-numbering of the lease.
Secondary Ledger Name: The name of the secondary ledger.

Add a secondary ledger only if you need to comply with the secondary accounting standard.

Note: You don't need to choose a secondary ledger if you don't need to report and account in multiple GAAPs.

Note: You can use only those business units with completed AP Financial options for creating lease accounting setups.

Note: You can create leases only for those business units defined in the system options setup.

Discount Rate Indexes

You set up the discount rate index to do the following processes:

Capture the Cost of Funds
Create the discount rates to use in PV calculations
Generate the amortization start date
Associate to the lease for applying the discount rate
Activate the index for lease use
Provide the appropriate names and descriptions for categorizing indexes

You must provide the following information for discount rate indexes among other attributes:

Name: The discount rate index name.
Business Unit: The business unit name.
Rate Value: The discount rate value for the effective dates.
Effective Start Date: The effective start date of the discount rate line.
Final Flag Display: The identifier to activate the discount rate index.

You can provide multiple discount rates within the same .csv file if the dates don't overlap and are in sequential order.

Payment Term Templates

You set up the payment templates to do the following processes.

Accelerate payment creation
Create error-free payments
Implement financial policies onto payments consistently
Drive calculation option of balances for right-of-use, liability, and expenses
Capture accounts for SLA accounting
Capture accounts for primary and secondary ledgers accounting
Capture tax attributes for defaulting onto AP Invoice

You must provide the following information for payment term templates among other attributes:

Name: The name of the payment term template.
Description: The description of the payment term template.
BU Name: The business unit name.
Payment Frequency Code Display: The frequency of the payment. The valid values are Daily, Monthly, Quarterly, or Annually.
Intercompany Flag Display: The identifier to mark Intercompany transactions.
Liability Flag Display: The identifier to enable liability.
ROU Asset Flag Display: The identifier to enable right-of-use.
Payment Purpose Code Display: The name of the payment purpose.
Payment Type Code Display: The name of the payment type.
Vendor ID Display: The name of the supplier.
Vendor Site ID Display: The site of the supplier.

Option Flag Display: The identifier to mark the option payment template.
Option Type Code Display: The type of option.

You must provide the following information from the FLA_LEASE_ACCOUNT_CLASS lookup among other attributes:

Account Detail Number: The unique account detail number used in the payment term template.
Account Class Code Display: The account class of the account in this distribution.
Ledger Name: The GL identifier associated with the payment term template.
CCID Segment: The identifier of code combination.

Accounting Information

Accounting Classes

You can use the following accounting classes:

Right-of-Use: The right-of-use account. You require it for Lease Booking.
Lease Liability: The lease liability account. You require it for Lease Booking.
Reserve: You use the reserve account when the right-of-use amount isn't the same as the lease liability amount.
Interest Expense:You use the interest expense account to capture the interest expense accrual in IFRS16, and include in Lease Expense in ASC842. You require it for IFRS16.
Amortization Expense: You use the amortization expense account (the equivalent of depreciation charge) to capture amortization expense accrual in IFRS16, and include in Lease Expense in ASC842. You require it for ASC842.
Accumulated Amortization: Lease Accounting collects the accumulated amortization expense in this account. You require it for the Lease Expense accounting event.
Lease Expense: The ASC842 lease expense account. You require it for ASC842.
Noncompliance Expense: The charge account for the noncompliance expense (no liability or right-of-use checks). Lease Accounting uses this account on noncompliance invoices on the expense distribution when it reaches Payables. You require it if the Payables setup doesn't have an 'Expense' account defined in the setup.
Payables Clearing: For compliance payments, Lease Accounting uses the payables clearing account as an offset for creating a temporary Payables Liability charge. You require it for the Lease Payments Approval event.
Payables Liability:You use the payables liability account on the credit side of AP invoice. Lease Accounting sends this account on the invoices that you source from it. If Payables setup doesn't have this account, you must define this account on the payment.
Gain/Loss: For all terminations and scope decrease amendments, Lease Accounting calculates the gain or loss in this account.
Foreign Exchange Gain/Loss: You use this account during the revision of transactions to reevaluate the right-of-use for foreign exchange transactions.