ERROR at line 1:What is the status of FND_CP_GSM_OPP_AQ?
ORA-20000: Oracle Error Mkr1= -24018 - ORA-24018: STOP_QUEUE on
APPLSYS.FND_CP_GSM_OPP_AQ failed, outstanding transactions found
ORA-06512: at line 15
I even tried restarting the worker,bounced the database and even tried running u03/oracle/CRP1PROD/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/afopp002.sql manually which hangs for indefinitely.Are you running the script as applsys user? -- FND_CP_GSM_OPP_AQ Queue is Invalidated After Patching [ID 311851.1]