Item Reclassification Throws "ORA-00001: unique constraint (RMS01.PK_DEAL_ITEM_LOC_EXPLODE_GTT) ..." Error

(Doc ID 2190337.1)

Last updated on OCTOBER 10, 2016

Applies to:

Oracle Retail Merchandising System - Version 14.0.2 and later
Information in this document applies to any platform.


Item Reclassification throws the following error



1. Create a deal with multiple departments. Make sure the record in DEAL_ITEM_LOC_EXPLODE exists.
2. Move an item to another department using Item Reclassification.

Result: Error ORA-00001: unique constraint (RMS01.PK_DEAL_ITEM_LOC_EXPLODE_GTT) violated returned by program unti FUTURE_COST_SQL.MERGE_DEAL.




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