Hi All,
Has anyone found a solution for updating failure hierarchy on work orders that are in CLOSED (CLS) status using MXLoader? The object structure MXWO allows us to null or update the failure code and problem for WORKORDER table as well as FAILUREREPORT table in WCC, DEP, and SKP statuses. We can update the cause and remedy using MHWO on the FAILUREREPORT TABLE on the non-closed workorders. We are not able to use MXWO or MHWO on the failure hierarchy on any of the Closed workorder. We also tried creating a custom object structure MXFAILUREREPORT, directly to the object FAILUREREPORT but without success.
The error we received was:
1) when using MXWO when nulling the failurecode and problem code

2) When using MXFAILUREREPORT to update the problem, cause and remedy
|
BMXAA4534E - The failure report code is not valid.
|

In the front end, we can use the "Edit History Work Order" option under Select Action to temporarily change the work order to a working status, then update the problem, cause, and remedy. However, we have thousands of work orders that need to be updated via MXLoader, and doing this manually is not feasible.
Any ideas or guidance would be greatly appreciated, as our hands are currently tied.
Thank you,
Ethan
------------------------------
Ethan Ho
fort worth water
------------------------------