My Oracle Support Banner

Fusion Global HR: How the Effective Date, Creation Date, Last Update, and System Date (sysdate) Work in Different Time Zones for HCM Extracts when the Universal Time Code (UTC) Is Set (Doc ID 2545915.1)

Last updated on JULY 30, 2020

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.07.0 and later
Oracle Fusion Global Human Resources - Version 11.12.1.0.0 and later
Information in this document applies to any platform.
This note was created for Release 11.13.19.01.0. The note has been reviewed and is current for release 11.13.20.07.0.

Goal

How do Effective Date, Creation Date, Last Update, and System Date (sysdate) work in different time zones for HCM Extracts when the Universal Time Code (UTC) is set?

If data is entered at 5:01 pm PST on a Thursday and the User setting is also PST, will this transaction be selected by HCM Extract using a custom Business Intelligence (BI) data model using a Thursday date selection?

Will the transaction be stored as Friday due to UTC being 12:01 am?

Solution

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
Goal
Solution
References


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