TeleService Error: ORA-20200, ORA-29875, DRG-50857 While Creating Service Request with CS_SERVICEREQUEST_PUB API (Doc ID 1529768.1)

Last updated on SEPTEMBER 06, 2016

Applies to:

Oracle Teleservice - Version 12.1.3 and later
Information in this document applies to any platform.
Checked for relevance on ***16-SEP-2014***

Symptoms

When creating a Service Request through Web Service (API CS_SERVICEREQUEST_PUB) after upgrade from 11.5.10 to 12.1.3, the following error messages are generated:

Error code: 20200, error description: SQLException:
ORA-20200: -20000:ORA-20000: API validation error. Error originally occured in proc: CreateServiceRequest. Error msg: ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in textindexmethods.ODCIIndexInsert
ORA-20000: Oracle Text error:
DRG-10607: index meta data is not ready yet for queuing DM in package CS_ServiceRequest_PVT, process Create_ServiceRequest: ERROR_REF = 718873: = : ERROR_REF = 718873

Changes

Upgraded from 11.5.10 to 12.1.3.

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