Maximo Open Forum

 View Only

 MatUseTrans import fails with Null pointer value

  • Administration
  • Everything Maximo
  • Infrastructure
  • Inventory
Rob Radcliff's profile image
Rob Radcliff posted 11-09-2023 09:13

Hi,

We're trying to import data into the MatUseTrans table to be used as inventory issued against given WOs. The records are imported into the MIF table fine, but when the queues go to process the data, it fails and gives us an error in Message Reprocessing saying that the import failed because of a Null pointer value.

Any thoughts on what might be causing this? We're thinking that there are some business rules that the queues are using that we can't see but haven't had any luck yet figuring out how to deal with them.

Any thoughts or guidance much appreciated!

Rob

Nidhil Chathoth's profile image
Nidhil Chathoth posted 11-09-2023 19:19

Hi Rob, 

Which Object structure are you using?

I would recommend duplicating the MXAPIWODETAIL object structure and deleting all the objects except the Workorder and matusetrans. You should be able to load fine with the below columns of information.

SITEID
WONUM
MATUSETRANS.ITEMNUM
MATUSETRANS.QUANTITY
MATUSETRANS.TASKID
MATUSETRANS.STORELOC
MATUSETRANS.BINNUM
---------------------------------------------------------------------------
Nidhil Chathoth
ECCS Ltd
Adam Ames's profile image
Adam Ames posted 11-10-2023 08:41

Hi Rob,

I believe you have to use the object MXINVISSUE and like Nidhil mentions I recommend duplicating it and making any necessary modifications you need to the duplicated object. You have to use this object due to the processing class associated to it. I attached a template we use using MxLoader instead of MIF.

Attachment  View in library
Matusetrans Template.xlsx 39 KB
Rob Radcliff's profile image
Rob Radcliff posted 11-30-2023 09:47

Hi Nidhil, Adam,

Thanks for the responses. This was for a small import. After discussing with the business owner, they decided to go ahead and manually enter the data.

I'll file this for future use as I'm sure someone will show up with a larger import and will want this done.

Thanks again!

Rob

Related Content