irctxloc : ORA-13249: Multiple entries in sdo_index_metadata table (Doc ID 725843.1)

Last updated on JULY 19, 2016

Applies to:

Oracle Human Resources - Version: 11.5.10.2 to 11.5.10.2 - Release: 11.5 to 11.5
Oracle Human Resources - Version: 11.5.10.2 to 11.5.10.2   [Release: 11.5.10 to 11.5.10]
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
On 11.5.10.2 in Production:
When attempting to upload new Employees using the create employee API (HR_EMPLOYEE_API), and error occurs:

FRM-40735 On-Insert trigger raised unhandled exception

ORA 29861 domain index is marked LOADING/FAILED/UNUSABLE 

Note 401989.1 - Creating New Employee Errors FRM-40735 On-Insert Trigger Raised Unhandled Exception ORA-29861 domain index is marked LOADING/FAILED/UNUSABLE

provides a solution,  but it erred as below:

ERROR
SQL> @irctxloc HR applsys apps CTXSYS
declare
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: Multiple entries in sdo_index_metadata table
ORA-06512: at "SYSTEM.AD_DDL", line 160
ORA-06512: at line 107

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. uploading new Employees using te create employee API cusomers are getting the "domain index is
marked LOADING/FAILED/UNUSABLE" error.
2. apply the solution from the note 401989.1
3. Get the error
SQL> @irctxloc HR applsys apps CTXSYS
declare
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-13249: internal error in Spatial index: [mdidxrbd]
ORA-13249: Multiple entries in sdo_index_metadata table
ORA-06512: at "SYSTEM.AD_DDL", line 160
ORA-06512: at line 107

Cause

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