My Oracle Support Banner

'ORA-00932: Inconsistent Datatypes: Expected - Got CLOB' Error in Data Entry Form (DEFQ) (Doc ID 2098570.1)

Last updated on AUGUST 25, 2020

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) Infrastructure, when you open a Data Entry Form created for a table that has a column defined as CLOB, the Form fails to load and the following error appears:

ORA-00932: inconsistent datatypes: expected - got CLOB

The same error exists in the DeFiService.log from $FIC_APP_HOME/common/FICServer/logs:

[DEFILOG] Jan 19,16 14:28:24 : [ABSTRACTDATAENTRYREPOSITORY]ORA-00932: inconsistent datatypes: expected - got CLOB
java.sql.SQLSyntaxErrorException: ORA-00932: inconsistent datatypes: expected - got CLOB

In the definition of the Form, the CLOB column is among the columns selected for sorting.

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.