AIW User Guide - EAM Work Management Loader

Update Existing Data

 
EAM Work Order Loader gives you the option to update work order details as well as create/update/delete options for the operations, resources or materials.
 
We would suggest that you follow the steps below to update existing records:
 
-       Download your data on the sheet
-       Do the appropriate changes on your dataset
-       Upload your dataset
 
The fields that can update via the Oracle form, are the same fields that can be updated using the loader.  The Wizard does not stop the user editing the non-updatable field value but when the record is uploaded, the API returns the error with a message.  See the example below:
 
 
When deleting an operation, the Operation Transaction Type must be selected to ‘Delete’.  Now, as per the loader structure shown earlier, the Resource and Material Requirement sections are child sections of the operation.  Hence, when the user deletes any operation, the respective Resource and Material records transaction type is also required to be set as ‘Delete’.