My Oracle Support Banner

FA: SCM: OM: SQL Query to Obtain Creation and Last Updated by (WHO) information on Order Headers, Order Lines and Fulfillment Lines. (Doc ID 2654838.1)

Last updated on OCTOBER 12, 2020

Applies to:

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


It is not possible to review who created or last updated an Order Line. Many forms in Fusion applications show this information under the option View -> About This Record. The form that is used to enter and query order lines does not allow users to view this information.


Order Headers - this data can be reviewed from - Manage Orders
Fulfillment Lines - this data can be reviewed from - Manage Fulfillment Lines
Order Lines - the following SQL will show this information  and provides details on:

1. Order Headers
2. Order Lines
3. Fulfillment Lines


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

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