How Mass Retirements Import Data Is Processed

Use the Mass Retirements Import process to perform the following retirement transactions:

• Partial and full retirements

• Reinstatements

• Group asset adjustments

You can download a mass retirements spreadsheet template to use to prepare your data. The template contains an instruction sheet to help guide you through the process of entering your information.

This figure contains the flow for creating mass retirements and reinstatements and posting them.

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 Mass Retirements 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.

• don't change the order of the columns in the template.

• You can hide or skip the columns you don't use, but don't delete them.

Settings That Affect the Mass Retirements Import Process

The Mass Retirements 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 Post Mass Retirements process, and correcting import errors.
FA_RETIREMENTS_T	Enter information about the asset retirements. When you run the Post Mass Retirements process, any retirements with a status of Post are retired or reinstated.
FA_RETIREMENT_DIST_T	Enter information about the asset distributions, such as the units, depreciation expense account, location, and employee assignments. This information is used for partial or full unit retirements or reinstatements.
FA_RET_SRC_LINES_T	Enter the source line reference that's used for source line retirements or reinstatements.

How Mass Retirements Are Processed

After you successfully load your data, you must run the Post Mass Retirements process to retire and reinstate your assets.

To submit the Post Mass Retirements process:

1. On the Assets page, click the Ready to Post link on the Retirements infotile.

2. Click Post to post the transactions.

3. If the Post Mass Retirements process ends in error or warning, review the log file for details about the rows that caused the failure.

Note: You can also submit the Post Mass Retirements process from the spreadsheet you open when you click the Retire Assets in Spreadsheet task. On the spreadsheet, click Save and Post Transactions.

The following table shows errors that may occur during the Post Mass Retirements process and their solutions:

Error	Solution
The Calculate Depreciation process ran with errors.	Fix the errors and resubmit the Calculate Depreciation process. When the Calculate Depreciation process runs successfully, resubmit the Post Mass Retirements process.
The Calculate Depreciation process is currently running for the corporate book.	Wait until the Calculate Depreciation process completes successfully, and then resubmit the Post Mass Retirements process.

To correct import errors:

1. Click the Exceptions link on the Retirements infotile.

2. Click Prepare to export all rows to a spreadsheet.

3. Review and correct the errors in the spreadsheet and set the queue to Post for the corrected rows.

4. Once all the rows with errors are corrected, click Save and Post Transactions to resubmit the process.

5. Repeat the submission and error correction steps in this section until all rows are imported successfully and the assets are retired or reinstated.