How To Determine What Process/Program Is Updating An Item Attribute (Doc ID 2822816.1)

Last updated on NOVEMBER 29, 2021

Applies to:

Goal

An item attribute is getting set to NULL when it previously had a value.
This happens for other items as well and always seems to occur on the weekend.

The item is queried in the Item Define form and Tools > About this Record is used to review the record details.
It shows the following:

Create By: (appears to be a legitimate user name)
Creation Date: 11-JAN-2021
Table Name: MTL_SYSTEM_ITEMS_FVL
Update By: AUTOINSTALL
Update Date: 29-MAY-2021 05:03:05

The following query is run and returns a value of 1:

select user_id from fnd_user where user_name = 'AUTOINSTALL';

Is there way to find out what process is causing these updates?

Solution

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