My Oracle Support Banner

Error In Queues During Expdp / Export in 19c Database component 'EXPORT_RULE_SET' must be declared (Doc ID 2757540.1)

Last updated on MARCH 09, 2021

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

Error while executing expdp

22-JAN-21 23:41:17.389: Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/INDEX
22-JAN-21 23:41:20.826: ORA-39127: unexpected error from call to BEGIN :1 :=SYS.DBMS_EXPORT_EXTENSION.POST_TABLES(:2,:3); END; USING AR, AR_REV_REC_QT
ORA-06550: line 1, column 43:
PLS-00302: component 'EXPORT_RULE_SET' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_SQL", line 1707
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 79
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 150
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 10953
22-JAN-21 23:41:20.826: ORA-39127: unexpected error from call to BEGIN :1 :=SYS.DBMS_EXPORT_EXTENSION.POST_TABLES(:2,:3); END; USING OSM, AS_MC_SALES_CREDITS_DEN

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
Cause
Solution
 
SQL> conn / as sysdba
SQL> drop table okc.aq$_okc_aq_ev_tab_r;
SQL> drop table xnp.aq$_xnp_out_msg_qtab_r;
SQL> delete from sys.expact$ where func_package = 'DBMS_RULE_ADM' or func_package = 'DBMS_RULE_EXIMP';
SQL> commit;
References


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