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