IJ32052: BMXAA1891E IS SHOWN ON IMPORTING WORK ORDER.

APAR status

• Closed as program error.

Error description

• The following error is shown on importing a Work Order record
  through the Enterprise Service.
  
  BMXAA1891E - The available balance
  will become negative as a result of
  this transaction.
  
  STEPS TO RECREATE:
  1) From [Organizations], open EAGLENA.
  Then, from [Select Action]-[Inventory Options]-
  [Inventory Defaults], check the following
  check boxes.
  
  Disallow Negative Balance
  Disallow Negative Available Balance
  
  Log out and log back in to Maximo for the change to
  take effect.
  
  2) From [Item Master] application, create a new
  item as below.
  
  Item : TESTITEM
  Description : TESTITEM
  
  3) From [Select Action]-[Add Items to Storeroom],
  add the item to the storeroom [CENTRAL].
  
  4) On [Add Items to Storeroom] window,
  specify the following values and click OK.
  
  Issue Unit : EACH
  Current Balance : 1
  
  5) Click [Change Status] icon and specify
  the following values on [Change Status] window.
  
  New Status : Active
  Roll New Status to Organizations
  and Inventory : Checked
  
  6) From [Inventory] application, open "TESTITEM" and
  confirm the following values.
  
  Current Balance : 1
  Hard Reserved Quantity Not Staged : 0
  Quantity Available : 1
  
  7) From [Work Order Tracking],
  create a new Work Order with the
  following values.
  
  WONUM : TESTWO
  Description : Test Work Order
  
  8) On [Plans] tab, open [Materials] sub tab and click
  [Select Materials] button to select the Item TESTITEM.
  Then specify the following values.
  
  Quantity : 1
  Storeroom : CENTRAL
  Reservation Type : Automatic
  
  9) Change the status for
  this Work Order to [Approved].
  
  10) From [Inventory] application,
  open the item [TESTITEM] and confirm the
  following values.
  
  Current Balance :1
  Hard Reserved Quantity Not Staged : 1
  Quantity Available : 0
  
  11) From [Object Structures] application,
  open [MXINVISSUE] object structure and check
  [Support Flat Structure?].
  
  12) From [External Systems] application,
  open the external system [EXTSYS1] and select
  [MXINVISSUEInterface] on [Enterprise Services] tab.
  
  13) Click [Data Import] button
  and select the following values.
  
  Flat File : checked
  Import Preview? : checked
  Specify File : TESTWO.TXT
  
  Note the content of TESTWO.TXT is as below.
  
  EXTSYS1,MXINVISSUEInterface,Add,JA
  WONUM,ITEMNUM,LINETYPE,STORELOC,SITEID,QUANTITY,
  UNITCOST,ISSUETYPE,GLDEBITACCT,GLCREDITACCT,SENDERSYSID,
  TESTWO,TESTITEM,ITEM,CENTRAL,BEDFORD,1,0,ISSUE,6600-800-800,
  6210-300-200,MX
  
  14) Then the following error is shown.
  
  BMXAA5598E - Processing of an inbound transaction failed.
  The processing exception is identified in document 1.
  BMXAA1891E - The available balance will become negative as a
  result of this transaction.
  
  EXPECTED RESULTS:
  Actually the quantity available for the item
  TESTITEM is 0 because it is reserved by the
  work order TESTWO. Since TESTWO is specified
  for WONUM in the import file, this MATUSETRANS
  record should be imported without any errors.
  
  PRODUCT VERSION:
  Maximo Asset Management 7.6.0.9
  

Local fix

• The error does not happen if you click [Select Reserved Items]
  from [Issues and Transfers] and select the item reserved by the
  Work Order or if you create a new Inventory Usage record from
  [Inventory Usage] and click [Select Reserved Items] in [Usage
  Lines] section and then select the item reserved by the Work
  Order.
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * BMXAA1891E IS THROWN WHEN ISSUING A RESERVED MATERIAL WITH   *
  * THE ASSOCIATIED WONUM THROUGH MIF USING THE MXINVISSUE OBJ   *
  * STRUCTURE                                                    *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: release\fix pack for Release 7.6.1.3 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:

Fix information

• Fixed component name

  WORK ORDERS

• Fixed component ID

  5724R46WO

Applicable component levels