Tips & Techniques: Finding User who Entered / booked Sales Order
Please also refer to published by the same author
You may want to know the User who entered, booked or performed other actions on Sales order. below are some options.
- If finding the user is occasional, an SQL Query will meet the requirement
For details of creation / Update, dates and who did so, each table in Oracle has the following information:
| Column | Type | Required | Details |
CREATION_DATE | DATE | Yes | Standard Who column |
CREATED_BY | NUMBER | Yes | Standard Who column |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column |
The above tables / columns for Sales Orders are available in the table OE-ORDER_HEADERS_ALL, which can be used to Query and know who created/entered the order.
Tagged:
0