Question

Search Domain index Issue on Apps9

  • 29 January 2024
  • 3 replies
  • 69 views
M
Rank
Badge +5

Hello ,

i am following the below Steps to Re-create the Search Domain 
 

1. Go to "Search Domains" window in IEE.

2. RMB on the relevant search domain (“CustomerInvoices”.) and select "Show Details...". This will direct you to the detail view of the search domain.

3. RMB on the detail view and select “Schedule Domain Activation”.

4. Click on “Enable Schedule” link. This will direct you to Task Schedule window.

5. RMB and select “Run”.

6. Click “View background jobs for this task”. This will show the background job created for this.

When 

In background jobs ‘s Error Text as given Below error 

 

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

ORA-20000: Oracle Text error:

DRG-12203: section group APPLICATION_SEARCH does not exist

ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 1632

ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 683

ORA-06512: at "IFSAPP.DEFERRED_JOB_API", line 1806

 

Environments  Details

Application: Apps9 on windows 2016
database version : Database 12c Enterprise Edition Release 12.1.0.2.0  on windows 2016

 

Please help me on this to resolve the issue

 

Thanks

Manas Hati



 

 

3 replies

Ragaventhan Sathananda
Rank
Userlevel 7
Badge +15

Hi @Manashati 

Execute the bellow steps to rebuild the Index to resolve the above errors.

1. Go to the specific search domain (“CustomerInvoices”.) details and RMB

2. Select Drop Search Index

3. Refresh search domain

4. RMB and select Schedule Domain Activation

5. Select a date/time to activate the search domain (Please select an OFFPEAK time).

6. The system will rebuild the search domain and enable it in the given date/time.

Additionally,
Execute the following two statements log in as SYS user; which would first grant UTL_HTTP package to CTXSYS & then compile the invalid DRVDML package. In a multitenant (CDB) environment, connect as SYS to Container DB (not to PDB).

  • GRANT EXECUTE ON UTL_HTTP TO CTXSYS;
  • ALTER PACKAGE CTXSYS.DRVDML COMPILE BODY;

Once done, disable & enable the search domains again. Try the additional steps and see if that helps!

Ragaventhan S - https://www.linkedin.com/in/ragaventhan-sathananda/
M
Rank
Badge +5

Hi @Ragaventhan Sathananda 

 

I followed all the steps what you have mentioned , but no luck, having same issue.

 

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-12203: section group APPLICATION_SEARCH does not exist
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 1632
ORA-06512: at "IFSAPP.TRANSACTION_SYS", line 683
ORA-06512: at "IFSAPP.DEFERRED_JOB_API", line 1806

 

Thanks

Manas Hati


 

 

Ragaventhan Sathananda
Rank
Userlevel 7
Badge +15

try restarting the database and refresh the server cache from the application window

Ragaventhan S - https://www.linkedin.com/in/ragaventhan-sathananda/

Reply


Terms & ConditionsCookie settings