1. Using Assets
  2. How Fixed Asset Lease Import Data Is Processed

How Fixed Asset Lease Import Data Is Processed

Use the Fixed Asset Lease Import process to upload your lease data into your corporate book. The template contains an instruction sheet to help guide you through the process of entering your asset information.

To access the template, complete the following steps:

  1. Navigate to the File-Based Data Import for Oracle Financials Cloud guide.

  2. In the Table of Contents, click File-Based Data Imports.

  3. Click Fixed Asset Lease Import.

  4. In the File Links section, click the link to the Excel template.

Follow these guidelines when preparing your data in the worksheet:

  • Enter the required information for each column. Refer to the tool tips on each column header for detailed instructions.

  • Do not change the order of the columns in the template.

  • You can hide or skip the columns you do not use, but do not delete them.

Settings That Affect the Fixed Asset Lease Import Process

The Fixed Asset Lease Import template contains an instructions tab, plus three tabs that represent the tables where the data is loaded:

Spreadsheet Tab

Description

Instructions and CSV Generation

Contains instruction information about preparing and loading data, the format of the template, submitting the Import Asset Leases process, and correcting import errors.

FA_LEASES_INT

Enter information about the leased assets that you are adding, terminating, or reassessing, including the transaction group, transaction type, and lease number.

FA_LEASE_BOOKS_INT

Enter information about the asset books the lease will be assigned to.

FA_LEASE_SCHEDULES_INT

Enter information about the payment schedule information for each leased asset.

How Lease Import Data Is Processed

After you successfully load your data, you must submit the Import Asset Leases process to import the data into the application tables and create the assets. To submit the Import Asset Leases process:

  1. Navigate to the Scheduled Processes page.

  2. Search for the Import Asset Leases process.

  3. Click OK.

  4. Select the book.

  5. Monitor the scheduled process.

  6. If the Import Asset Leases process ends in error or warning, review the log file for details about the rows that caused the failure. To correct import errors, open the .csv output file, correct the errors, and resubmit the process.