Claims Processing Fails Java.sql.SQLException: ORA-29903: Error In Executing ODCIIndexFetch() (Doc ID 2806588.1)

Last updated on SEPTEMBER 28, 2021

Applies to:

Goal

On : 3.20.2.0.0 version, Processing

Claims processing fails java.sql.SQLException: ORA-29903: error in executing ODCIIndexFetch()

2021-07-20 06:48:44,588 [ [ACTIVE] ExecuteThread: '14' for queue: 'weblogic.kernel.Default (self-tuning)' ] ERROR ohi.dynamiclogic.hp_dfd_cotiviti_eligibilty.HP_DFD_COTIVITI_ELIGIBILTY - exception OHI-DYLO-007; nested exception is org.springframework.orm.jpa.JpaSystemException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.5.v20170607-b3d05bd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-29903: error in executing ODCIIndexFetch() routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drekrbgm (reselect rowid row)
ORA-01422: exact fetch returns more than requested number of rows


Error Code: 29903
Call: select tabl.* from OHI_REFERENCE_SHEET_LINES tabl , OHI_REFERENCE_SHEETS tabl1,COD_DYNAMIC_FIELD_USAGES_B tabl2 where ((tabl2.FIELD_USAGE_NAME = ?) and (json_value(tabl.payload, '$.UDP_ACTV_IND.code' returning varchar2) = ?)) and (tabl1.id = tabl.RESH_ID) and (tabl2.id = tabl1.DFUS_ID)
  bind => [RESH_UDP_TP_PV_EXCL_SHT, Y]
Query: ReadAllQuery(referenceClass=ReferenceSheetLineClaimsDomain sql="select tabl.* from OHI_REFERENCE_SHEET_LINES tabl , OHI_REFERENCE_SHEETS tabl1,COD_DYNAMIC_FIELD_USAGES_B tabl2 where ((tabl2.FIELD_USAGE_NAME = ?) and (json_value(tabl.payload, '$.UDP_ACTV_IND.code' returning varchar2) = ?)) and (tabl1.id = tabl.RESH_ID) and (tabl2.id = tabl1.DFUS_ID)"); nested exception is javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.5.v20170607-b3d05bd): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: ORA-29903: error in executing ODCIIndexFetch() routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drekrbgm (reselect rowid row)
 

Solution

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