[DMOORE]

Hi,

I am working with OTM 5.5 CU02. We are not integrating time zones with in our location integration. According to OTM, when creating a location, if you leave the time zone blank, OTM will auto-populate the time zone based on the location's address (country, state/province, city, postal code).

We are seeing many time zones that are not correct. For example, many of the location in Michigan are being set to America/Chicago. OTM is assigning locations in Ann Arbor with a Central time zone, when they should be Eastern.

Question: Does anyone know of a fix for correcting time zones short of bringing them over through a location integration, or buying time zone data from a third party?

Thanks,
Drew

[AlejandroBarba]

Hi Drew,

Have you submitted a Service Request to Oracle through Metalink for this issue? OTM pulls the Time Zone information from the table TIME_ZONE_LOCALE so according to what you described, it sounds like that table does not have the correct assignments...

Hope this helps,

Alejandro B.

[regera]

Drew,

Whats up buddy long time no talk to.

I have been working on this but have had no luck on reproducing it. Even though I am using the exact same data.

However Oracle did provide a patch for this and has been installed in development.

let me know how I can reproduce this in QA

Reger

[Janice Zarzoza]

We are having the same issue with time zones being incorrect on locations. I submitted a ticket to Oracle support but the response was that it is a bug that was corrected in v5.5. We are currently using v5.0. Does anyone know of a way to work around this in 5.0?

[neoandr]

take a back up of time_zone_locale table and then try to modify country_code3_gid column value according to the time zone.

Hope it will help.