IV58676: WORK ORDER DIRECT ISSUE MATERIAL STATUS DISPLAYS WRONG PO-LINE INFORMATION.

APAR status

• Closed as program error.

Error description

• STEPS TO REPRODUCE:
  1. Create a new work order
   2. Add two planned material lines of line type material
   3. Approve work order
   4. Reorder Direct Issue Items and services from Inventory
  application
   5. Select the two lines associated to work order for reorder,
  run the
  reorder
   6. Approve generated PR
   7. In PR application, Select Action -> Create PO
   8. On created PO, specify a vendor and GL debit accounts on PO
  lines
   9. Approve PO
   10. In receiving application, find PO, receive PO line 1, save
  record
   11. In PO application, revise PO, then approve revision without
  changing the PO
   12. In receiving application, find approved PO (rev 1), void
  line 1,
  receive line 2, save
   13. Navigate to work order tracking application, find work
  order
   14. Click Info icon beside "Direct Issue Material Status" field
   Result: Line 1 shows receipts complete. Line 2 shows no
  receipts.
   Expected: Line 1 no receipts complete. Line 2 no receipts.
  
   Note that this doesn't happen on some demo environments but is
  due to
  the the WPMATERIAL.POLINE relationship. This relationship does
  not take
  revisionnum into account. Multiple PO lines are returned by this
  relationship (if multiple revisions exist) so the returned
  poline can't
  be guaranteed to be the correct one (although on many
  environments
  tested on it is happens to be the correct one, in some not).
  
   Current WPMATERIAL.POLINE relationship is:
   ponum in (select ponum from prline where prnum=:pr and
  prlinenum=:prlinenum and siteid=:siteid) and  polinenum in
  (select
  polinenum from prline where prnum=:pr and prlinenum=:prlinenum
  and
  siteid=:siteid) and siteid=:siteid
  
   If the relationship is changed to account for the latest
  revision in
  the same way as the WPMATERIAL.POREV relationship handles it,
  then the
  issue is corrected.
  

Local fix

• Instructions to fix this APAR/PMR -
  1) Go to System Configuration->Platform Configuration->Database
  Configuration.
  2) Find WPMATERIAL object. Click on Relationships tab.
  3) Find Relationship POLINE. Change Where Clause to
  ponum in (select prline.ponum from prline, po where prnum=:pr
  and
  prlinenum=:prlinenum and prline.siteid=:siteid and
  po.ponum=poline.ponum
  and po.revisionnum=poline.revisionnum and
  po.siteid=poline.siteid
  and status in (select value from synonymdomain where
  domainid='POSTATUS'
  and maxvalue in ('WAPPR','APPR','INPRG','CLOSE','HOLD')))
  and polinenum in (select prline.polinenum from prline, po where
  prnum=:pr and prlinenum=:prlinenum and prline.siteid=:siteid and
  po.ponum=poline.ponum and po.revisionnum=poline.revisionnum and
  po.siteid=poline.siteid
  and status in (select value from synonymdomain where
  domainid='POSTATUS'
  and maxvalue in ('WAPPR','APPR','INPRG','CLOSE','HOLD')))
  and siteid=:siteid
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO Work Order Module                                     *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * WORK ORDER DIRECT ISSUE MATERIAL STATUS DISPLAYS WRONG       *
  * PO-LINEINFORMATION.                                          *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Apply Release 7.5.0.7 of Base Servicesor request an interim  *
  * fix                                                          *
  ****************************************************************
  

Problem conclusion

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

Modules/Macros

• MAXIMO
  

Fix information

• Fixed component name

  WORK ORDERS

• Fixed component ID

  5724R46WO

Applicable component levels

• R750 PSY

     UP