ORA-24067: exceeded maximum number of subscribers for queue APPLSYS.FND_CP_GSM_OPP_AQ
ISSUE:XML reports complete in warning
Solution:
select count(*) from
applsys.FND_CP_GSM_OPP_AQTBL;
create table
applsys.FND_CP_GSM_OPP_AQTBL_bkp2 as select * from
applsys.FND_CP_GSM_OPP_AQTBL;
exec
dbms_aqadm.purge_queue_table('FND_CP_GSM_OPP_AQTBL', null, null);
select count(*) from
applsys.FND_CP_GSM_OPP_AQTBL ;
sqlplus
username/passwd @$FND_TOP/patch/115/sql/afopp002.sql
No comments:
Post a Comment