Esm_utl.gmt_offset Utility Is Now Returning A Negative Number (Doc ID 2491403.1)

Last updated on JULY 13, 2023

Applies to:

Goal

Has recently upgraded Argus Safety from v7.0.4 to v8.1.1.

During testing of v8.1.1, an issue with the auto-population of the Receipt Date and Safety Receipt Date for imported cases was identified.

For cases imported after 10am PDT, the two date fields are being populated with a date one day into the future (i.e., current date/time PDT + 14 hrs).
After a bit of investigation, we believe the gss_util.gmt_offset utility, which returned a positive number in v7.0.4, is now returning a negative number in Argus 8.1.1.

Therefore, the select statement

SELECT to_char(m.date_received - esm_utl.gmt_offset(m.date_received),'DD-MON-YYYY HH:MI') l_interchange_date
FROM messages m, safetyreport s
WHERE s.report_id = :report_id
and s.msg_id = m.msg_id;

...which is include in all of the ICH-ICSR V2.1 Message Templates, is adding 7 hrs to GMT instead of subtracting 7 hrs from GMT to determine PDT.

This not is to confirm our findings are correct, and if so, what is Oracle's recommendation for making a global update to all impacted ICH-ICSR message templates.
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.