Description:
AQs tables are used to
look for "subscriptions" by FNDSMs. That is, when ICM calls for FNDSM
to start, they "subscribe" to this queue to identify its status. The
time taking for the process cleanup prior to the ICM starting up the regular
CMs is correlated to the number of processes that were not stopped cleanly. In
case of un-clean shutdown, the process to restart will be longer as manager
spends extra cycles to perform housekeeping tasks.
Solution:
A permanent solution is
to schedule a cron job or something which queries records in
APPLSYS.FND_CP_GSM_OPP_AQTBL to monitor it and use DBMS_AQADM.PURGE_QUEUE_TABLE
to purge the table as needed.
The issue has been resolved after we implemented the solution from DOC- How To Purge FND_AQ Tables ( Doc ID 1156523.1 )
The issue has been resolved after we implemented the solution from DOC- How To Purge FND_AQ Tables ( Doc ID 1156523.1 )
Also check
Increase the value of following profiles:
Concurrent:OPP Process Timeout
Concurrent:OPP Response Timeout
Increase the value of following profiles:
Concurrent:OPP Process Timeout
Concurrent:OPP Response Timeout
No comments:
Post a Comment