My Oracle Support Banner

Job Console Reports Wrong Start and End Times (Doc ID 1950735.1)

Last updated on APRIL 01, 2019

Applies to:

Hyperion Planning - Version and later
Information in this document applies to any platform.


Hyperion Planning is installed on a Windows 2008 R2 server.
Although system date and timezone (TZ) and database sysdate and TZ are correct:


when running Business Rules, the Job Console reports the wrong Start and End times.

Querying the HSP_JOB_STATUS table in the Planning application, confirms the table is populated with incorrect timestamps

Querying the time of updates to the table itself: 'select scn_to_timestamp (ora_rowscn) from hsp_job_status;' 

proves the database is picking up the correct time, but Planning is updating the table with the incorrect time.


Automatic Daylight Savings


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

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