Fusion OTBI - Error When Using Varchar Column in Calculation of Arithmetic Operation - Carried Out on a Non-numeric Type
(Doc ID 2250651.1)
Last updated on DECEMBER 19, 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
Information in this document applies to any platform.
Symptoms
Getting below error in OTBI report when using Formula to calculate a field value: ("Payroll - Element Entries Real Time"."Element Entry Value"."Displayed Input Value"/100)
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 22023] An arithmetic operation is being carried out on a non-numeric type. (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('SELECT CASE WHEN "Payroll - Element Entries Real Time"."Input Value"."Input Value Name" in (''Amount'') THEN ("Compensation - Salary Details Real Time"."Salary"."Annualized Salary"+("Compensation - Salary Details Real Time"."Salary"."Annualized Salary"*("Payroll - Element Entries Real Time"."Element Entry Value"."Displayed Input Value"/100))) ELSE NULL END FROM "Payroll - Element Entries Real Time"')}
SQL Issued: SELECT CASE WHEN "Payroll - Element Entries Real Time"."Input Value"."Input Value Name" in ('Amount') THEN ("Compensation - Salary Details Real Time"."Salary"."Annualized Salary"+("Compensation - Salary Details Real Time"."Salary"."Annualized Salary"*("Payroll - Element Entries Real Time"."Element Entry Value"."Displayed Input Value"/100))) ELSE NULL END FROM "Payroll - Element Entries Real Time
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 |