Is there any way to set the created by and last updated by fields on the Sales Order to be a different user than the person who ran the Order Import? (Doc ID 2474341.1)

Last updated on APRIL 27, 2021

Applies to:

Goal

On : 12.2.5 version, Transaction Entry

Pass CREATED BY and LAST UPDATED BY through the Order Import interface

When populating OE_HEADERS_IFACE_ALL and OE_LINES_IFACE_ALL, I can put a USER ID in the created_by and last_updated_by fields.
However, when I then run the ORDER IMPORT, the Sales Order created always shows the created by and last updated by as the User who ran the Order Import.

It is important for us to be able to see which user populated the OE_HEADERS_IFACE_ALL and OE_LINES_IFACE_ALL tables to create the Sales Order.

For example, we have a scheduled concurrent program that is run under ORACLE1, and it looks for sales order input data files in a directory, and creates a sales order for each one by populating the interface tables, and calling Order Import.
Currently EVERY Sales Order created this way shows ORACLE1 as the created by and last updated by.
We need to have the user that created the input file be the created by and last updated by for the Sales Order that ends up getting created (do this by having the user populate a USERNAME field in the input file).
 

Solution

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