ORA-02292 Integrity Constraint Error Occurs When Deleting Item Supplier on Item Supplier Screen

(Doc ID 2111554.1)

Last updated on MARCH 02, 2016

Applies to:

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


When attempting to delete a supplier for an item having supplier level fiscal attributes set up, the following error occurs on the item-supplier [itemsupp] screen:

Steps to Reproduce:

  1. Create a new item and associate two suppliers.
  2. Set up supplier level fiscal attributes: item/supplier should have data in ITEM_SUPPLIER_L10N_EXT table.
  3. Attempt to delete the non-primary supplier on the item-supplier screen.
  4. Press OK and note the error.


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