Need A Way To Pass Timezone Information When Passing The Start And End Time From DAC To Informatica (Doc ID 2103891.1)

Last updated on JULY 26, 2016

Applies to:

Oracle Health Sciences Clinical Development Analytics - Version 3.0.0 and later
Information in this document applies to any platform.

Goal

Customer have a Siebel application hosted in US, with most of the data being entered/updated from different timezones.

The date value "last updated date" column for these records are stored in the database as without timezone conversion. Siebel works this way and it takes care of the timezone conversion from the application.

When loading data from Siebel to CDA warehouse, some of the records are being filtered due to the presence of date filter for Start and End time in the informatica jobs.

Since DAC doesn't have any mechanism to pass timezone information the date conversion doesn't happen hence the data is being filtered.

Need a way to pass timezone information in the DAC variable that is used to send the Start and End time of the job to Informatica.


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms