Job Console Reports Wrong Start and End Times

(Doc ID 1950735.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

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.

Changes

Automatic Daylight Savings

Cause

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