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

Last updated on JUNE 14, 2016

Applies to:

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

Symptoms

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.

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