My Oracle Support Banner

Fusion Applications OTBI: Error "Function FILTER requires at least one measure column in its first argument" (Doc ID 2638449.1)

Last updated on JUNE 10, 2020

Applies to:

Oracle Fusion CX Sales Cloud Service - Version 11.13.19.10.0 and later
Information in this document applies to any platform.

Symptoms

 When attempting to run a custom analysis, the following occurs:

Error Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P:OI2DL65P
Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 22032. [nQSError: 22032] Function FILTER requires at least one measure column in its first argument. (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('SELECT SUM(FILTER("Revenue Extension"."Extension Attribute Number 004" USING ("Resource Extension"."Extension Attribute LOV 004" = ''XXXX'') )) FROM "Sales - CRM Opportunities and Products Real Time"')}
SQL Issued: SELECT SUM(FILTER("Revenue Extension"."Extension Attribute Number 004" USING ("Resource Extension"."Extension Attribute LOV 004" = 'XXXX') )) FROM "Sales - CRM Opportunities and Products Real Time"

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.