To create a project asset, the 'Assets Upload Action’ column value must be ‘Create’. Refer to the Uploading section for more information on how to upload the Create action.
This section describes some of the fields available in the integrator.
Project Number
A project number is a mandatory field, and it determines the project to which an asset belongs.
Asset Name
An Asset Name is a mandatory field when creating a new asset. It uniquely identifies each asset within a project.
New Asset Name
If you want to update an existing asset with a new name, you must enter the new name in the ‘New Asset Name’ field for the change to be successful. Asset Name is a unique key for the asset. You must use the ‘New Asset Name’ field to update an asset with a new name.
Tag Number
If you enter a tag number, it must be unique. A tag number uniquely identifies each asset. For example, use the tag number to track asset barcodes, if you use them.
These fields allow valid combinations of the relevant Key Flexfields to be selected in Oracle Cloud. Currently, there is no support for lists of values on the KFF fields as the Integrator cannot read the definitions yet. This may change in the future as Oracle add support for this requirement and our products mature. For now, you must enter a valid combination for these fields to create assets successfully. See example below:
Asset Type
Valid asset types are:
● Estimated
● As-Built
If the Asset Type of ‘As-Built’ is selected, the 'Actual In-Service Date’ and 'Actual Units’ fields will become mandatory.
Enter the Asset details manually in the sheet or use the Data Form to enter details:
Default Row
The Default Row can be used to enter values specified in the row to default down the sheet during validation. More information about the Default Row can be found here.
The ‘Accepted’ status for ‘Assets Status’ is returned to the sheet if all the assets are valid and uploaded successfully to Oracle.
