Cannot Find Sales Order Approval Table (Doc ID 2666895.1)

Last updated on SEPTEMBER 20, 2021

Applies to:

Goal

Qn1:

I want to make a customized report based on the sales order approval management (action history),
can you provide me with the table that contains this information ?
 
Qn2:

Our requirement is that we are developing a custom report to monitor the pending orders for approval
and to show each order which is pending on which user for the orders with status pending for internal approval.
We did a lot of search on Oracle tables to show this information but we couldn't find such a table.

Is there any way to show the orders pending or approved in a customized report ?

The customer wants to see in a report the status of the order ( who has approved, who took action, who delegated, etc..)

Is there a table similar to po_Action_history table, but for sales orders ?
 

Solution

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