Need Help Processing ASO Feedback Queue Messages For 'OZF'

(Doc ID 317320.1)

Last updated on SEPTEMBER 06, 2017

Applies to:

Oracle Trade Management - Version 11.5.10.1 and later
Information in this document applies to any platform.
***Checked for relevance on 30-Oct-2014***


Symptoms

Currently there are about half million records (messages) for OZF in ASO_ORDER_FEEDBACK_T (Queue table).

SQL> select consumer_name, msg_state, count(*) from aso.aq$aso_order_feedback_t group by consumer_name, msg_state;

result: 1 row: => OZF READY 494567

Customer installed OZF and is looking for a way to process these messages by OZF (Oracle Trade Management) module.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms