AIW User Guide - Unassigned Asset Lines Loader

Asset Lines User Form

 
The Asset Lines form has two tabs:
 
- Current Line Details shows the current asset line details in a display only format. These values cannot be changed.
 
Current Line Details Tab
 
- Assign Asset where most data entry for the loader is done.
 
 
Asset Line ID – This is a searchable list of values that contains all the unassigned assets based on the project in the header section of the loader.  When assigning assets this field is mandatory for the upload.  It is recommended that the download is used to populate these ID’s correctly the LOV is primarily used for validation.
 
Upload Action – This will either be ASSIGN or SPLIT.  ASSIGN is the default and shows task specific assets and will only allow a complete assignment of the current amount.  SPLIT may also be selected and shows all project related assets and will only allow a new amount less than the current amount.
 
New Asset:
ASSIGN Upload Action:  Assets shown in the list of values will be related directly to the asset line task.
 
 
SPLIT Upload Action: Assets shown will be related to the project.
 
 
This emulates the same functionality for ASSIGN and SPLIT within EBS.
 
New Amount – This is the amount that you will be assigning to the new asset.  If the whole asset is being assigned then leave the total value in this field.  If the asset is being split the amount will need to be changed to reflect the value you require.
 
*New Amount and Percentage fields do not need to both be specified, you can either use one or the other.  If both are used the percentage and the new amount must equate otherwise the validation will fail.
 
Percentage – If assigning the entire line to an asset the percentage should be set to 100.  However if splitting an asset the user will need to enter the percentage they are splitting the asset by.  Please note the percentage must be numeric and cannot be over 100 or less than 0.
 
*New Amount and Percentage fields do not need to both be specified, you can either use one or the other.  If both are used the percentage and the new amount must equate otherwise the validation will fail.
 
Line Description – This is a display only field and is the current description of the asset line that is unassigned.
 
Asset Category – This is a display only field and is derived based on the value chosen in the ‘New Asset’ list of values.
 
Depreciation Amount – This is a display only field usually located in the Oracle EBS forms under Assets > Depreciation tab. It is based off the Depreciation Expense Account field.