Update Mass Additions

The user should update or change the missing details for each record.

The following table describes the columns that can be updated.

Column Notes

Column	Notes
Assets Upload Action	This will be `Update` or `Update records`.
Mass Additions ID	Should not be updated.
Queue	Typically, your workflow will look like this: * `New` (Imported from AP) * `On Hold` (If details are missing) * `Post` (ready to create asset) * `Posted` (Asset created successfully) * `Error` (Asset not created and in error) `Merged` are child records that have been merged to a parent record within the Mass Additions table. These rows cannot be updated. `Delete` (to be deleted).
Book	Should not be updated.
Asset Number	Leave blank if you wish the system to generate or enter a unique number. See notes below.
Description*	Description of an asset. You can use this attribute to describe the asset features, characteristics etc.
Merged Code	`MC` = Merged Child `MP` = Merge Parent Read only.
Parent Mass Addition ID	The Mass Additions ID of the Parent record. Read only.
Asset Type*	`Capitalized`, `CIP` or `Expensed`.
Cost*	The asset costs of this line.
Date Placed in service*	The date the asset will start depreciating from.
Category*	Select one of the Categories that have been enabled for this Book. If you have multiple Books then it is possible that not all the category combinations are enabled for your Book.
Preparer	Person preparing the asset.
Descriptive Details
Asset Key	The asset key allows you to group assets or identify groups of assets quickly. It does not have financial impact; rather it can be used to track a group of assets in a different way than the asset category.
Units	Number of assets in this record. Must match total assignments.
Tag Number	A Tag Number uniquely identifies each asset. For example, use the tag number to track asset barcodes.
Serial Number	Serial Number of the Asset.
Financial Details
Salvage Values	Enter Type and the relevant Amount or % (e.g. `0.15` = 15%).
Method	The depreciation method you choose determines the way in which Assets spread the cost of the asset over the time it is in use. This will default from the Category if you don’t specify.
Life in Months	Life in years should be converted to months e.g. 1year 6mths would be entered as 18. Only months set up on your system will be listed.
Basic Rate	If the (depreciation) Method Type is Flat, the Basic and Adjusted Rates can be selected and used for depreciation calculations.
Adjusted Rate	As for Basic Rate.
Prorate Convention	Assets use the prorate convention to determine how much depreciation to take in the first and last years of asset life. Will default from Category if not specified.
Transactions
Amortize	Yes/No
Amortize Start Date	Date between DPIS and end of current period.
Transaction Comment	Comment will appear in Transaction Inquiry.
Source Lines
All are read only	Details of the Payables invoice.

Assets Upload Action

This will be Update or Update records.

Mass Additions ID

Should not be updated.

Queue

Typically, your workflow will look like this:

* New (Imported from AP)
* On Hold (If details are missing)
* Post (ready to create asset)
* Posted (Asset created successfully)
* Error (Asset not created and in error)

Merged are child records that have been merged to a parent record within the Mass Additions table. These rows cannot be updated.

Delete (to be deleted).

Book

Should not be updated.

Asset Number

Leave blank if you wish the system to generate or enter a unique number. See notes below.

Description*

Description of an asset. You can use this attribute to describe the asset features, characteristics etc.

Merged Code

MC = Merged Child
MP = Merge Parent
Read only.

Parent Mass Addition ID

The Mass Additions ID of the Parent record.
Read only.

Asset Type*

Capitalized, CIP or Expensed.

Cost*

The asset costs of this line.

Date Placed in service*

The date the asset will start depreciating from.

Category*

Select one of the Categories that have been enabled for this Book. If you have multiple Books then it is possible that not all the category combinations are enabled for your Book.

Preparer

Person preparing the asset.

Descriptive Details

Asset Key

The asset key allows you to group assets or identify groups of assets quickly. It does not have financial impact; rather it can be used to track a group of assets in a different way than the asset category.

Units

Number of assets in this record. Must match total assignments.

Tag Number

A Tag Number uniquely identifies each asset. For example, use the tag number to track asset barcodes.

Serial Number

Serial Number of the Asset.

Financial Details

Salvage Values

Enter Type and the relevant Amount or % (e.g. 0.15 = 15%).

Method

The depreciation method you choose determines the way in which Assets spread the cost of the asset over the time it is in use. This will default from the Category if you don’t specify.

Life in Months

Life in years should be converted to months e.g. 1year 6mths would be entered as 18.
Only months set up on your system will be listed.

Basic Rate

If the (depreciation) Method Type is Flat, the Basic and Adjusted Rates can be selected and used for depreciation calculations.

Adjusted Rate

As for Basic Rate.

Prorate Convention

Assets use the prorate convention to determine how much depreciation to take in the first and last years of asset life. Will default from Category if not specified.

Transactions

Amortize

Yes/No

Amortize Start Date

Date between DPIS and end of current period.

Transaction Comment

Comment will appear in Transaction Inquiry.

Source Lines

All are read only

Details of the Payables invoice.

'*' Is required to change queue to Post.

Asset Number

This is controlled by your configuration and can be either Manual or Automatic. If you have numbering set to automatic, then you will not be able to enter a value in this field. If your configuration is Manual, then you can optionally enter a value. If you leave the field blank then the system will automatically allocate you a number.

If you enter an asset number with mixed cases (e.g. Asset001), Oracle will convert it to all uppercase once created (e.g. ASSET001). Therefore, we recommend entering asset numbers in all capitals.

Defaulting from Category

Many fields will default from the Category, including:

Salvage Value type/Percent/Amount
(Depreciation) Method/Life in Months/Basic Rate/Adjusted Rate
Prorate Conversion and Date

Assignments

Mandatory columns in the Assignments section must be completed to create an asset.

Column Notes

Column	Notes
Units Assigned*	The number of units currently assigned to the distribution. Whole numbers only e.g. `1`.
Employee Name	Employee identification name. Assign assets to the owner or person responsible for that asset. You must enter a valid, current employee.
Employee Number	Employee identification number. Assign assets to the owner or person responsible for that asset. You must enter a valid, current employee.
Expense Account*	The GL account where you wish to charge the depreciation each month. The GL account must be an expense type (i.e. not Revenue or Balance sheet).
Location*	Enter the valid physical location of the assets.

Units Assigned*

The number of units currently assigned to the distribution. Whole numbers only e.g. 1.

Employee Name

Employee identification name. Assign assets to the owner or person responsible for that asset. You must enter a valid, current employee.

Employee Number

Employee identification number. Assign assets to the owner or person responsible for that asset. You must enter a valid, current employee.

Expense Account*

The GL account where you wish to charge the depreciation each month. The GL account must be an expense type (i.e. not Revenue or Balance sheet).

Location*

Enter the valid physical location of the assets.

'*' Is required to change queue to Post.

Please note that you can include multiple records in this section. However, we do not currently support the ability to split these records. For further details, please refer to the Mass Additions Limitations page.

Assets DFFs

Descriptive Flexfields

In the DFF form, the field controls may not represent the Data Type of each DFF Attribute for the chosen Context. They will be presented as shortlist LOVs as shown below.

For DFF Attributes with a Data Type of Free Text, a user can type the required value into the available field.

Refer to the Descriptive Flexfields documentation for more information.