Receive CTXSYS and DRG-10502: index HR_LOCATIONS_N1 Does not Exist Error When Creating New Location (Doc ID 1457151.1)

Last updated on JULY 12, 2016

Applies to:

Oracle Human Resources - Version 12.1.1 and later
Information in this document applies to any platform.
PERWSLOC.fmb

Symptoms

In Location form(PERWSLOC.fmb) when attempting to save the location details, the following error occurs.

ORA-20000: Oracle Text error:
DRG-10502: index HR_LOCATIONS_N1 does not exist

ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.DRVDML", line 492
ORA-06512: at "HR.DR$HR_LOCATIONS_N1TC", line 1
ORA-04088: error during execution of trigger
'HR.DR$SR_LOCATIONS_N1TC'
ORA-06512: at "APPS.HR_LOCATION_API", line 470


Steps to Reproduce
The issue can be reproduced at will with the following steps:

      1. Login to HRMS Responsibility.

      2. Navigate to Location Form.

      3. Try creating a new Location.

      4.  Receive error:

ORA-20000: Oracle Text error:
DRG-10502: index HR_LOCATIONS_N1 does not exist

 

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