Home > Oracle Apps > FND_CP_GSM_OPP_AQ is INVALID after applying a patch

FND_CP_GSM_OPP_AQ is INVALID after applying a patch

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.

-Anand

Advertisements
Categories: Oracle Apps
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: