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 number
IJ46853
Reported component name
MAXIMO ASST MGM
Reported component ID
5724R46AM
Reported release
761
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2023-05-19
Closed date
2023-06-12
Last modified date
2023-06-12
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
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSLKT6","label":"Maximo Asset Management"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"761","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]
Document Information
Modified date:
12 June 2023