My Oracle Support Banner

Siebel Data In Database Is Showing Incorrect Time Zone; Integrations Using Time And Date Are Incorrect When Extracting Data (Doc ID 2800714.1)

Last updated on SEPTEMBER 09, 2021

Applies to:

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

Symptoms

Integrations between Siebel and an external system were showing a different time and date from the siebel db dates and the user time and date when user preferences were set

The data from the integration should be the same time as the siebel server. The siebel data in the database was inserted correctly when using Siebel according to the user preferences, but the data was not correct according to the db timezone

The issue can be reproduced at will with the following steps:
1. Install Siebel, add an integration (SOAP call for example)
2. Set siebel server as UTC
3. Set user preferences to the local timezone
4. Run an integration, the data in the integration was not the same as the server db

Changes

 The siebel installation was added on VM ware.

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


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