Package Irc_search_criteria_swi Procedure Create_vacancy_criteria Error While Creating a Vacancy (Doc ID 1480358.1)

Last updated on DECEMBER 03, 2016

Applies to:

Oracle iRecruitment - Version 12.1 HRMS RUP4 and later
Information in this document applies to any platform.

Symptoms

On Applications 12.1 HRMS RUP4:

After upgrading from 11i to 12i and upgrading database from 9i to 11g, when attempting to create a new vacancy, the following error occurs:

-- Error
 ORA-20000: Oracle Text error: DRG-00100; internal error, arguments: [51021],[drwaf.c],[1615],[],[] ORA-06512: at "CTXSYS.DRUE", line 160 ORA-06512: at "CTXSYS.DRVDML", line 490 ORA-06512: at "HR.DR$IRC_SEARCH_CRITERIA_CTXTC", line 1 ORA-0 in Package irc_search_criteria_swi Procedure create_vacancy_criteria

 -- Steps
The issue can be reproduced at will with the following steps.
1. iRecruitment Recruiter > iRecruiter Home
2. New Vacancy > Enter details > click next.

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