How To Create Missing View for ASO.AQ$ASO_ORDER_FEEDBACK_T? (Doc ID 2052670.1)

Last updated on MARCH 17, 2017

Applies to:

Oracle Quoting - Version 12.2.3 and later
Information in this document applies to any platform.
aso.aq$aso_order_feedback_t
aso_order_feedback_t
aso_queue_v
ORA-00942: table or view does not exist

Goal

How to create missing view for aq$aso_order_feedback_t ?

 ASO_ORDER_FEEDBACK_T is the table which holds the complete information about the sales order.

View aq$aso_order_feedback_t no longer exists in 12.2.x environments. This view will be helpful to check the status of ASO queue data by message state.
Development is investigating why this view is missing in 12.2.x. Until such time, it is recommended to create a different view as a workaround.

 

Solution

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