HRMS - New Employee creation Errors out ORA-29861

Cause'PER_ADDRESSES_SPT' Index status is failed.
It should be valid.
unpublished bug 4440568 GET TRIGGER ERRORS ENTERING PEOPLE AND LOCATIONS IN HRMS
Reported issue points to a root cause of oracle spatial not being correctly installed on this environment.

Please fix your environment, re-run the index script noted above and recommence your testing.

Solution
To implement the solution, please execute the following steps in your test instance first:

1) ) Run $ORACLE_HOME/md/admin/mdinst.sql from 9iR2 Oracle_home.
connect as system/manager.

2) Forcefully drop the indexes.
connect apps/apps

drop index hr.HR_LOCATIONS_SPT force;
drop index HR.PER_ADDRESSES_SPT force;

3) Delete the entries from sdo_index_metadata_table
connect mdsys/mdsys

delete from sdo_index_metadata_table where sdo_index_name='HR_LOCATIONS_SPT';
delete from sdo_index_metadata_table wheresdo_index_name='PER_ADDRESSES_SPT';
commit;

4) rebuild the indexes.

sqlplus apps/apps @@$PER_TOP/patch/115/sql/irctxloc.sql HR applsys apps CTXSYS
sqlplus apps/apps @@$PER_TOP/patch/115/sql/irctxadr.sql HR applsys apps CTXSYS(
note : HR applsys apps CTXSYS are 4 parameters to the sql)

5) Verify that the index is valid by running

SQL > select DOMIDX_STATUS, DOMIDX_OPSTATUS from dba_indexes whereINDEX_NAME = 'PER_ADDRESSES_SPT';


BUT NONE OF THESE WORKED FOR ME. I DELETED THE INDEXES AND RETESTED THE ISSUE.. THE ISSUE GOT RESOLVED... :)