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.

Symptoms

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.

ERROR

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


STEPS

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


BUSINESS IMPACT

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

Cause

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
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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