Discoverer Viewer Date Parameter Input Fails With Error ORA-01843: invalid month (Doc ID 1909370.1)

Last updated on SEPTEMBER 27, 2016

Applies to:

Oracle Discoverer - Version 10.1.2.0.2 and later
Information in this document applies to any platform.

Symptoms

When running reports with parameters on Date items in Discoverer Viewer some users get an error message after typing a value for the Date parameter:


This error occurs for users who runs Discoverer with  the locale: Chinese(China)

The error does not occur for users who runs Discoverer with the locale: English(United States).

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