Fusion OTBI - Getting Error On Concatenating Double With Varchar Column In OTBI Analysis
(Doc ID 2352988.1)
Last updated on JULY 04, 2022
Applies to:
Oracle Fusion Global Human Resources Cloud Service - Version 11.1.11.1.0 and laterOracle Fusion Application Toolkit Cloud Service - Version 11.1.11.1.0 and later
Oracle Fusion Sales Cloud Service - Version 11.1.11.1.0 and later
Information in this document applies to any platform.
Symptoms
When attempting to concatenate "Workforce Management - Worker Assignment Real Time"."Worker"."Notice Period UOM" with "Workforce Management - Worker Assignment Real Time"."Worker"."Notice Period" the following error occurs.
ERROR
-----------------------
Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. (HY000)
[nQSError: 43113] Message returned from OBIS. (HY000)
[nQSError: 22020] Function Concat does not support non-text types. (HY000)
SQL Issued: SELECT CONCAT("Worker"."Notice Period", "Worker"."Notice Period UOM") FROM "Workforce Management - Worker Assignment Real Time"
OK (Ignore Error)
-----------------------
Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. (HY000)
[nQSError: 43113] Message returned from OBIS. (HY000)
[nQSError: 22020] Function Concat does not support non-text types. (HY000)
SQL Issued: SELECT CONCAT("Worker"."Notice Period", "Worker"."Notice Period UOM") FROM "Workforce Management - Worker Assignment Real Time"
OK (Ignore Error)
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 |