Bulk Leases

You can create leases on a mass scale using FBDI.

You can create bulk leases using the following steps:

Step Number	Step	Description
1	Prepare MS Excel spreadsheet.	You must download the 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 New Leases. 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. Click Submit. Lease Accounting validates the data during the import into the Lease Accounting tables.
4	Start the Post-Import process.	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.