IBM Support

IJ09656: MISMATCH BETWEEN RECORDS IN INVLIFOFIFOCOST AND ASSET COST AFTER ISSUE USING AUTO SPLIT.

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

  • Mismatch between records in invlifofifocost and asset cost
    after issue using auto split and after manually selecting
    rotating asset for issuing.
    SME Action Taken
    ================
    SME reproduced in latest 7608IFIX
    Steps to reproduce
    ==================
    1. Create an item in Item master application: Item test 3,
    check Rotating ? check box. Order Unit: EACH, Issue Unit: EACH.
    2. Save the item and change status to Active and Roll New
    Status to Organizations and Inventory? yes
    3. Add item to Storeroom: MACHSHOP, Issue Cost Type: FIFO,
    Default Bin: A-090
    4. Go to Assets application and create 3 assets:
    ASSET 1 ITEM TEST 3
    Location MACHSHOP
    Rotating Item: ITEM TEST 3
    Bin: A-090
    Inventory: 1
    5. Save the Asset and change the status to Active
    6. Repeat for the next 2 assets and increment Inventory Cost by
    1 for each asset:
    ASSET 2 ITEM TEST 3
    Location MACHSHOP
    Rotating Item: ITEM TEST 3
    Bin: A-090
    Inventory: 2
    ASSET 3 ITEM TEST 3
    Location MACHSHOP
    Rotating Item: ITEM TEST 3
    Bin: A-090
    Inventory: 3
    7. Go to Inventory Usage application and create a new record:
    1019, From Storeroom: MACHSHOP.
    Usage Lines > New Row:
    Usage Type: Issue
    Line Type: Item
    Item: ITEM TEST 3
    From Bin: A-090
    Location: TRANS40
    Fill in GL Debit Account and Credit Account to resolve the
    warning messages when completing the Inventory Usage record.
    8. Change status to Complete, Press Ok, Press Auto-Split. ASSET
    1 ITEM TEST 3 is automatically selected.
    9. Check Inventory for Item Test 3. We see the first asset was
    correctly removed due to the above action in Inventory Usage
    application.
    10. Go back to Inventory Usage application and create a new
    record: 1020, From Storeroom: MACHSHOP.
    Usage Lines > New Row:
    Usage Type: Issue
    Line Type: Item
    Item: ITEM TEST 3
    From Bin: A-090
    Location: TRANS40
    Fill in GL Debit Account and Credit Account to resolve the
    warning messages when completing the Inventory Usage record.
    10. Change status to Complete, Press Ok, Press New Row in
    Select Rotating Assets1 table and click on the Select value
    icon for Rotating Asset field.
    Select third asset created: ASSET 3 ITEM TEST 3 and press OK.
    11. Check Inventory again for Item Test 3
    - check Inventory LIFO/FIFO Costs section and the Unit cost
    value of 3 shows as was selected when creating Asset 3 Item
    Test 3 above, but it should show 2, as Asset 2 Item Test 3 was
    left.
    - go to Rotating Assets tab and check Associated Assets
    section: Inventory Cost for remaining asset is 2, which is
    correct.
    RESULTS / PROBLEM
    ==================
    Mismatch between records in invlifofifocost and asset after
    issue using auto split and after manually selecting rotating
    asset for issuing.
    Expected Results
    ================
    selecting the 3rd asset in the second Inventory Usage record
    and there is a mismatch between INVLIFOFIFOCOST.UNITCOST and
    ASSET.INVCOST. INVLIFOFIFOCOST.UNITCOST shows 3 which was the
    inventory cost value for the 3rd asset, and the ASSET.INVCOST
    is 2 which is correct, as the 2nd asset is the only one left.
    Both values should be 2.
    Product Version
    ===============
    Tivoli's process automation engine 7.6.0.9 Build 20171127-0100
    DB Build V7609-45
    IBM Maximo Asset Management Work Centers 7.6.0.3 Build
    20171121-0723 DB Build V7603-175
    IBM Maximo Calibration 7.6.0.0 Build 20171127-0100 DB Build
    V7600-06
    Client Customization 7.5.0.0 Build 20140404 DB Build V7505-0
    IBM Maximo Asset Management Scheduler 7.6.7.0 Build
    20171127-0100 DB Build V7670-56
    IBM TPAE Integration Framework 7.6.0.9 Build 20171126-2330 DB
    Build V7609-32
    IBM Maximo Asset Management 7.6.0.9 Build 20171127-0100 DB
    Build V7604-01
    Server OS: Linux 4.4.73-5-default
    Server DB: Oracle 11.2 (Oracle Database 11g Enterprise Edition
    Release 11.2.0.4.0 - 64bit Production With the Partitioning,
    OLAP and Data Mining options)
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * Maximo users who use LIFO/FIFO costing                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * Wrong INVLIFOFIFOCOST records were updated when issuing a    *
    * rotating asset using the Split window in the Inventory Usage *
    * application. The incorrect update occurred when user         *
    * manually entered the specific rotating asset to be issued    *
    * instead of using the Auto Split button.                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

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.6.1.1 Product
    

Temporary fix

Comments

APAR Information

  • APAR number

    IJ09656

  • Reported component name

    INVENTORY

  • Reported component ID

    5724R46IN

  • Reported release

    760

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2018-09-25

  • Closed date

    2018-11-05

  • Last modified date

    2018-11-05

  • 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

    INVENTORY

  • Fixed component ID

    5724R46IN

Applicable component levels

  • R760 PSY

       UP



Document information

More support for: Maximo Asset Management
Inventory

Software version: 760

Reference #: IJ09656

Modified date: 05 November 2018