IJ09158: REFOBJECT AND REFOBJECTID ARE NULL IN INVLIFOFIFOCOST TABLE WHEN USING MIF TO PERFORM AN INVENTORY ADJUSTMENTS

APAR status

• Closed as program error.

Error description

• When using the Integration Framework (application
  import,rest,etc) to update the current balance of an inventory
  item that has a costtype of FIFO, the REFOBJECT and REFOBJECTID
  attribute values are empty (null) in INVLIFOFIFOCOST
  
  PERFORMANCE ISSUE:
  No
  
  STEPS TO REPRODUCE:
  1. In Maximo, navigate to the Item Master application and
  create a new Item. For example I created item number 11454.
  Set its status to Active
  Add the item to the CENTRAL storeroom in the BEDFORD site.
  In the dialog box presented:
  set the current balance to a value greater than 0 (very
  important in order to replicate this problem)
  order unit to EACH
  issue unit to EACH
  
  2. Navigate to the Inventory application and bring up your new
  item.
  Change the cost type to FIFO by selecting the menu option.
  Change the inventory status to ACTIVE.
  
  3. Use the following xml with the MXINVBALInterface added and
  enabled on an external system:
  <?xml version="1.0" encoding="UTF-8"?>
  <SyncMXINVBAL xmlns="http://www.ibm.com/maximo"
  xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  creationDateTime="2018-07-24T15:00:39-04:00" transLanguage="EN"
  baseLanguage="EN" messageID="4981499.1532458840230221863"
  maximoVersion="7 6 20170418-0100 V7608-61" event="1">
  <MXINVBALSet>
  <INVBALANCES>
  <BINNUM></BINNUM>
  <CONDITIONCODE />
  <COSTDATE>2018-07-24T13:38:00-05:00</COSTDATE>
  <CURBAL changed="1">65.0</CURBAL>
  <EXTERNALREFID />
  <INVBALANCESID></INVBALANCESID>
  <ITEMNUM>11454</ITEMNUM>
  <ITEMSETID>SET1</ITEMSETID>
  <ITEMTYPE>ITEM</ITEMTYPE>
  <LOCATION>CENTRAL</LOCATION>
  <LOTNUM></LOTNUM>
  <ORGID>EAGLENA</ORGID>
  <OWNERSYSID />
  <PHYSCNT>0.0</PHYSCNT>
  <PHYSCNTDATE>1999-01-19T13:38:00-05:00</PHYSCNTDATE>
  <RECONCILED>1</RECONCILED>
  <SENDERSYSID>MX</SENDERSYSID>
  <SITEID>BEDFORD</SITEID>
  <SOURCESYSID />
  <STAGEDCURBAL>0.0</STAGEDCURBAL>
  <STAGINGBIN>0</STAGINGBIN>
  <UNITCOST>1.37</UNITCOST>
  </INVBALANCES>
  </MXINVBALSet>
  </SyncMXINVBAL>
  
  
  RESULTS:
  the REFOBJECT and REFOCJECTID attribute values in the
  INVLIFOFIFOCOST table are empty (null).
  
  EXPECTED RESULT:
  the REFOBJECT and REFOCJECTID values in the INVLIFOFIFOCOST
  table should contain values indicating the referencing object
  that caused the transaction.
  
  PRODUCT VERSION:
  Version Tivoli's process automation engine
  7.6.0.8-IFIX20180327-1241 Build 20170512-0100 DB Build V7608-63
  HFDB Build HF7608-15
  IBM TPAE Integration Framework 7.6.0.8 Build 20170510-2330 DB
  Build V7608-43
  

Local fix

• n/a
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo MIF Users who use MIF to perform Current Balance      *
  * Adjustments                                                  *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * REFOBJECT and REFOBJECTID on the new INVLIFOFIFOCOST records *
  * created via MIF Current Balance Adjustments.  This does not  *
  * happen when user uses                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• This is fixed in code.
  
  The fix for this APAR is contained in the following maintenance
  package:
  	 | release\fix pack | Interim Fix for Release 7.6.1.1 Product
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Modules/Macros

• MAXIMO
  

Fix information

• Fixed component name

  INVENTORY

• Fixed component ID

  5724R46IN

Applicable component levels

• R760 PSY

     UP