My Oracle Support Banner

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

Last updated on JUNE 12, 2021

Applies to:

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


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.


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

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