Item Reclassification Throws "ORA-00001: unique constraint (RMS01.PK_DEAL_ITEM_LOC_EXPLODE_GTT) ..." Error
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