Job Console Reports Wrong Start and End Times
Last updated on MARCH 08, 2017
Applies to:Hyperion Planning - Version 126.96.36.199.000 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
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