IV37681: INCORRECT REORDER SUGGESTION IN TPAE 7.5.0.3 AND 7.5.0.4

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

APAR status

  • Closed as program error.

Error description

  • Incorrect reorder suggestion
    
    Maximo 7.5.0.3 with Maxdemo database
    Websphere 7
    Oracle 11g2
    
    
    Description:
    
    We experience errors (two) when selecting reserved items in
    "Inventory
    Usage"-application. See attached file for details.
    Regards!
    
    
    Testing:
    
    To create this example, we need to find an Inventory item with
    inventory.internal = 1
    I?ve used:
    Item: 560-00
    Storeroom : GARAGE
    Site: BEDFORD
    Reorder information:
    Internal: Yes
    Storeroom: CENTRAL
    Storeroom Site: BEDFORD
    Create Purchase Order
    Go to ?Purchasing? ? ?Purchase Orders
    Create a new puchase order
    Got ponum= 1094 in this example
    Set ?Internal?? = Y (Check box)
    Set ?Storeroom? CENTRAL
    Go to tab ?PO Lines?
    Click ?New Row? button
    Set ?Item? = 560-00
    Set ?Storeroom? = GARAGE
    Set ?Quantity? = 4
    Click ?Save? button
    Change status to Approved
    Inventory Usage ? Part 1
    Go to ?Inventory? ? ?Inventory Usage?
    Create new inventory usage
    Got Usage = 1013 in this example
    Set ?From Storeroom? CENTRAL
    Click ?Save? button
    Check current reservation:
    Select Action ? ?Add/Modify Reservations
    Find reservation on ?Purchase Order?= 1094
    Reserved Quantity: 4
    Actual Quantity: 0
    Click ?Cancel? button
    Click ?Select Reserved Items?
    Click ?Filter? button to enable search fields
    Find reservation on ?Purchase Order?= 1094
    Select the row and click ?OK? button
    Change Quantity = 1
    Click ?Save? button
    Change status to Shipped
    Click ?OK? button on ?Create Shipment? dialog
    Shipment Receiving ? Part 1
    Go to ?Inventory? ? ?Shipment Receiving
    Find the the shipment that was created in previous step.
    Got Shipment = 1004 in this example
    Click ?Select Shipped Items? button
    Select the row and click ?OK? button
    Click ?Save? button
    
    Inventory Usage ? Part 2
    Go to ?Inventory? ? ?Inventory Usage
    Create new inventory usage
    Got Usage = 1014 in this example
    Set ?From Storeroom? = CENTRAL
    Click ?Save? button
    Check current reservation:
    Select Action ? ?Add/Modify Reservations
    Find reservation on ?Purchase Order?= 1094
    Reserved Quantity: 3
    Actual Quantity: 1
    As we can see the reserved quantity has been recalculated to
    show the
    remaining reservation and Actual quantity shows how much have
    been
    shipped.
    Click ?Cancel? button
    Click ?Select Reserved Items
    Click ?Filter? button to enable search fields
    Find reservation on ?Purchase Order?= 1094
    As we can see, remaining reserved quantity is 3.
    Select the row and click ?OK? button
    Look at the proposed quantity. It?s 2 and not 3 as in the last
    dialog.
    This is an issue, but there?s a bigger issue still to come. We
    still
    need to do one more shipment to see that one
    Change Quantity = 1
    Click ?Save? button
    Change status to Shipped
    Click ?OK? button on ?Create Shipment? dialog
    
    Shipment Receiving ? Part 2
    Go to ?Inventory? ? ?Shipment Receiving
    Find the the shipment that was created in previous step.
    Got Shipment = 1005 in this example
    Click ?Select Shipped Items? button
    Select the row and click ?OK? button
    Click ?Save? button
    We have now shipped 2 of the 4 reserved items.
    Inventory Usage ? Part 3 ? Issue #2
    Go to ?Inventory? ? ?Inventory Usage
    Create new inventory usage
    Got Usage = 1015 in this example
    Set ?From Storeroom? = CENTRAL
    Click ?Save? button
    Check current reservation:
    Select Action ? ?Add/Modify Reservations
    Find reservation on ?Purchase Order?= 1094
    Reserved Quantity: 2
    Actual Quantity: 2
    This information is correct.
    Click ?Cancel? button
    Click ?Select Reserved Items
    Click ?Filter? button to enable search fields
    Find reservation on ?Purchase Order?= 1094
    Where did the reservation go?
    We still have 2 in reserved quantity on the purcase order.
    
    Cause and Impact
    I logged out the sql and found out that Maximo uses following
    condition
    in the where clause :
    (reservedqty - pendingqty - stagedqty - shippedqty > 0)
    Therefore as soon as reserved quanitity is less than or equal to
    shipped
    quantity the reservation is not shown. This is a bigger issue
    than the
    incorrect proposed quantity seen earlier.
    This caues puchase order to not be completely received since
    users can?t
    find the reservations.
    
    Screenshots:
    https://ecurep.mainz.de.ibm.com:/rest/download/46942,130,846/0-a
    ll_data/46942.130.846.Two_issues_with_function_Select_Reserved_I
    tems_in_Inventory_Usage_.pdf
    
    ACTION TAKEN :
    
    - Replicated in Standard 7503 and 7504.
    Note from core Maximo L3:
    ===
    This seems like a bug. Create an apar for it.
    ===
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * MAXIMO                                                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * INCORRECT Inventory Reservation SUGGESTION IN 7.5.0.4        *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * This is fixed in code. Please upgrade to Release 7.5.0.5.    *
    ****************************************************************
    

Problem conclusion

  • This is fixed in code. The fix for this APAR is contained in the
    following maintenance package:
         | release\fix pack | Interim Fix for Release 7.5.0.5
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV37681

  • Reported component name

    ASSETS

  • Reported component ID

    5724R46AS

  • Reported release

    750

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2013-03-07

  • Closed date

    2013-03-29

  • Last modified date

    2013-03-29

  • 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

    ASSETS

  • Fixed component ID

    5724R46AS

Applicable component levels

  • R750 PSY

       UP



Rate this page:

(0 users)Average rating

Document information


More support for:

IBM Maximo Asset Management
Assets

Software version:

750

Reference #:

IV37681

Modified date:

2013-03-29

Translate my page

Machine Translation

Content navigation