How Fixed Asset Mass Additions Import Data Is Processed

Use the Fixed Asset Mass Additions Import process to upload multiple assets into Oracle Assets.

You can download a mass additions 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 asset information.

You can use the import process to create assets from information outside of Assets, including:

• External sources, such as legacy systems.

• Oracle Project Costing.

• Oracle Payables.

• Application Developer Framework (ADF) desktop integration spreadsheet.

The following figure contains the flow of importing assets into Assets 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 Additions 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 Post Mass Additions Process

The Mass Additions 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 Additions process, and correcting import errors.
FA_MASS_ADDITIONS	Enter information about the assets that you're adding, such as the cost, number of units, and the asset book the asset will be added to.
FA_MASSADD_DISTRIBUTIONS	Enter information about the asset distributions, such as unit, location, and employee assignments.
FA_MC_MASS_RATES	Enter information about the reporting currency. Leave this tab blank if you don't use a reporting currency.

After you add the data to the FA_MASS_ADDITIONS table, you can perform additional preparations on the mass additions. For example:

• Add source, descriptive, and depreciation information.

• Assign mass additions to one or more distributions, or change existing distributions on the Assignments section of the Edit Source Lines page.

• Adjust the cost of a mass addition.

• Merge a mass addition into another mass addition.

• Split a multiple-unit mass addition into several single-unit mass additions.

• Add mass addition lines to existing assets, which creates a cost adjustment.

How Mass Additions Import Data Is Processed

After you successfully load your data, you must submit the Post Mass Additions process to import the data into the application tables and create the assets.

To submit the Post Mass Additions process:

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

2. Click Post All.

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

To submit the Post Mass Additions process you must select the appropriate corporate book. If your corporate book isn't listed in the list of values, then one of the following errors may have occurred:

Error	Solution
No mass additions lines in a status of Post.	Change the status to Post for the mass additions that are ready to be posted.
The corporate book isn't effective for these mass additions lines.	Check the effective date range of the corporate book on the Edit Book page.
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 Additions 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 Additions process.

When you run the Post Mass Additions process, mass additions lines are processed according to the mass addition status they're assigned to.

Status Before Posting	Effect of Post Mass Additions Process	Status after Posting
Post	Creates a new asset from the mass addition line.	Posted
Cost Adjustment	Adds the mass addition line to an existing asset.	Posted
Merged	Mass addition line was already merged.	Posted
Split	Mass addition line was already split; posting doesn't affect the mass addition.	Split
New	New mass addition line; posting doesn't affect the mass addition.	New
On Hold	Mass addition line is on hold; posting doesn't affect the mass addition.	On Hold
Delete	Mass addition line awaiting deletion; posting doesn't affect the mass addition.	Delete

To correct import errors:

1. Click the Exceptions link on the Additions infotile.

2. In the Search region, select the book and select the Error in the Queue field.

3. Click Search.

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. Once you correct all the rows with errors, click Submit and Post Mass Additions to resubmit the process.

7. Repeat the submission and error correction steps in this section until all rows are imported successfully and the assets are created.