IJ32785: RESERVATIONS PROBLEMS WITH GENERATED TRANSACTIONS IN MANAGE INVENTORY WORK CENTER.

APAR status

• Closed as program error.

Error description

• Problem Description
  When Reserved Items are issues through the Reservations tab of
  the "Manage Inventory" Work Center, there are problems with the
  records that are being inserted and/or updated including:
  
  1)  The GLDebitAccount on the MatUseTrans record inserted is
  being set to NULL if the GLAccount on the InvReserve has
  wildcards (e.g. - "?") in any component.  This is a huge problem
  because the Resource component that indicates the type of
  expense is usually not set on a WO's GL Account.
  
  2)  The GLAccount and Location on the MatUseTrans record
  inserted on the WO is being overridden by the GLAccount and
  OpLocation on the InvReserve record although the AssetNum is set
  to the value on the WO regardless of what is on the InvReserve
  record.  The GLAccount and Location from the WO should be used
  as well.  (This is also a problem when issuing from the "Select
  Reserved Items" dialog in the "Issues and Transfers"
  application.)
  
  3)  The WPItemID on the MatUseTrans record inserted is not being
  set to the WPItemID of the WPMaterial that generated the
  InvReserve record.
  
  4)  The ActualQty on the InvReserve record is not being updated
  although the ReservedQty is being decremented by the quantity
  issued.  The ActualQty should be updated as well.
  
  5)  When the remaining ReservedQty is issued, the ReservedQty is
  still being decremented by the quantity issued rather than
  deleting the record.  It is updating the ReservedQty even if the
  resulting value is negative.  There should not be any InvReserve
  records with a ReservedQty <= 0.
  
  STEPS TO REPRODUCE:
  
  1)  Create a new WO in the Bedford Site with Asset set to
  12300, which should set the Location to SHIPPING and the GL
  Account to 6500-300-???, and set the Target Start Date to the
  System Date.
  2)  On the Plans / Materials sub-tab, add 2 rows for a Qty of 5
  from the CENTRAL Storeroom and set the Item to 0-0048 and
  0-0514.
  3)  Approve the WO.
  4)  Change the Asset to 11230 and let the Location and GL
  Account change to BR230 and 6210-327-??? respectively.
  5)  Go to the "Issues and Transfers" application, search for the
  Central Storeroom, click on the "Issues" tab, and then on the
  "Select Reserved Items" dialog.
  6)  Search for the WO# created in Step 1, select the row for
  Item 0-0048, and click "OK".
  7)  Change the Quantity to 3 and SAVE.
  8)  Go to the "Manage Inventory" Work Center.  It should open to
  the "Reservations" tab and you should see the 2 rows for the WO#
  created in Step 1.
  9)  Select the row for Item 0-0514 and click "Issue selected" at
  the top.
  10)  Reduce the "Issue quantity" to 3 and click "Issue".
  11)  In a SQL tool (e.g. - SQLDeveloper), run "SELECT * FROM
  InvReserve WHERE WONum = '<WONumFromStep1>' ;".  You should see
  that both rows show the ReservedQty as "2" but the row for Item
  0-0048 shows "3" for ActualQty while the row for Item 0-0514
  shows "0" for the ActualQty.
  12)  Issue another "3" of Item 0-0048 using the "Select Reserved
  Items" option.
  13)  Issue another "3" of Item 0-0514 using the "Manage
  Inventory" Work Center.
  14)  Repeat Step 11.  You should now see that the row for Item
  0-0048 was deleted but the one from 0-0514 is still there with
  the ReservedQty as "-1".
  15)  In the SQL tool, run "SELECT * FROM MatUseTrans WHERE RefWO
  = '<WONumFromStep1>' ;".  You should see that all 4 rows show
  the AssetNum as "11230" (the Asset on the WO) and the Location
  as "SHIPPING" (the OpLocation on InvReserve) but that the 2 rows
  for Item 0-0514 show no value in the GLDebitAcct while the 2
  rows for Item 0-0048 show the GLDebitAcct as "6210-327-200" (the
  1st 2 components coming from the WO's GLAccount and the 3rd from
  the Inventory record's GLAccount).
  
  If between Step 1 and 2 you had changed the GL Account on the WO
  to specify the 3rd component, you would see that the MatUseTrans
  records for Item 0-0514 showed that value in the GLDebitAcct
  instead of the one showing on the records for Item 0-0048 which
  is the correct one.
  RESULTS:
  
  Negative reservation number and wrong GL account in the
  transaction table.
  
  EXPECTED RESULTS:
  
  User expects to see a positive reservation with the correct GL
  account in the work order record
  
  REPORTED IN VERSION:
  
  Tivoli's process automation engine 7.6.1.1
  IBM Maximo Asset Management Work Centers 7.6.0.4
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * IJ32785 RESERVATIONS PROBLEMS WITH GENERATED TRANSACTIONS IN *
  * MANAGE INVENTORY WORK CENTER.                                *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR will be included in a future release
  

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

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels