Considerations when using Oracle database

When using Oracle database as the managed data store for ArcGIS Enterprise, feature service field names are converted to uppercase regardless of the case used when the fields were specified. Because feature service field names are case sensitive, the conversion to uppercase in the back-end database causes the feature service to update incorrectly; consequently, the map layer will not be updated and will contain no data.

If you use Oracle as the managed data store for ArcGIS Enterprise, you should select Administration > Systems and check the box labeled: My organization uses ArcGIS Servers with Oracle based Enterprise GeoDatabase.

When the box is checked, PI Integrator for Esri ArcGIS exhibits the following behaviors:

• All existing attribute names are converted to uppercase.

• All newly created layers will use all uppercase field names.

Because feature services and GeoEvent Definitions in ArcGIS GeoEvent Server are case sensitive, converting the data to uppercase is required to prevent loss of data.