My Oracle Support Banner

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

Last updated on JUNE 25, 2018

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

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
Symptoms
Changes
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.