FND_CP_GSM_OPP_AQTBL has over 9000 records
There are over 9000 records in the FND_CP_GSM_OPP_AQTBL queue. Have tried to stop/restart one of our three OPP CMs, but to no avail. We also have a purge job setup to remove anything older than 7 days.
Oracle Support suggested to follow Doc ID 1156523.1, which suggests to purge the queue or rebuild it.
1. Has anyone encountered this before? If so, what did you do?
2. What negative impacts are there with deleting everything from the queue? Downtime needed?
3. What negative impacts are there with rebuilding the queue? Downtime needed?
This is PROD, so I am wanting minimize impact as much as possible.