IV37120: OPEN WO AND PM REPORT SHOWS SAME NEXT DUE DATE FOR ALL SELECTED PMS

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • When running this Open WO and PM report (open_wo_pm.rptdesign)
    for a selection that includes multiple PMs, each reported Next
    Due date will be the same date.
    
    To replicate in demo database:
    
    - Run the OPEN_WO and PM report against asset "TRACK 1", site
    BEDFORD
    
    The report will show 2 PMs - 1017, 1018 and the next due date
    will show as 2011-03-24.  But, for PM 1018 it should be
    2012-12-20.
    
    
    In the clients test, he had 30 PMs and each showed the same Next
    Due Date.
    
    We believe the issue is caused by the use of the sql function
    "over()" in the query.  This was added to the report in 7.1.1.5
    and is still in place as of 7.5.03.
    

Local fix

  • change the query to correctly select records
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Open Wo and PM report users                                  *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Next Due Date replicated for all subreport records           *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Import and use updated report                                *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

  • Import and use updated report
    

APAR Information

  • APAR number

    IV37120

  • Reported component name

    REPORTING

  • Reported component ID

    5724R46RP

  • Reported release

    750

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-02-22

  • Closed date

    2013-03-08

  • Last modified date

    2013-03-08

  • 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

Applicable component levels

  • R750 PSY

       UP



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

IBM Maximo Asset Management
Report Admin

Software version:

750

Reference #:

IV37120

Modified date:

2013-03-08

Translate my page

Machine Translation

Content navigation