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" (Doc ID 2033177.1)

Last updated on FEBRUARY 01, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.150120 and later
Information in this document applies to any platform.

Symptoms

SELECT the_date,
  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
  FROM DUAL
  CONNECT BY LEVEL

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

NLS_DATE_FORMAT = DD-MON-RR
NLS_DATE_LANGUAGE = AMERICAN

NLS_DATE_FORMAT = RR-MM-DD
NLS_DATE_LANGUAGE = DANISH

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