An Arithmetic Operation Is Being Carried Out On A Non-numeric Type
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Fusion Payables - Version 220.127.116.11.0 and later
Information in this document applies to any platform.
On : 18.104.22.168.0 version, Analytics
Customer wants to deduct the current date from the due date for which the following formula was used:
"Invoices Installment Details"."Due Date" - CURRENT_DATE
However, the following error is returned:
Formula syntax is invalid.
[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: SELECT "Invoices Installment Details"."Due Date" - CURRENT_DATE FROM "Payables Invoices - Installments Real Time"
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms