Run Distribution Process Produces UNIQUE CONSTRAINT Error in ERROR LOG When Inserting Into ELIGIBLE_INVENTORY (Doc ID 1941791.1)

Last updated on MAY 03, 2016

Applies to:

Oracle Retail Warehouse Management System - Version 13.2 to 14.0 [Release 13.2 to 14.0]
Information in this document applies to any platform.

Symptoms

When attempting to run distribution for waves with more than 1000 lines, the following error occurs in the ERROR_LOG table.  Run distribution is creating large number of ORA-00001: unique constraint (.) violated in ERROR_LOG when creating WAVES.

 
Steps to Reproduce:

1. Create a wave with more than 1000 lines (more than the limit set in DE_ELIGIBLE_INVENTORY_FCP).
2. Execute RUN_DISTRIBUTION.
3. Check ERROR_LOG.

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