My Oracle Support Banner

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 AUGUST 16, 2023

Applies to:

Oracle Health Insurance Enterprise Policy Administration - Version and later
Generic Linux



Oracle Health Insurance applications - Version 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.