My Oracle Support Banner

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

Last updated on NOVEMBER 28, 2018

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


When attempting to run the DOCCLOSE batch in multithreaded mode, it is getting aborted with the following 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.


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.