My Oracle Support Banner

Siebel UPT Mechanism Time Difference (Doc ID 2437331.1)

Last updated on AUGUST 20, 2018

Applies to:

Siebel CRM - Version 15.18 [IP2015] and later
Information in this document applies to any platform.

Symptoms

On : 15.18 [IP2015] version, Siebel Workflow

WHAT IS THE DESIRED BEHAVIOR?
=============================
UPT Event Start Date and Event End Date should be the same as system time zone.

WHAT IS THE ACTUAL OR UNEXPECTED BEHAVIOR?
==========================================
Usage Pattern Tracking Event Start Date and Event End Date are set in wrong time zone. This behavior is the same independently of the value entered in the time zone field of the user profile or Default Time Zone/Universal Time Coordinated parameters set in system preference.

 

REPRO_STEPS

===========
1. Configure UPT using Doc ID 2259206.1.
2. Go to system preference and set "Universal Time Coordinated" SysPref to FALSE.
3. Login on Siebel Server and go to <siebsrvr>\upt: Notice that the timestamp for .csv file is set in UTC+00:00. After running the UPT job to process data into DB (table S_USER_EVENT) the start and end time fields are stored S_USER_EVENT in UTC+00:00.

4. Go to system preference and set "Universal Time Coordinated" SysPref to TRUE.

Notice that the timestamp for .csv file is set in UTC+00:00. After running the UPT job to process data into DB (table S_USER_EVENT) the start and end time fields are stored in the S_USER_EVENT in UTC -02:00. The process takes off 2 hours.

P.S: In IP2016 when "Universal Time Coordinated" SysPref is set to TRUE, in <siebsrvr>\upt the timestamp for .csv file is set to UTC+00:00. After running the UPT job to process data into DB (table S_USER_EVENT) the start and end time fields, are stored in S_USER_EVENT in UTC +07:00. The process has seven hours in advance. The UPT records are shown in the Siebel Client in
UTC+00:00.



Changes

 

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!


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