Multithreaded Docclose Batch Aborts With "ORA-00001: unique constraint (RMS12.UK_REV_ORDERS) " Error
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
When attempting to run the DOCCLOSE batch in multithreaded mode, it is getting aborted with the following error :
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 :
- Run DOCCLOSE batch in multithreaded mode.
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