Locations Spatial Index Rebuild Failed Read User_sdo_geom_metadata (Doc ID 736113.1)

Symptoms

The concurrent program "Locations Spatial Index Rebuild" creates the index HZ_LOCATIONS_N15
which is failing with the error message:

The following SQL error occurred:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13203: failed to read USER_SDO_GEOM_METADATA table
ORA-13203: failed to read USER_SDO_GEOM_METADATA table.

The problem is:
SQL> select SDO_OWNER,SDO_COLUMN_NAME from mdsys.sdo_geom_metadata_table where
sdo_table_name='HZ_LOCATIONS';

SDO_OWNER SDO_COLUMN_NAME
----------------------- ------------------------------------------
APPS GEOMETRY

The code is expecting SDO_OWNER = AR

Changes

Cause

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