BI Reports Error When Using CAST Function: [nQSError: 22025] Function Cast is Called With an Incompatible Type. (Doc ID 2018423.1)

Last updated on FEBRUARY 01, 2017

Applies to:

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

Symptoms

When attempting to to run the below custom formula CASE WHEN "Activity"."Actual End Date" IS NULL THEN "Activity"."Due Date" ELSE "Activity"."Actual End Date" END

ERROR
-----------------------
Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 22025] Function Cast is called with an incompatible type. (HY000)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login in BI Answer
2. Create a new analysis based on the Sales - CRM Sales Activity
3. Create the following analysis:
SELECT
  0 s_0,
  "Sales - CRM Customer Overview"."Activity"."Actual End Date" s_1,
  "Sales - CRM Customer Overview"."Activity"."Due Date" s_2,
  CASE WHEN "Sales - CRM Customer Overview"."Activity"."Actual End Date" is
NULL then "Sales - CRM Customer Overview"."Activity"."Due Date" ELSE "Sales -
CRM Customer Overview"."Activity"."Actual End Date" END s_3
FROM "Sales - CRM Customer Overview"
4. The Formula column gets an error


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use this validation

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