State of the Messages in Oracle AQ Are Not Changed from WAITING to READY After the Delay Expires
(Doc ID 2846311.1)
Last updated on FEBRUARY 01, 2022
Applies to:Oracle Health Insurance Enterprise Policy Administration - Version 184.108.40.206.0 and later
Oracle Health Insurance applications - Version 220.127.116.11.0 and later
Information in this document applies to any platform with Oracle RAC database configuration.
Oracle Health Insurance applications use Oracle AQ for asynchronous task processing.
In some use cases (eg: data replication in claims and connector configuration in policies), the message is enqueued to AQ with a delay.
After the delay expires, the state of the message should be ready to be consumed.
However the dequeue call did not dequeue those messages because the state of the message in OHI_TASK_QUEUE_TABLE is still 1 (WAITING) even after the delay expires.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document