An Arithmetic Operation Is Being Carried Out On A Non-numeric Type
(Doc ID 2178834.1)
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Fusion Payables - Version 126.96.36.199.0 and later
Information in this document applies to any platform.
On : 188.8.131.52.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"
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