My Oracle Support Banner

3.18.1 Error in SearchBuilder while Using Reference Sheet (Doc ID 2538198.1)

Last updated on MAY 07, 2020

Applies to:

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

Symptoms

On : 3.18.1 all patches , User Interface
Acceptance

We are getting an error in dynamic logic while using SearchBuilder with a reference sheet.


ERROR
-----------------------
OHI-DYLO-007: Error occurred in dynamic logic "DFD_SKIP_TEST1" on line "7": "java.lang.UnsupportedOperationException: UDP_DRG_PROC_TYP_CD is either not a valid attribute in ReferenceSheetLineDomain or is not searchable"




STEPS
-----------------------
The below logic is being used for referenceSheet.

def drgCarveouts =new SearchBuilder(ReferenceSheetLine?.class).join("UDP_DRG_CVOT_MTD_SHT")
  drgCarveouts =drgCarveouts.by("UDP_PV_CD").eq(claimLine.priceOrganizationProvider?.code)
  drgCarveouts =drgCarveouts.and().by("UDP_ACTV_IND.code").eq('Y')
  drgCarveouts =drgCarveouts.and().by("UDP_DRG_PROC_TYP_CD").eq(claim?.diagnosisRelatedGroup)
  drgCarveouts =drgCarveouts.and().by("startDate").lte(claimLine?.priceInputDate)
  drgCarveouts =drgCarveouts.and().group().by("endDate").eq(null).or().by("endDate").gte(claimLine?.priceInputDate).end()
  drgCarveouts =drgCarveouts.execute()

Changes

 

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
Changes
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.