laptop and a wrench

Bug

Geodatabase View with Oracle 19c containing Timestamp Offset fields raises an error: SE_DBTIMESTAMPTZINFO object not initialized.

ArcGIS Pro
Bug ID Number BUG-000175478
SubmittedApril 1, 2025
Last ModifiedJuly 15, 2025
Applies toArcGIS Pro
Version found3.4.2
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusIn Review

Workaround

Use to_char() syntax to return the offset timestamp as text in the SQL, noting this will limit any date calculations or query logic using this field but is sufficient for visualization.

select objectid ,created_date ,to_char(created_date at time zone 'UTC') "CREATION_DATE" ,last_edited_date , to_char(last_edited_date at time zone 'UTC') "UPDATED_DATE" from sdo.my_fc

Steps to Reproduce

Bug ID: BUG-000175478

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options