Getting ORA-01858 Error Executing Procedure in SQL ID (Doc ID 242455.1)

Last updated on MARCH 09, 2017

Applies to:

Oracle Financial Data Manager - Version 4.5 to 4.5.40 [Release 4.5]
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA)
SQL ID

Symptoms

In Oracle Balance and Control (BC) 4.5, you get the following error when executing a procedure in a SQL ID:

ORA-01858: a non-numeric character was found where a numeric was expected

The SQL statement referenced in the error message references a date field.
You can execute the procedure successfully in SQL*Plus.

Cause

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 hundreds of Community platforms