My Oracle Support Banner

Irecruitment Search Function Down Since OATM Migration Getting ORA-20000: Oracle Text error: DRG-10599 (Doc ID 1317703.1)

Last updated on DECEMBER 03, 2019

Applies to:

Oracle iRecruitment - Version 11.5.10 HRMS FP.K RUP9 and later
Information in this document applies to any platform.


After doing an Oracle table migration, when an individual  or an applicant logs into the iRecruitment web site and searches for a job by location, the following error occurs
the following error occurs.

## Detail 0 ## java.sql.SQLException: ORA-20000: Oracle Text error: DRG-10599: column is not indexed at oracle.jdbc.dbaccess.DBError.throwSqlException( at oracle.jdbc.ttc7.TTIoer.processError( at oracle.jdbc.ttc7.Oall7.receive( at oracle.jdbc.ttc7.TTC7Protocol.doOall7( at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch( at oracle.jdbc.driver.OracleStatement.doExecuteQuery( at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout( at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate( at

The issue can be reproduced at will with the following steps:
1.  Navigate to the iRecruitment Web site
2. Do a job search or log in and the do a job search by location
3. Error occurs


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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