My Oracle Support Banner

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.

Symptoms

Getting below error when try to range the item when Supplier has Bracket Costing.

Error

"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.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.