(203105) Oracle drv_oci error Opening Leaf Characteristics ID in Oracle Risk Manager (RM) 4.5 (Doc ID 187442.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Risk Manager - Version 4.5 and later
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) - Version 4.5
Note: All OFSA 4.5 products have reached sustaining support.

Symptoms

When attempting to open a Leaf Characteristics ID in Oracle Risk Manager (RM) the following error is displayed:

(203105) Oracle drv_oci error:
OCI Function : [4] - oexec(), oexn()
SQL Function : [4] - SELECT Oracle Error : ORA-01790: expression must have same datatype as corresponding express Driver Function : drv_oci;;Execute() SQL Statement: select ADDITION_TYPE_CD Value, ADDITION_TYPE Description from ALM.OFSA_ADDITION_TYPE_DSC union select ADJUSTABLE_TYPE_CD Value, ADJUSTABLE_TYPE Description from ALM.OFSA_ADJUSTABLE_TYPE_DSC order by description

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms