My Oracle Support Banner

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

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

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