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