PER.IRC_DOCUMENTS_CTX Index hang during the creation ORA-20000 DRG-50857 ORA-06502: PL/SQL: numeric or value error: character to number conversion error (Doc ID 3000883.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

On : 19.10.0.0.0 version, Creating/Maintaining context indexes

 .... DOMAIN INDEX OPERATION STATUS => FAILED


IRC_DOCUMENTS IRC_DOCUMENTS_CTX VALID VALID FAILED
 .... DOMAIN INDEX OPERATION STATUS => FAILED

Followed :below note to rebuild but still fails
Oracle Text: Re-installation and Rebuilding of Applications R12 Oracle Text Indexes (Doc ID 743720.1)
8. Create the HR Text index preferences and indexes (27, 28, 29, 30, 31, 32, 33):

 

ERROR
-----------------------

ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-06512: at "APPS_APPLMGR.AD_DDL", line 210
ORA-06512: at "APPS_APPLMGR.AD_DDL", line 402
ORA-06512: at "APPS_APPLMGR.AD_DDL", line 449
ORA-06512: at "APPS_APPLMGR.AD_APPS_PRIVATE", line 260
ORA-06512: at "PER.APPS_DDL", line 29
ORA-20000: Oracle Text error:
DRG-50857: oracle error in dretbase
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "CTXSYS.DRIXMD", line 1834
ORA-01403: no data found
ORA-06512: at "CTXSYS.DRIXMD", line 1819
ORA-06512: at "CTXSYS.DRVXMD", line 203
ORA-06512: at line 1
ORA-06512: at "CTXSYS.DRUE", line 186
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 320
ORA-06512: at "SYS.DBMS_SQL", line 1134
ORA-06512: at "PER.APPS_DDL", line 23
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_SQL", line 1721
ORA-06512: at "APPS_APPLMGR.AD_APPS_PRIVATE", line 242
ORA-06512: at "APPS_APPLMGR.AD_DDL", line 417
ORA-06512: at "APPS_APPLMGR.AD_DDL", line 331
ORA-06512: at "APPS_APPLMGR.AD_D

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.