IJ46853: DUPLICATE CONDITION CODES BMXAA4129E - RECORD ALREADY EXISTS. ENSURE THAT THE KEY VALUE FOR THE GIVEN RECORD IS UNIQUE

APAR status

• Closed as program error.

Error description

• PROBLEM DETAILS:
  =================
  Maximo displays duplicate condition codes, in Inventory
  Balances.
  The condition codes were created for similar item number, such
  as 8281 and 18281.
  
  It looks like the filtering of condition code, based on the item
  they are used with, is done using "itemnum like" rather than
  "itemnum =".
  This leads to the client seeing several entries of the same
  condition code, without any visual cue of the item that are
  using them.
  If the client selects a condition code that is used by a
  different item then the one they are using in the Inventory
  Balance, they get the
  
  "BMXAA4129E - The record for Item=18281, Storeroom=CENTRAL,
  Bin=, Lot=, Condition Code=NEW, Site=BEDFORD, Item Set=SET1
  already exists.
  
  Ensure that the key value for the given record is unique."
  error.
  
  STEPS TO REPRODUCE:
  ===================
  1. Create new item #8281, in Item Master.
  2. Add three condition codes: New, Rebuilt, Used.
  3. Add the item to the Central storeroom.
  4. Change status to Active and rolled it to organization and
  inventory.
  5. Create another new item #18281.
  6. Add three condition codes: New, Rebuilt, Used.
  7. Add the item to the Central storeroom.
  8. Change status to Active and rolled it to organization and
  inventory.
  9. Navigate to the Inventory application and retrieved item
  #8281.
  10. In the Inventory Balances section add a new row and open the
  Condition Code lookup - Maximo displayed duplicate condition
  codes.
  
  11. Close the Condition Code lookup from Inventory Balances.
  12. Open the Condition Code lookup from the Inventory Costs
  section and add a new row, for the Rebuilt condition code. Fill
  in the value for the condition code,
  
  cost and click the OK button, Maximo threw this error:
  "
  BMXAA4129E - The record for Item=18281, Storeroom=CENTRAL, Bin=,
  Lot=, Condition Code=NEW, Site=BEDFORD, Item Set=SET1 already
  exists. Ensure that the key value for the given record is
  unique.
  "
  
  EXPECTED BEHAVIOUR:
  ====================
  The client should see only one condition code, that corresponds
  to the item they are working with.
  
  REPRODUCED ON:
  ========================
  Maximo 7.6.1.2
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * MAXIMO                                                       *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * DUPLICATE CONDITION CODES BMXAA4129E - RECORD ALREADY        *
  * EXISTS. ENSURE THAT THE KEY VALUE FOR THE GIVEN RECORD IS    *
  * UNIQUE                                                       *
  ****************************************************************
  

Problem conclusion

• The fix for this APAR is contained in the following maintenance
  package: release\fix pack for Release 8.7 Product
  

Temporary fix

Comments

APAR Information

• 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

  MAXIMO ASST MGM

• Fixed component ID

  5724R46AM

Applicable component levels