My Oracle Support Banner

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

Last updated on DECEMBER 03, 2019

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

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

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