My Oracle Support Banner

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 13, 2017

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.1.11.1.0 and later
Oracle 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

Changes

 

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!


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