Multithreaded Docclose Batch Aborts With "ORA-00001: unique constraint (RMS12.UK_REV_ORDERS) " Error (Doc ID 1419603.1)

Last updated on JANUARY 07, 2017

Applies to:

Oracle Retail Merchandising System - Version 12.0.1 and later
Information in this document applies to any platform.
Checked for relevance on 07-October-2013
Checked for relevance on 07-Jan-2017

Symptoms

When attempting to run the DOCCLOSE batch in multithreaded mode, it is getting aborted with the following error :

ERROR

docclose_6~20110814191859~close_all_allocs~ALLOC_HEADER~105~RET-0105: generic stored procedure error~INTERNAL STORED FUNCTION ERROR: function=APPT_DOC_CLOSE_SQL.CLOSE_ALL_ALLOCS, error=@0PACKAGE_ERROR@1ORA-00001: unique constraint (RMS12.UK_REV_ORDERS) violated
ORA-06512: at "RMS12.RMS_TABLE_ALH_AIUDR", line 42
ORA-04088: error during execution of trigger 'RMS12.RMS_TABLE_ALH_AIUDR'@2APPT_DOC_CLOSE_SQL.CLOSE_ALL_ALLOCS



Steps To Recreate :

  1. Run DOCCLOSE batch in multithreaded mode.

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