IJ33139: MAXIMO 7.6.1.1 - PO AND PR APPLICATIONS ARE NOT DISPLAYING COMMLOG ATTACHMENTS ON "VIEW ATTACHMENTS" DIALOG.

APAR status

• Closed as program error.

Error description

• PROBLEM DESCRIPTION:
  
  Maximo 7.6.1.1 - PO and PR Applications
  Are Not Displaying CommLog Attachments on "View Attachments"
  Dialog.
  APAR IJ28105 was fixed in TPAE 7.6.1.2 IFix 009.  However, the
  PO issue was not fixed correctly.
  
  
  PERFORMANCE ISSUE : NO
  STEPS TO REPRODUCE:
  1) Go to PO or PR app.
  2) Select a PO or PR.
  3) Select "Create
  Communication" from "Select Action" menu.
  4) Fill out the required fields and Subject, attach a file to
  the Communication, and Send.
  5) Return to the main tab.
  
  ERRONEOS BEHAVIOR:
  
  6) Click on "Attachments" link the file just attached to the
  Communication will not apply on the list.
  
  7) Go to Tab Log > Communication log. New attached file is
  listed on Communication log list.
  
  
  
  EXPECTED BEHAVIOR:
  If a CommLog is appearing on the Communication Log sub-tab,
  
  then its attachments should appear in the Attachments list even
  if the CommLog is associated with a prior Revision, including
  all PO revisions.
  
  Workaround:
  To modify the Where Clause
  for the DOCLINKS relationship from the PO objects.
  
  
  On APAR IJ28105 was fixed in TPAE 7.6.1.2 IFix 009. PO issue
  was not fixed as
  
  
  UNION ALL select doclinksid from doclinks where
  
  (ownertable = 'COMMLOG' and ownerid in
  (select commloguid from commlog where ownertable = 'PO' and
  ownerid=:poid))
  
  It's should be:
  
  UNION ALL SELECT DocLinksID FROM DocLinks WHERE
  OwnerTable = 'COMMLOG' and OwnerID IN (SELECT CommLogUID FROM
  CommLog WHERE OwnerTable = 'PO' and OwnerID IN (SELECT POID
  FROM PO WHERE PONum = :PONum and SiteID = :SiteID))
  
  
  
  
  
  ENVIRONMENT:
  
  App Server Weblogic Application Server
  12.2.1.3.0
  
  Version
  
  Tivoli's process automation engine
  7.6.1.1-IFIX20200522-1523 Build 20190514-1348 DB Build
  V7611-365 HFDB Build HF7611-13
  
  IBM Maximo Asset Management
  Work Centers 7.6.0.4 Build $build$ DB Build V7604-119
  
  IBM
  Maximo Asset Management Scheduler 7.6.7.3 Build 20190514-1348
  DB Build V7673-78 HFDB Build HF7673-12
  
  IBM Tpae Integration
  Framework 7.6.1.1-MIF_7611_IFIX.20200504-1653 Build
  20190422-1259 DB Build V7611-01
  
  IBM Maximo for Utilities
  7.6.0.2-20200522-1028 Build 20171128-1353 DB Build V7602-68
  HFDB Build HF7602-13
  
  IBM Maximo Spatial Asset Management
  7.6.0.5-20200525-1808 Build 20190522-1410 DB Build V7605-09
  HFDB Build HF7605-07
  
  IBM Maximo Asset Management 7.6.1.1 Build
  20190514-1348 DB Build V7611-01
  
  IoT Connection Utility 7.6.0.2
  Build 20190426-2206 DB Build V7602-07
  
  Server OS Linux
  3.8.13-118.19.4.el7uek.x86_64
  
  Server DB Oracle 19.0 (Oracle
  Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
  Version 19.7.0.0.0)
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * Maximo users                                                 *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * The PO application does not display COMMLOG attachments for  *
  * prior revisions in the "View Attachments" dialog.            *
  ****************************************************************
  

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

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels