My Oracle Support Banner

Java.sql.SQLException: ORA-29902: Error In Executing ODCIIndexStart() Routine (Doc ID 2719373.1)

Last updated on OCTOBER 13, 2020

Applies to:

Oracle Health Insurance Claims Adjudication - Version 3.20.2.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 3.20.2.0.0 version, Processing

When attempting to execute the ODCIIndexStart() routine, the following error occurs.

ERROR
-----------------------
Use of SearchBuilder in Groovy results in SQLException:

81: def search = new SearchBuilder(ReferenceSheetLine.class).join("rsHWEXIPAG")
82: search = search.by("serviceFundGrouper").eq(claim?.claimMiscFields2?.serviceFundGrouper?:"")
83: search = search.and().by("startDate").lte(claimLine?.startDate)
84: search = search.and().group().by("endDate").eq(null).or().by("endDate").gte(claimLine?.startDate).end()
85: *ERROR* --> def results = search.execute()

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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