Job Console Reports Wrong Start and End Times
(Doc ID 1950735.1)
Last updated on JUNE 25, 2018
Applies to:Hyperion Planning - Version 18.104.22.168.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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!