OBIEE 11g - Database Connection Via Admin Tool Uses Wrong NLS Date Settings, Causing Reports To Fail With Error Message "ORA-01858: a non-numeric character was found where a numeric was expected"
Last updated on FEBRUARY 01, 2017
Applies to:Business Intelligence Server Enterprise Edition - Version 126.96.36.199.150120 and later
Information in this document applies to any platform.
- Running the following SQL in a Physical Table View :
TO_CHAR (the_date, 'dd-Mon-yyyy') date_ddmonyyyy,
TO_CHAR (the_date, 'dd-Mon-yyyy') char_ddmonyyyy
FROM ( SELECT TO_DATE ('01-Jan-1800') + LEVEL - 1 the_date
CONNECT BY LEVEL
- Gives the following error :
"ORA-01858: a non-numeric character was found where a numeric was expected"
- Database is set up to use :
NLS_DATE_FORMAT = DD-MON-RR
NLS_DATE_LANGUAGE = AMERICAN
- However, when the NQSserver.exe logs in to the database via the Admin tool, the same parameters at login time are:
NLS_DATE_FORMAT = RR-MM-DD
NLS_DATE_LANGUAGE = DANISH
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