My Oracle Support Banner

Updating Address Details Of An Employee In Shared HR Throws Error - "ORA-20000: Oracle Text Error DRG-10502: index PER_ADDRESSES_N4 does not exist" (Doc ID 2722857.1)

Last updated on OCTOBER 29, 2020

Applies to:

Oracle Human Resources - Version 12.2 HRMS RUP13 and later
Information in this document applies to any platform.


When trying to update Address Details for an employee from Payables Manager, following error appears


ORA-20000: Oracle Text Error
DRG-10502: index PER_ADDRESSES_N4 does not exist


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

1. Login using "Payables Manager" Responsibility.

2. Navigate to Employees --> Enter Employees

3. Create a New Employee and Save

4. Click on Others and enter the Address details and Assignment Details

5. When trying to save the same, got the above error message.


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.