My Oracle Support Banner

'ORA-00001: unique constraint ' Causes Queue Buildups in EJournalImport in ORCO (Doc ID 1523825.1)

Last updated on MARCH 04, 2019

Applies to:

Oracle Retail Central Office - Version 12.0 and later
Information in this document applies to any platform.


In Oracle Retail Central Office (ORCO) , Ejournals get stuck in the EjournalImport queue when the following error is encountered while processing an Ejournal sent from ORPOS.

Steps to Reproduce:

1. Simulate a duplicate key exception for an EJournal Import in ORCO.
2. Observe in Central Office log that multiple attempts are made to save the Ejournal that causes the duplicate key exception, causing a queue build up, thus delaying processing of other Ejournals.




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.