IV39590: IMPORTING PO ALLOWS TO UPLOAD A QUANTITY OF 0.

APAR status

• Closed as program error.

Error description

• The PO upload file allows you to upload a quantity of 0.
  It also puts the unit cost into the line cost fields which
  is then an incorrect calculation of
  Quantity * Unit Cost = Line Cost.
  You can then also approve that purchase order without any
  errors.
  
  STEPS TO RECREATE:
  I am able to recreate the problem with the following steps
  in L2 TPAE 7.5.0.3 test environment.
  
  1) From "Go To"-"Integration"-"Publish Channels",
  create a new Publish Channel with the following values.
  
  Publish Channel  : PMR47061
  Description      : PMR47061
  Object Structure : MXPO
  
  2) From "Go To"-"Integration"-"Enterprise Services",
  create a new Enterprise Service with the following values.
  
  Enterprise Service : PMR47061
  Description        : PMR47061
  Object Structure   : MXPO
  
  3) From "Go To"-"Integration"-"External System",
  create a new External System with the following values.
  
  System : PMR47061
  Description : PMR47061
  End Point   : MXFLATFILE
  Enabled     : checked
  
  Outbound Sequential Queue : jms/maximo/int/queues/sqout
  Inbound Sequential Queue  : jms/maximo/int/queues/sqin
  Inbound Continuous Queue  : jms/maximo/int/queues/cqin
  
  4) Moving to "Publish Channels" tab, click "New Row"
  button and add the Publish Channel "PMR47061".
  
  5) Moving to "Enterprise Services" tab, click "New Row"
  button and add the Enterprise Service "PMR47061". Then
  save the record.
  
  6) From "Go To"-"Purchasing"-"Purchase Order",
  create a new PO with the following values.
  
  PO          : 1096
  Description : Test PO for PMR 47061
  
  7) Moving to "PO Lines" tab, click "New Row" and add
  the following line.
  
  Line : 1
  Line Type : Service
  Description : Test Line for PMR 47061
  Quantity    : 2.00
  Order Unit  : EACH
  Unit Cost   : 3.92
  
  Then save the record.
  
  8) From "Go To"-"Integration"-"External System",
  open the External System "PMR47061". On "Publish Channels"
  tab, click "Data Export".
  
  9) On "Data Export" button, specify the following value in
  "Export Condition" field and click OK.
  
  PONUM = '1096'
  
  10) Open the exported file and change the value for
  ORDERQTY from 2.0 to 0.0. Then save the file.
  
  11) From "Go To"-"Integration"-"External System",
  open the External System "PMR47061". On "Enterprise
  Service" tab, click "Data Import".
  
  12) On "Data Import" window, select "Flat File" and
  specify the full path of the file which is modified
  in the step 10). Then click OK.
  
  13) Verify the following message.
  
  BMXAA5622I - Inbound transaction has been processed
  successfully to queue.
  
  14) From "Go To"-"Purchasing"-"Purchase Orders", open
  the PO 1096 and move to "PO Lines" tab. Then you can
  see the value in "Quantity" field for the PO line has
  been changed from 2.0 to 0.0.
  
  The customer insists this should be a bug because MIF
  should not allow loading of a 0 quantity.
  
  It also puts the unit cost into the line cost fields
  which is then an incorrect calculation of
  Quantity * Unit Cost = Line Cost.
  You can then also approve that purchase order
  without any errors.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo users                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * PO lines with a quantity of 0 can be imported via            *
  * integration.                                                 *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply latest fix pack.                                       *
  ****************************************************************
  PO lines with a quantity of 0 can be imported via integration.
  If quantity is 0, it should be set to 1 as occurs when
  attempting to provide a quantity of 0 in the UI.
  

Problem conclusion

• If quantity is 0, it will be set to 1 as occurs when attempting
  to provide a quantity of 0 in the UI.
  
  The fix for this APAR is contained in the following maintenance
  package:
  	 | release\fix pack | Interim Fix for Release 7.5.0.5 - 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

  INTEGRATION

• Fixed component ID

  5724R46I1

Applicable component levels

• R750 PSY

     UP