Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Getting local timezone information in Mapper — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Getting local timezone information in Mapper

Received Response
8
Views
2
Comments
edited Mar 24, 2020 5:55PM in Integration 2 comments

Summary

Need local timezone information in Mapper

Content

I am building a scheduled integration to move data from one application to another. The integration needs to run twice a day - 6 AM and 6 PM, local time of the plant, which is based in Indiana.

Since they observe daylight savings time, 6 AM and 6 PM aren't always the same values relative to UTC. I've changed the time zone of the integration (based on this post https://blogs.oracle.com/integration/timezone-functionality-in-oic-schedules), but the XSL dateTime functions in the mapper still return all dates in UTC time.

Is it possible to change the value returned by the implicit-timezone function to return the proper offset: -5 for Standard Time and -4 for Daylight Savings Time? I need to know during the integration execution what the local time is, and what the current offset is.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!