How to Modify the Schema Service Date to Reflect Local Time (Doc ID 2100707.1)

Last updated on JANUARY 27, 2016

Applies to:

Oracle Business Intelligence Cloud Service - Version N/A and later
Oracle Database Cloud Service - S5 - Version N/A and later
Information in this document applies to any platform.

Goal

When data is loaded into the Schema Service using Data Sync or other means, the date reflected in the database is different that the data uploaded. This can be also be seen when querying the database in general with the following query:


Is it possible to modify the service to reflect the local time rather than the system time?
 

Solution

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 hundreds of Community platforms