My Oracle Support Banner

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

Last updated on APRIL 13, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.