PERWSHRG / PERSWEMP / PERWSLOC / HR_EMPLOYEE_API.CREATE_US_EMPLOYEE API Errors with FRM-40735 On-Insert Trigger Raised Unhandled Exception ORA-29861 domain index is marked LOADING/FAILED/UNUSABLE

(Doc ID 401989.1)

Last updated on AUGUST 18, 2017

Applies to:

Oracle Human Resources - Version 11.5.10.2 and later
Oracle Purchasing - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms


When adding and saving new employee using PERWSHRG form

or

When entering new employees using HR_EMPLOYEE_API.CREATE_US_EMPLOYEE API

or

When trying to create a new employee using Purchasing responsibility in a Shared installation using PERSWEMP form

or

When attempting to save a location using PERWSLOC form

the following error occurs:

FRM-40735 On-Insert trigger raised unhandled exception ORA-29861

 

STEPS TO REPRODUCE
--------------------------
Global HR Administrator -> Enter People form (PERWSHRG) -> Enter employee information -> Save
or
Run HR_EMPLOYEE_API.CREATE_US_EMPLOYEE API
or
Purchasing > Setup > Personnel > Employees (PERSWEMP) -> Enter some information -> Save
or
US Super HRMS Manager>Work Structures>Location (PERWSLOC) -> Select Global -> Enter Location -> Save

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