My Oracle Support Banner

Purge Contacts With Date Range Not Working. Error Ora-01843 Occurs. (Doc ID 849633.1)

Last updated on DECEMBER 04, 2019

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.


Attempting to Purge parties and receive the following 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.




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

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