OBIA : Please Clarify The Behavior Of LAST_EXTRACT_DATE When Having Sources In Different Timezones
Last updated on APRIL 26, 2018
Applies to:Business Intelligence Applications Consumer - Version 126.96.36.199.1 and later
Information in this document applies to any platform.
User has two sources, both EBS 12.1.3. One source is in the EST timezone and the other is in GMT. The DW database is also in GMT.
How LAST_EXTRACT_DATE works in this scenario. The date in ETL_LOAD_DATES is a DATE field and does not contain timezone information, and neither is the LAST_UPDATE_DATE column in EBS.
For example, if we run our first load at 6:00 AM EST from source 1, which is 11:00 AM GMT (on the target DB), will the LAST_EXTRACT_DATE in the next load use 6:00 AM, or 11:00 AM?
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