IBM Support

IV84807: BMXAA4129E-THE RECORD FOR SITE=X ALREADY EXISTS WHEN TRYING TO APPROVE TASK WORKORDER THAT HAS INVENTORY USAGE ASSOCIATED

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • Steps to Reproduce
    
    Go to the Organizations application
    Bring up your Org.
    Select Action > Inventory Options> Inventory Defaults.
    Make sure that Automatically create usage documents for new
    reservations? is checked.
    Go the Wotrack application.
    Create a new basic work order.
    Populate the Job Plan with JP11220.
    Save the record.
    Click on the Plans tab and change status on Task 10 to approved.
    Take note of the work order number.
    Go to the Inventory Usage application
    In the description field filter for your work order.
    Bring up your inventory usage record.
    Notice that the inventory usage lines is reading 1,4,6,8 all for
    task 10.
    Go back to Wotrack application
    Bring up your work order.
    Click on the Plans tab > Materials sub tab click new row.
    Add 3 more material line items against Task 20 example
    Task 20, item 6I-2499 from the CENTRAL storeroom. Quantity of 1.
    Task 20, item 6I-2500 from the CENTRAL storeroom. Quantity of 1.
    Task 20, item GLOVES  from Central storeroom Quantity 1.
    Save the record.
    Change status on Task 20 to approved.
    You should be presented with the following popup message
    
    BMXAA4593E - Could not change Activity 1202, task 20 status to
    APPR.
    BMXAA4129E - The record for Site=BEDFORD, Usage=XXXX, Line=8
    already exists.
    
    This validation error is thrown when an attempt is made to
    insert a new record with a unique key value that already exists
    in the database. Ensure that the key value for the given record
    is unique
    
    Yes line 8 already exists as it entered lines 1,4,6,8 when we
    approved task 10.
    

Local fix

  • no work around
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * MAXIMO                                                       *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * BMXAA4129E - THE RECORD FOR SITE=X ALREADY EXISTS WHEN       *
    * TRYING TO APPROVE TASK WORK ORDER THAT HAS INVENTORY USAGE   *
    * ASSOCIATED                                                   *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    

Problem conclusion

  • The fix for this APAR is contained in the following maintenance
    package:
    	 | release\fix pack | Interim Fix for Release 7.6.0.6 Product
    

Temporary fix

Comments

APAR Information

  • APAR number

    IV84807

  • Reported component name

    INVENTORY

  • Reported component ID

    5724R46IN

  • Reported release

    760

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-05-13

  • Closed date

    2016-08-30

  • Last modified date

    2016-08-30

  • 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

    INVENTORY

  • Fixed component ID

    5724R46IN

Applicable component levels

  • R750 PSY

       UP



Document information

More support for: Maximo Asset Management
Inventory

Software version: 760

Reference #: IV84807

Modified date: 30 August 2016