Jobs Submitted In Application Not Getting Executed On Proper Scheduled Time (Doc ID 1517898.1)

Last updated on OCTOBER 27, 2022

Applies to:

Symptoms

This note affects only users running Siebel on Oracle RAC cluster using TAF (Transparent Application Failover)

Customer was in Hong Kong (GMT+8) and using application in same timezone, so submitting RCR requests by ‘SADMIN’, user preferences for SADMIN already has Hong Kong timezone.
Customer was having database in GMT timezone.

Issue was, jobs were not running as per scheduled time mentioned in application, issue was ‘SCHED_START_DT’ from 'S_SRM_REQUEST' always shows HK timing instead of GMT timing.

-----------------------------------------------------------------------------------------
Here are two records on S_SRM_REQUEST just for example:

SELECT row_id, TO_CHAR(created,'YYYY-MM-DD HH24:MI:SS'), TO_CHAR(sched_start_dt,'YYYY-MM-DD HH24:MI:SS') FROM SIEBEL.S_SRM_REQUEST WHERE ROW_ID = '1-1SF2ESY' or row_id = '1-1RPSLXY'

1-1SF2ESY 2012-09-27 01:14:30 2012-09-27 07:00:00
1-1RPSLXY 2012-09-27 10:44:39 2012-09-28 03:00:00

For component request with row_id "1-1SF2ESY", the campaign launch schedule was submitted on Sep 27 14:30am (HK time).  It was scheduled to run at Sep 27 3:00:00pm (hk time).  
This component request was found to run almost immediately after submission.  It does not wait til Sep 27 3:00:00pm (hk time).

For component request with row_id "1-1RPSLXY", the campaign launch schedule was submitted on Sep 27 6:44:39pm (hk time).  It was scheduled to run at Sep 28 11:00:00am (hk time).  
This component request was found to run around Sep 28 3:00:00am (hk time) instead of 11am
-----------------------------------------------------------------------------------------

Further to that, customer performed following test cases:

Test 1:
At HK time 2012-10-25 7:03pm, schedule a workflow on the Admin - Server > Jobs view with scheduled date set at HK time 2012-10-25 8:00pm.  
The record on S_SRM_REQUEST had SCHED_START_DT found to store 2012-10-25 12:00pm.

After submitting the workflow job, the job turns from Queued to Active after a few seconds.  It does not need to wait til 8:00pm to start to run the workflow.

Test 2:
At HK time 2012-10-25 7:04pm, schedule a workflow on the Admin - Server > Jobs view with scheduled date set at HK time 2012-10-26 3:07am.  The record on S_SRM_REQUEST has SCHED_START_DT found to store 2012-10-25 7:07pm.

After submitting the workflow job, the job turns from Queued to Active when current time becomes 2012-10-25 7:07pm.

All servers were working in same timezone and DB is in GMT timezone.

Changes

 No Changes were performed in application.

Cause

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