My Oracle Support Banner

DC Tool Throws 'ORA Error @0PACKAGE_ERROR@1ORA-02266' For Purge_Table Operation (Doc ID 2759392.1)

Last updated on MARCH 11, 2021

Applies to:

Oracle Retail Merchandising Foundation Cloud Service - Version NA and later
Information in this document applies to any platform.

Goal

While trying to purge/truncate RMS tables as part of data conversion, the DC task is throwing the below same error for multiple table purging (tables: rms01.ITEM_SUPP_COUNTRY, rms01.ITEM_SUPPLIER, rms01.ITEM_MASTER):

Error; @0PACKAGE_ERROR@1ORA-02266: unique/primary keys in table referenced by enabled foreign keys@2DC_TASK_PURGE_MERCH_TABLE

Steps to Reproduce:
1. Login to DC tool.
2. System Administrator.
3. Task.
4. Purge_Table: rms01.Item_supp_country
5. Notice the error.

Solution

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