Legend feature display options do not function properly when symbolizing by unique fields on an Oracle ST_Geometry feature class when using ArcGIS Pro.
This issue is due to Oracle not being configured to load the ST_Geometry shared library via the Oracle external procedure agent, or extproc. If this is the case, spatial queries on feature classes that are configured to use ST_Geometry will fail. When the database server is correctly configured to call the ST_Geometry shared native library, the dynamic legend returns the expected result.To solve this issue, the database server must be correctly configured to load the ST_Geometry shared native library. The instructions can be found at http://desktop.arcgis.com/en/arcmap/latest/manage-data/gdbs-in-oracle/configure-oracle-extproc.htm. As a workaround, the feature class can be copied using the geoprocessing tool Copy while making sure that “SDO_GEOMETRY” is entered for the Output CONFIG Keyword under the Environments tab of the tool. You can also use the context menu commands in the Catalog pane to Copy the feature class and paste the copy back into the geodatabase. When pasting use the command Paste special and select the SDO_Geometry option.The resulting copy will use the Oracle spatial type (SDO_GEOMETRY) instead of the Esri spatial type (ST_GEOMETRY). However, SDO_GEOMETRY only supports a subset of all the geometric properties supported natively by the Esri ST_GEOMETRY type. Please see the links below for more information.http://pro.arcgis.com/en/pro-app/help/data/geodatabases/manage-oracle/stgeometry-oracle.htmhttp://pro.arcgis.com/en/pro-app/help/data/geodatabases/manage-oracle/sdogeometry-feature-classes.htm