My Oracle Support Banner

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

Last updated on MARCH 19, 2019

Applies to:

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


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

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)

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:
  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

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


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

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