My Oracle Support Banner

Cannot Find Sales Order Approval Table (Doc ID 2666895.1)

Last updated on MAY 05, 2020

Applies to:

Oracle Order Management - Version 12.2.8 and later
Information in this document applies to any platform.

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

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
Goal
Solution


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