Item/Location Ranging Fails with ORA-00001 Error when the Supplier Has Bracket Costing
(Doc ID 2736824.1)
Last updated on DECEMBER 29, 2020
Applies to:Oracle Retail Merchandising System - Version 16.0.3 and later
Information in this document applies to any platform.
Getting below error when try to range the item when Supplier has Bracket Costing.
"Error ORA-00001: unique constraint (RMS01.UK_ITEM_SUPP_COUNTRY_BRAC_COST) violated returned by program unit NEW_ITEM_LOC_SQL.PERSIST_ITEM_SUPP_COUNTRY_LOC."
Steps to Recreate
1. Setup bracket costing for multiple warehouses for a supplier with INV_MGMT_LVL = 'L'
2. Create items for the supplier and approve them.
3. Edit the same item and range item to a warehouse other than the warehouse set up in #1.
4. Note the ORA-00001 error.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document