31 December 2014

ORA-24067: exceeded maximum number of subscribers for queue APPLSYS.FND_CP_GSM_OPP_AQ


ORA-24067: exceeded maximum number of subscribers for queue APPLSYS.FND_CP_GSM_OPP_AQ

ORA-06512: at "APPS.FND_CP_OPP_IPC", line 346

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

exec fnd_cp_opp_ipc.remove_all_subscribers();