Today after applying a patch in Production environment, one of the queues “FND_CP_GSM_OPP_AQ” got invalid
I tried to recompile this using below command but got ‘Invalid Alter command’ error.
SQL> alter queue FND_CP_GSM_OPP_AQ compile; alter queue FND_CP_GSM_OPP_AQ compile * ERROR at line 1: ORA-00940: invalid ALTER command
I searched over the Metalink and found one note (311851.1) related to compiling INVALID queue object. As per Metalink Note
“If the OPP service is running and there are messages in FND_CP_GSM_OPP_AQ queue, applying patches will invalidate this queue. The patch/patches internally validate and compile the schema making the data in the queue to be inconsistent”
Solution is to recreate the queue using $FND_TOP/patch/115/sql/afopp002.sql file as ‘APPLSYS’ user
I ran the said script and it resolved my INVALID queue issue.