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|