ORA-01843: this is not a valid month: Search for Customer using Account in Canadian French

(Doc ID 2221582.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Collections

Advanced Collections - search in Canadian French returns error
When logged in Canadian French language and entering a customer account number in the Account Number field and click 'Search', the error ORA-01843: this is not a valid month occurs . Switch language to American English and  do not get the error.


ORA-01843: ce n'est pas un mois valide


The issue can be reproduced at will with the following steps:

1 . Using Advanced Collections Responsibility, log in using Canadian French

2.  Go to Customer Search

3.  Change Bill to to Account;. Enter the account number (eg: 1100) and click Search.

4.  Receive ORA-01843 error message


The issue has the following business impact:
Due to this issue, users cannot search for account numbers using Canadian French


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