How Fixed Asset Mass Adjustments Import Data Is Processed

Use the Fixed Asset Mass Adjustments Import process to perform the following mass adjustments:

Adjust financial details
Change categories
Change depreciation rules
Suspend and resume depreciation
Perform unplanned depreciation
Transfer source lines
Delete assets
Capitalize and reverse capitalize assets
Transfer reserve
Change group assets
Add source lines
Edit source lines
Delete source lines

You can download a mass adjustments 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 adjustment transactions and posting them to Oracle Assets.

This graphic shows the process of creating and posting adjustment transactions to Assets.

To access the template, complete the following steps

Navigate to the File-Based Data Import for Oracle Financials Cloud guide.
In the Table of Contents, click File-Based Data Imports.
Click Fixed Asset Mass Adjustments Import.
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 Adjustments Import Template

The Mass Adjustments import template contains an instructions tab, plus two 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 Financial Transactions process, and correcting import errors.
FA_ADJUSTMENTS_T	Enter information about the financial information for the assets. Based on the transaction type, the Post Mass Financial Transactions process inserts rows into the base tables for any rows that are in a status of Post.
FA_ADJ_SRC_LINES_T	Enter information about the source line and invoice information, such as the invoice cost and the asset cost clearing account that will be used for source line adjustments.

How Mass Adjustments Are Processed

To submit the Post Mass Financial Transactions process:

Navigate to the Assets page.
Select the Adjustments infotile.
Select the transactions and click Post.
If the Post Mass Financial Transactions process ends in error or warning, review the log file for details about the rows that caused the failure.

To correct import errors:

Click Exceptions on the Adjustments infotile.
Click Prepare to export all rows to a spreadsheet.
Review and correct the errors in the spreadsheet and set the queue to Post for the corrected rows.
Once all the rows with errors are corrected, click Save and Post Transactions.
Repeat the submission and error correction steps in this section until all rows are imported successfully and the assets are adjusted.

The following table shows errors that may occur during the Post Mass Financial Transactions 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 Financial Transactions 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 Financial Transactions process.

The following posting statuses are applicable to mass adjustments:

Posting Status	Meaning
New	Indicates that the data is new and may require additional information before adjustments can take place in the Post Mass Financial Transactions process.
On Hold	Indicates that the data should remain unprocessed by the Post Mass Financial Transactions process until it's set to a posting status of Post.
Post	Indicates that the data is ready for final posting to take place in the Post Mass Financial Transactions process.
Error	Indicates that the data was invalid and won't be submitted for processing in the Post Mass Financial Transactions process. You can set the records with errors to Delete if they must be removed from the database.
Delete	Indicates that the data won't be submitted for posting in the Post Mass Financial Transactions process.