Manage Options Modifications

You need to manage options on a mass scale. You could manage options of multiple leases by exercising or canceling them.

You can manage options to your portfolios to keep them current and maintain accurate information. By managing options, you can do the following:

  • You can have a true and fair representation of right-of-use assets or liabilities.
  • You can improve the comparability of financial statements and the investors are better informed.
  • You can have a fair market value reflecting the assets and balance sheets.
  • You can integrate with third-party tools for seamless import of the options in bulk.
Step Number Step Description
1 Prepare MS Excel spreadsheet.

You must download the Oracle Lease Accounting FBDI spreadsheet and fill up all the required information in the various tabs.

You must then convert the spreadsheet into a CSV file. Use the Generate CSV button provided on the first tab of the spreadsheet.

2 Load data into interface tables.

You must run a schedule process: Load Interface File for Import with a Process Lease Actions parameter.

You now provide the CSV file and select the parameters. Oracle Lease Accounting uses the control files to convert the data from the CSV file and insert it into Lease Accounting Interface tables.

If there are any fundamental data errors, Lease Accounting rejects the whole CSV file for the load process errors.

The loader program also purges data for the records showing the errors from the interface tables.

3 Start the Import process.

After the load process is successful, you must run the import program to move the data from the interface tables into Lease Accounting transaction tables.

You need to run the Import Leases program from the side-panel.

The following parameters are available:

  • Action Type: Import Leases
  • Import Type: Select Terminations and Manage Options.
  • Business Unit: Select the business unit.
  • Select the load request identifier.
  • Interface Lease from Identifier: Select, if required.
  • Interface Lease To Identifier: Select, if required.

Lease Accounting validates the data during the import into the Lease Accounting tables.

You can provide target status to the options as Draft or Active.

4 Start the Post-Import process.

If the option is Draft, then the Lease Accounting performs the following steps:

  • Lease Version = Incremented
  • Lease Status = Active
  • Lease Version Status = Working

If the option is Active, then Lease Accounting performs all the steps in the background.

You can process the lease further to the finalized stage.

5 Run additional processes. The Process Lease Actions picks up the leases and attaches the Lease Details Report to each lease.

Lease Accounting lists all the errors in the Import Exceptions tab of the Lease Accounting dashboard.