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

(Doc ID 2098570.1)

Last updated on NOVEMBER 01, 2017

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

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