MxLoader

Hi All,

Has anyone found a solution for updating failure codes 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 work orders in WCC, DEP, and SKP statuses, but not for those in CLS status. We also tried using MXFAILUREREPORT and MHWO with no success. The error we received was:

BMXAA7094E - The entered value null is not valid. Enter a valid integer value

In the front end, we are able to use the "Edit History Work Order" option under Select Action to 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 using 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 

If you try to do it in your environment, do you get an error that the field is read-only (historical flag = 1) when you try to manipulate the field? I wouldn't expect it to work in MxLoader if you can't do it in Maximo.

As a one time, I would try - going to MXWO object structure > Select Action > Inbound Settings Restriction - then check on Override for  WORKORDER.FAILURECODE. Try it on one record in test to see if it works. Then if it works, do your batch processing, then check it off. Or duplicate a different object structure for this specific task. (I haven't tested so I don't know if it'll work).