IBM Support

IV95957: SUGGESTED REORDER BIRT REPORT GIVES INCORRECT REORDER ITEMOUTPUT

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as fixed if next.

Error description

  • When running the "Suggested Reorder" report, the
    expected results do not return.
    Run the report using "Reorder Report" button on
    "Reorder Item Details" screen you can't see the same Items
    exist on Details screen.
    ENVIRONMENT:
    Tivoli's process automation engine 7.6.0.5-IFIX20160714-2200
    Build 20160611-0100 DB Build V7605-45 HFDB Build HF7605-02
    IBM TPAE Integration
    Framework7.6.0.5-MIF_7605_IFIX.20160714-2314
    Build 20160610-2330 DB Build V7605-50 HFDB Build HF7605-03
    IBM Maximo Health, Safety and Environment Manager 7.6.0.0 Build
    20151124-1800 DB Build V7600-01
    IBM Maximo Asset Management Scheduler 7.6.3.0 Build
    20160611-0100 DB Build V7630-25
    IBM Maximo Spatial Asset Management 7.6.0.0-20160705-0218 Build
    20160318-0236 DB Build V7600-61 HFDB Build HF7600-10
    IBM Maximo Asset Management Work Centers
    7.6.0.0-WC_7600_IFIX.20160719-1304 Build 20160704-0658 DB Build
    V7600-38 HFDB Build HF7600-17
    IBM Maximo Asset Management 7.6.0.5 Build 20160611-0100 DB
    Build V7604-01
    App Server IBM WebSphere Application Server 8.5.5.9
    Server DB Oracle 11.2 (Oracle Database 11g Enterprise Edition
    Release 11.2.0.4.0 - 64bit Production With the Partitioning,
    OLAP, Data Mining and Real Application Testing options)
    Server OS AIX 7.1
    PERFORMANCE ISSUE:
    SECURITY IMPACT: no
    STEPS TO REPRODUCE:
    1. Log in with maxadmin
    2. Go to Inventory application
    3. Filter the List for :
    Site: Bedford
    Storeroom: PKG
    Click OK on the system message:
    BMXAA2185W - This action affects all 21 records in this result
    set....
    4. Go to Reorder from More Actions
    5. Select tick on 'Ignore Reorder Point?' to enable it
    6. Untick 'Run in Background Mode?' & Click Preview button
    Please Wait... dialog window appears, followed by Reorder Items
    Detail
    screen window showing 1 - 16
    Item records.
    A system message may pop up, just OK it:
    BMXAA2120E - Item 39882 is in PENDOBS status. Reorder is not
    allowed.
    More information
    7. Click the Reorder Report button
    A new browser window opens displaying the Suggested Reorder
    report on
    one page with two items:
    1.
    Item: 10112
    Storeroom: PKG
    Description: Fire Extinguisher Fluid- Ansulex
    Current Balance: 12
    Reserved Quantity: 10
    On Order Qty: 0
    Economic Order Qty: 5
    Reorder Qty: 5
    2.
    Item: 10112
    (rest of information is same as item 1)
    CURRENT ERRONEOUS RESULT:
    Report output is not accurate, it only lists 2 reorder items
    EXPECTED RESULT:
    It should of listed 15 records.
    ADDITIONAL INFO:
    If you not enable 'Ignore Reorder Point?' and have actual
    reorder items listed, the issue is still reproducible.
    

Local fix

  • Dev to provide fix
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Maximo Inventory Reorder Report users                        *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Incorrect reodrer item output displayed on the report due to *
    * invalid attribute used in query.                             *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * import latest rptdesign file                                 *
    ****************************************************************
    

Problem conclusion

Temporary fix

Comments

APAR Information

  • APAR number

    IV95957

  • Reported component name

    BIRT INTEG-REPO

  • Reported component ID

    5724R46B1

  • Reported release

    760

  • Status

    CLOSED FIN

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2017-05-08

  • Closed date

    2017-05-17

  • Last modified date

    2017-05-17

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

Applicable component levels

  • R760 PSY

       UP



Document information

More support for: Maximo Asset Management
BIRT

Software version: 7.6

Reference #: IV95957

Modified date: 17 May 2017