ERPstuff - Oracle EBS Community

Dear All,

I am using Oracle EBS 11.5.10.2 with Database 10.2.0.3.0

I am facing the problem while Insert or Update the data on Employee form in Global HRMS. When I am going to save the record the following error occur:
FRM-40735 and Ora-29861
I found the reason of the error to rebuild the domain indexes. I followed the Metalink Doc ID [420090.1] to rebuild the domain indexes and not successful.
Kindly help me in this regards.

Regards
Rana Abdul Wahid

When I am going to rebuild the index
"ALTER INDEX HR.PER_ADDRESSES_N4 REBUILD;" I got the following error:

ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-00942: table or view does not exist
ORA-06512: at "CTXSYS.CATINDEXMETHODS", line 186
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "CTXSYS.DRVDDLC", line 308
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "CTXSYS.DRVDISP", line 102
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "CTXSYS.DRVDISP", line 154
ORA-06510: PL/SQL: unhandled user-defined exception

Regards
Rana Abdul Wahid

First you need to check what kind of change caused this issue then also check which objects are invalid using toad and compile like any package etc. Once done then let update us. tks

do you find it?