The Time Zones application was designed really for the PM generation process where we have a user (IE MAXADMIN) being used to generate work for many different time zones and we only have a partial time field. We don't know if the target start on the PM of 2:00 PM for example was intended by someone to represent Eastern, UTC, Pacific, etc. Without Time Zone Rules, Maximo will use the user's time zone and then store that in the database server time. But this meant that the 2:00 PM for all sites would be stored as 2:00 PM for the user that generated the WO even if it meant that it would show as 8:00 AM for the site and the site wanted it to show as 2:00 PM their time.
KPIs are SQL based so unfortunately the Time Zones application won't help fix KPIs automatically where you may be looking for records created say Monday to Monday for a given site. Each database platform has some functionality to adjust dates between time zones but it's not the easiest thing in the world to do in a generic fashion and the time zones they use won't match what Java uses. For example, on Oracle you can use NEW_TIME(sysdate,'EST','PST') to try and adjust a date/time from Eastern to Pacific. If you had the data stored in time zone rules you could use a subquery to get the target timezone but you'd have to convert it from Java format to the format your database platform needs.
------------------------------
Steven Shull
IBM
------------------------------
Original Message:
Sent: 12-22-2023 11:51
From: Danny Richardson
Subject: Time Zones across multiple Organizations
We are having an issue with our KPIs because of the time zone of the Maximo system vs the time zone where the plants are located.
I'm using this article by EAM360 as a reference https://eam360.com/playing-with-time-zone-new-application-in-IBM-maximo.
My question would be, if I associate the Time Zones to the correct time zone where each plant is located, will that change affect the KPI currently set up and what day/times it is looking for?
Thank you
#Administration
#EverythingMaximo
#Scheduling
#WorkManagement
------------------------------
Danny Richardson
Technimark LLC
Maintenance Administration Facilities
------------------------------