Error ORA-29861 Domain Index Is Marked Loading/Failed in Package CS_ServiceRequest_PVT Procedure Create_ServiceRequest

(Doc ID 558353.1)

Last updated on OCTOBER 25, 2016

Applies to:

Oracle Teleservice - Version 11.5.10 to 11.5.10.2 [Release 11.5]
Information in this document applies to any platform.
***Checked for relevance on 02-Jan-2014***


Symptoms

-- Problem Statement:
On 11.5.10:
When attempting to create a Service Request after migrate to OATM (Oracle Applications Tablespace Model), the following error occurs:

ERROR
ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE in Package
CS_ServiceRequest_PVT Procedure Create_ServiceRequest

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Navigate to Service Request form
2. Complete mandatory information
3. When trying to save, the error occurs.

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