Run Distribution Process Produces UNIQUE CONSTRAINT Error in ERROR LOG When Inserting Into ELIGIBLE_INVENTORY
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.
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.
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