Load failure codes in Maximo with MxLoader

MxLoader 6.2 was the last version with a built-in support for failure codes data loading. Unfortunately this version does not support REST APIs. This post describes how to load failure codes using MxLoader 8.5 with the latest versions of Maximo (including MAS Manage) that only support REST protocol.

I will use the following small failure class hierarchy C1 as an example.

• CL1 – Failure Class 1
  • P1 – Problem 1
    • C1 – Cause 1
      • R1 – Remedy 1
  • P2 – Problem 2
    • C2 – Cause 2
      • R2 – Remedy 2
      • R3 – Remedy 3

This is how it looks in Maximo.

The first step is to load the descriptions of the class, problems, causes. This can be achieved using the MXL_FAILURECODE object structure.

Now we have to load the failure hierarchy. The standard MXAPIFAILURELIST object structure has a non-persistent attribute PARENTCODE on the FAILURELIST object that can be used for this purpose.

Here is the sequence of loading sheets to load the hierarchy.

You can download the sample MxLoader file from here.

There is only one small draw back I have found. If you launch the same sheet many times you will get duplicates in the failure hierarchy. This is caused by the fact that there is no built-in unique index on the FAILURELIST object. However, if something goes wrong, you can simply delete the entire failure class and start from the beginning.