Esm_utl.gmt_offset Utility Is Now Returning A Negative Number
(Doc ID 2491403.1)
Last updated on OCTOBER 16, 2020
Applies to:Oracle Argus Safety - Version 8.1.1 and later
Information in this document applies to any platform.
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document