My Oracle Support Banner

ORA-01843: this is not a valid month: Search for Customer using Account in Canadian French (Doc ID 2221582.1)

Last updated on FEBRUARY 03, 2019

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.