ORA-01843: this is not a valid month: Search for Customer using Account in Canadian French
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