How Fixed Asset Mass Revaluations Import Data Is Processed

Use the Fixed Asset Mass Revaluations Import process to upload a high volume of fixed asset revaluation transactions into Oracle Assets.

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

You can use the import process to create revaluation transactions and post the transactions using the Post Mass Fixed Asset Financial Transactions process.

To access the template, complete the following steps:

1. Navigate to the File-Based Data Import (FBDI) for Financials guide.
2. In the Table of Contents under Assets, click Fixed Asset Mass Revaluations Import.
3. 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.

The Fixed Asset Mass Revaluations Import template contains an instructions tab, plus a tab that represents the table 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 Additions process, and correcting import errors.
FA_ADJUSTMENTS_T	Enter information about the revaluation transactions, such as the revaluation method, revaluation value type, revaluation percent, and revaluation amount.

After you successfully load your data, you must submit the Post Mass Fixed Asset Financial Transactions process to import the data into the application table and create the revaluation transactions.

To submit the Post Mass Fixed Asset Financial Transactions process:

1. Navigate to Scheduled Processes.
2. Click Scheduled Processes.
3. Search for Post Mass Fixed Asset Financial Transactions.
4. Select the process name and click OK.
5. On the Schedule New Process dialog box, click OK.
6. Enter your book name and optionally enter a transaction group.
7. Click Submit.
8. Monitor the process status. If the Post Mass Fixed Asset Financial Transactions process ends in error or warning, review the log file for details about the rows that caused the error.

To correct import errors:

1. Navigate to the Manage All Books page by clicking Manage All Books in the Tasks panel tab in the Assets landing page.
2. Click the Revaluations tab in the Pending Transactions section.
3. Select the row that lists your transaction group that's in Error status.
4. Click Prepare All to export all rows to a spreadsheet.
5. Review and correct the errors in the spreadsheet and set the queue to Post for the corrected rows.
6. After updating all the rows, submit the post process by clicking Submit from the Manage Revaluations menu.
7. Repeat these steps until all rows are imported successfully.