3Implementation Tasks

This chapter contains the following:

Roadmap for Setting Up

Use this roadmap as the high-level procedure to implement lease accounting.

  • Payables Financial Options

  • System Options

  • Primary Discount Rate Indexes

  • Payment Term Templates

  • General Ledger Calendars

  • Account Payables Suppliers and Sites

  • Document Sequencing

  • Currency Conversions

  • Payment Terms

  • Inventory Organizations

  • Master Item List

Set Up Payables Financials Option

You must set up the Payables Financials Options before setting up the system options.

Lease Accounting Setups

You must use the following steps for Lease Accounting Setups upload:

  1. Login using user role: Financial Application Administrator.

  2. Select Financials > Fixed Assets > Task: Manage Lease Accounting Configuration.

  3. From Actions > Export to CSV.

  4. Create New > Check Export only Template files.

  5. Submit > Download files from Ready for Download.

  6. Unzip the downloaded file to get 6 setup files (5 .csv) files.

  7. Fill all the mandatory data in the .csv files. Compile all the 6 files into a zipped file.

  8. Go to Actions > Import Setup Data from CSV file.

  9. Browse for the zipped 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, Payment Term Templates, and Discount Rate Indexes.

Note: Even though you're, for example, uploading only the System Options, the input zipped 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 re-importing the zipped file.

Note: This task only supports FSM file uploads.

System Options:

You must provide the following information among other attributes:

  • OrgName: The business unit name.

  • AmortizationMethod: The frequency of the amortization.

  • LedgerName: The ledger identifier in the General Ledger.

  • PrimaryRegime: The primary accounting standard. The valid options are IFRS16 and ASC842.

  • SecondaryRegime: The secondary accounting standard. If primary is IFRS16, then secondary will be ASC842, if both accounting standards are applicable for reporting, and vice-versa.

  • Interest CalculationMethod: The interest calculation method

  • DefaultCurrencyConvType: The currency conversion type.

  • CalendarName: The name of the GL calendar.

  • ItemMasterOrgName: The inventory item master identifier.

  • AutoAssetNumberFlg: The identifier to enable auto numbering of the asset.

  • AutoLeaseNumberFlg: The identifier to enable auto numbering of the lease.

  • SecondaryLedgerName: The name of the secondary ledger.

Note: Only those business units for which AP Financial options are complete can be used for creating lease accounting setups.
Note: Leases can't be created for those business units for which the system options aren't defined.

Discount Rate Indexes:

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

  • Name: The discount rate index name.

  • BusinessUnit: The business unit name.

  • RateValue: The discount rate value for the effective dates.

  • EffectiveStartDate: The effective start date of the discount rate line.

  • FinalFlagDisp: The identifier to activate the discount rate index.

You can provide multiple discount rates within the same CSV file if the dates aren't over-lapping each other and are in a sequential order.

Payment Term Templates:

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

  • Name: The name of the payment term template.

  • Description: The description of the payment term template.

  • BuName: The business unit name.

  • PaymentFrequencyCodeDisp: The frequency of the payment. The valid values are Daily, Monthly, Quarterly, or Annually.

  • IntercompanyFlagDisp: The identifier to mark Intercompany transactions.

  • LiabilityFlagDisp: The identifier to enable Liability.

  • RouAssetFlagDisp: The identifier to enable right-of-use.

  • PaymentPurposeCodeDisp: The name of the payment purpose.

  • PaymentTypeCodeDisp: The name of the payment type.

  • VendorIdDisp: The name of the supplier.

  • VendorSiteIdDisp: The site of the supplier.

  • OptionFlagDisp: The identifier to mark the option payment template.

  • OptionTypeCodeDisp: The type of option.

You must provide the following information from the FLA_LEASE_ACCOUNT_CLASS lookup among other attributes for the payment term template accounts:

  • AccountDetailNumber: The unique account detail number used in the payment term template.

  • AcccountClassCodeDisp: The account class of the account in this distribution.

  • LedgerName: The GL identifier associated with the payment term template.

  • CCIdSegment: The identifier of code combination.

Import Primary Discount Rate Indexes

You must setup the primary discount rate index using FSM file upload.

Import Payment Term Templates

You can setup payment term templates using FSM file upload.

Set Up General Ledger Calendars

You must configure the GL calendars to enable selection of accounting dates for leases.

For daily calculations, set up the GL calendar as per your business needs such as 4-4-5.

Set Up Payables Suppliers And Sites

You must set up the Payables supplier and supplier site information to complete the payment information in the leases.

Set Up Document Sequencing

You must setup document sequencing to leverage the auto-numbering functionality of lease objects such as leases, assets, and payments.

You can setup document sequencing through: Task > Manage Document Sequences and completing the following steps:

  • Create a new sequence.

  • Associate the new sequence to "Lease Accounting Lease Sequence Category."

  • Associate the new sequence to the business unit.

Set Up Currency Conversions

You must configure the currency information to enable the selection of currency for payment information in the lease.

Set Up Payment Terms

You must set up the payment terms after setting up the payment term templates.

Set Up Inventory Organizations

You must set up the inventory organizations to enable selection of the assets.

Set Up Master Item List

You must set up the master item list to enable the selection of asset items.