IV07102: MATRECTRANS FROMSITE APPEARS TO BE INCORRECT

APAR status

• Closed as program error.

Error description

• Created issue Per Tom R.
  
  
  
  
  During testing there was a new issue found regarding the
  fromsite. W
  an Asset is created into a Storeroom a Matrectrans record is
  created
  The matrectrans from site appears to be incorrect below are the
  step
  to reproduce the problem.
  
  1) Create a Rotating Asset in Operating Location.
  2) Create an Inventory Shell in a Storeroom in a different site.
  3) Move the Rotating Asset to Storeroom Location in a different
  site
  4) Issue the Asset to an Operating Location in that Site.
  5) Move the Rotating Asset back to the Operating Location in the
  original Site.
  6) Run the below SQL replacing 'hilltest4' with your Asset
  number.
  
  |--------------------------------|
  |select at.matrectransid         |
  |, at.assetnum                   |
  |, at.transtype                  |
  |'assettrans.transtype'          |
  |, at.siteid 'assettrans.siteid' |
  |, mrt.fromsiteid                |
  |'mrt.fromsiteid'                |
  |, at.tositeid                   |
  |'assettrans.tositeid'           |
  |, mrt.siteid 'mrt.siteid'       |
  |from assettrans at inner join   |
  |matrectrans mrt                 |
  |on at.matrectransid =           |
  |mrt.matrectransid               |
  |where at.assetnum = 'hilltest4' |
  |order by at.datemoved           |
  |--------------------------------|
  
  7) Look at the field matrectrans from site this is incorrect.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED: maximo                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION: MATRECTRANS FROMSITE APPEARS TO BE      *
  *                      INCORRECT - IT SHOULD BE THE ORIGINAL   *
  *                      SITE OF THE ASSET BEFORE MOVE           *
  *                                                              *
  ****************************************************************
  * RECOMMENDATION:                                              *
  *                                                              *
  *                                                              *
  *                                                              *
  ****************************************************************
  MATRECTRANS FROMSITE APPEARS TO BE INCORRECT - IT SHOULD BE THE
  ORIGINAL SITE OF THE ASSET BEFORE MOVE
  

Problem conclusion

• <This is fixed in code. MatRECTRANS.fromsiteid should be the
  original site of the asset before the asset was moved to a
  storeroom in a different site. >
  
  
  
  
  
  The fix for this APAR is contained in the following maintenance
  package:
  
    | release\fix pack | REL 7.1.1.10 - BS
  

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

• R711 PSY

     UP