IV86143: TOTAL COST (MR.TOTALCOST) CHANGES TO 0 WHEN AN ATTACHMENT IS MADE TO THE DESKTOP REQUISITION LINE ITEM

APAR status

• Closed as program error.

Error description

• The value in Total Cost: MR.TOTALCOST changes to 0 when an
  attachment is made to the Desktop Requisition Line Item.
  
  PROBLEM DESCRIPTION
  Creating a Desktop Requisition calculates the Total cost of all
  included Items in the Line Items.  However, when an attachment
  is included in the Line Item, the Total value changes to 0.
  
  STEPS TO REPRODUCE
  1.  GoTo-> Self Service -> Desktop Requisition-> Create
  Requisition
      Requisition:  1016, gL Debit Account:6000-200-000 ->
  Continue button
  2.  Requisition Line Items -> New Row
      Line 1, Qty 1, Item 11R22.5X-10, Unit Cst: 20, Ordr Unt:Each
      Line 2, Qty 2, Item  MCV-60, Unit Cost: 876, Order Unit Each
      Line 3, Qty 3, Item HPLASER, Unit Cost: 30, Order Unit Each
      Line 4, Qty 4, Item 013, Unit Cost 40, Order Unit: Each
  
  I can see the Total Cost of sum of 2,052.00 in this case.
  
  3. Back -> Open drop down for Line 4,
     Select Attachments icon, Add New Attachments, Add New File ->
               include a file (txt, doc, etc)
               Note: Field is DOCLINKS.DOCUMENT
               Continue
  
  The Total Cost is now 0 value, like the customer.
  
  CURRENT ERROUNEOUS RESULT:
  The value in Total Cost: MR.TOTALCOST changes to 0 or depending
  on the items to a different amount
  
  EXPECTED RESULT:
  The value in Total Cost: MR.TOTALCOST should be the sum of the
  Line Items and should not alter because of attachment.
  
  CUSTOMER ENVIRONMENT (SYSTEM INFO):
  IBM Maximo Asset Management 7.5.0.9 Build 201510092235
  TPAE 7.5.0.9 Build 20151009-1735
  IBM Maximo Asset Management Scheduler 7.5.2.0 Build
  20151009-1735
  IBM TPAE Integration Framework 7.5.1.4 Build 20150920-1700
  
  STACK TRACE IN THE LOG
  [6/21/16 5:13:24:305 EDT] 00000815 SystemOut     O 21 Jun 2016
  05:13:24:305 [INFO] [MXServer] [] BMXAA6719I - USER =
  (MAXADMIN) SPID = (9.2.3.4.123456) app (null) object (ITEM) :
  select * from item  where (itemsetid= 'SET1'  and itemtype in
  (select value from synonymdomain where domainid='ITEMTYPE' and
  maxvalue= 'ITEM' ) and status in ( 'ACTIVE' ,  'PLANNING' ,
  'PENDOBS' )) and ((itemnum like 'HPLASER%')) fetch first 1000
  rows only for read only
  [6/21/16 5:13:24:321 EDT] 00000815 SystemOut     O 21 Jun 2016
  05:13:24:321 [INFO] [MXServer] [] BMXAA6719I - USER =
  (MAXADMIN) SPID = (9.12.3.4.633.123456) app (null) object
  (ITEM) : select * from item  where (itemnum =  'HPLASER'  )
  and ( itemsetid= 'SET1'  and itemtype in (select value from
  synonymdomain where domainid='ITEMTYPE' and maxvalue= 'ITEM' )
  and status in ( 'ACTIVE' ,  'PLANNING' ,  'PENDOBS' ) and
  itemsetid =  'SET1'  ) fetch first 1000 rows only for read only
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * MR TOTALCOST REDUCED WHEN AN ATTACHMENT IS MADE TO THE       *
  * DESKTOP REQUISITION LINE ITEM                                *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package:
  		 | Release 7.5.0.11 of Base Services
  

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

  PURCHASING

• Fixed component ID

  5724R46PU

Applicable component levels

• R750 PSY

     UP