APAR status
Closed as program error.
Error description
The Required Date value in Create Pick List dialog in the 'Manage Inventory' work center, has its DD and MM (Day and Month) values swapped. This issue occurs with a non-American date format in Locale. The non-American Date format DD-MM-YYYY is changed to the American Date format MM-DD-YYYY, which is the actual issue here. - If the chosen DD value is in the 1-12 range, you might not be aware immediately of this swap of the DD and MM (day and month) values. - But if the chosen DD value is in the 13-31 range, ie. if you have a Day value above 12, that value is being assigned to the MM value, and the BMXAA4144E - The date/time format is not valid" error therefore comes up because any 13-31 value cannot be a Month value (only 1-12 allowed). STEPS TO REPRODUCE: Do first test when Required Date value has a DD value in the 1-12 range. * Log on to Maximo. * In Profile/Default Information, set Locale = en_AU (for Australia) * Go to Inventory application and select Add/Modify Reservations * Add a new reservation (eg, for Item FLT221-A, From Storeroom CENTRAL, Qty 3, Requested Date = April 5, Required Date = April 10. * These dates show as Requested Date = 5/04/23, Required Date = 10/04/23 in the Australian Date format. * From Work Order field, hyperlink to Work Order Tracking, select a WO in APPR status and Return with value. * Click OK in Add/Modify Reservations dialog. * Go to Manage inventory work center. * Set filter Dates on the Reservations tab: From = April 1, To = April 30 * The reservation made in Inventory is showing in the list. * Check the box for this reservation and click Create Picks option * You get the Create Pick List dialog: it shows Required Date = 10/04/23 * Enter a description PickList #1 and then click on Pick List. * NO error comes up. * Go to Pick and Stage tab and enter same date range: From = April 1, To = April 30 and refresh list. * The new Pick List does not show. * This is because the Required Date date has had its DD and MM values swapped. * For example, the new date of April 10, 2023 (10/04/2023 in Australia date format) was actually changed to October 4, 2023 = 4/10/2023 in Australia date format ( DD and MM have been swapped). * Change the date range so that it includes that wrong date, for example: From = March 1, To = December 31. * This time, the Pick List value shows in the Pick and Stage tab. * You can see the Required Date field is incorrect: it shows 4/10/2023 in Australia date format. * The DD and MM values have therefore been swapped. Do a second test, this time with a Required Date value where the DD value is in the 13-31 range instead. * Go to Inventory application and select Add/Modify Reservations * Add a new reservation (eg, for Item FLT221-A, From Storeroom CENTRAL, Qty 3, Requested Date = March 22, Required Date = March 27. * From Work Order field, hyperlink to Work Order Tracking, select a WO in APPR status and Return with value. * Click OK in Add/Modify Reservations dialog. * Go to Manage inventory work center. * Set filter Dates on the Reservations tab: From = March 1, To = March 31 * The reservation made in Inventory is showing in the list. * Check the box for this reservation and click Create Picks option * You get the Create Pick List dialog. * Enter a description PickList #1 and then click on Pick List. * The following error comes up this time: [ BMXAA4144E - The date/time format is not valid. Make sure the date/time is specified in a valid format supported by the current locale setting. For input string: "Inv" ] RESULTS: The BMXAA4144E - The date/time format is not valid" error actually only occurs when Requested Date and/or Required Date values have a DD value above 12 (therefore between 13 and 31 of the month). it is actually just a symptom what is happening: the Requested Date and/or Required Date field have the DD (day) and MM (month) values swapped. Locale = en_AU (Australia) has Date format DD-MM-YYYY and this Date format DD-MM-YYYY is being changed to the American Date format MM-DD-YYYY, which is the actual issue here. As a consequence, if you have a Day value above 12, that value is being assigned to the MM value, and the BMXAA4144E - The date/time format is not valid" error therefore comes up because any 13-31 value cannot be a month value (only 1-12 allowed). EXPECTED RESULTS: The value of the Required Date field in Create Pick List dialog in the 'Manage Inventory' work center should not be modified, regardless of the Locale being used. REPORTED IN VERSION: Maximo TPAE 7.6.1.3
Local fix
N/A
Problem summary
**************************************************************** * PROBLEM DESCRIPTION: * * REQUIRED DATE FIELD'S DD AND MM VALUES ARE SWAPPED IN * * 'CREATE PICK LIST' DIALOG IN 'MANAGE INVENTORY' WORK CENTER * ****************************************************************
Problem conclusion
The fix for this APAR will be included in a future release
Temporary fix
Comments
APAR Information
APAR number
IJ46154
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-03-26
Closed date
2023-04-04
Last modified date
2023-04-04
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:
05 April 2023