Purge Contacts With Date Range Not Working Gets Ora-01843 Error

(Doc ID 849633.1)

Last updated on JUNE 05, 2012

Applies to:

Oracle Trading Community - Version 12.0.4 and later
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

Attempting to Purge parties and receive the following error:

ERROR
ORA-01843: not a valid month

Responsibility:  Customers Online Data Librarian Superuser
Navigation:  Data Quality Tab > Purge Requests > Purge Request
Select Parties to Purge by: Party Attributes
Party Type: Person
From Creation Date: 03/14/2009 (accepted from calendar widget)
To Creation Date: 03/14/2009 (accepted from calendar widget)
Click on Details
No parties selected
Reviewing the log, finished with errors.

Cause

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