Wrong Timestamp In HCM Extract Output File Name

(Doc ID 2129803.1)

Last updated on APRIL 22, 2016

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.10.0.0 and later
Information in this document applies to any platform.

Goal

On : 11.1.10.0.0 version, Global Human Resources

Wrong timestamp in HCM Extract Output File Name

For a custom HCM Extract, I'm using SFTP delivery option with a text type output using a custom BI Report.

The output file name is defined as: HALOGEN_UPDATES_%y%m%d%H%M%S
The Remote Output File Name is defined as: HALOGEN_UPDATES_%y%m%d%H%M%S.csv

The preferences have been changed in the Application and BI to PST time zone.
The Time Zone is set to Pacific Standard Time (UTC -08:00).

When the extract is run, the output file name generated has UTC timestamp instead of PST.

We need the output file name to have a PST time stamp. Please resolve.

The attached output was generated around 02.10 AM PST. It has timestamp of UTC instead of PST..
 

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