Cannot Reference Columns From Multiple SA's Within A Case Statement in OTBI Report
(Doc ID 2995782.1)
Last updated on JANUARY 17, 2024
Applies to:
Oracle Fusion CX Sales Cloud Service - Version 11.13.23.07.0 and laterInformation in this document applies to any platform.
Symptoms
On : 11.13.23.07.0 version, Analytics
ACTUAL BEHAVIOR
---------------
CASE Statement on custom filed not working as expected
Condition : CASE WHEN "Lead Extension"."Extension Attribute Character 187" = 'Y' THEN 'Deferred' ELSE "Lead"."Lead Status" END
The above condition is working fine in an Other Report but not in the Mentioned Report,
EXPECTED BEHAVIOR
-----------------------
Should work as expected
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Open the BI report > check results for status Deferred.
BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot get correct values
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 |