Field 'Last_update_date' Is Set To Incorrect Value When Import Items or INCOIN is Run (Doc ID 1302343.1)

Last updated on MARCH 16, 2016

Applies to:

Oracle Item Master - Version 12.0.4 to 12.0.4 [Release 12]
Information in this document applies to any platform.

Symptoms

 
When insert records into mtl_system_items_interface and run the Item Import after some time, the data populated in MTL_SYSTEM_ITEMS_B has creation_date like the date when the records were inserted into mtl_system_items_interface, instead of the date/time when INCOIN (Import Items) is run.

Steps To Reproduce:

1) Insert records into mtl_system_items_interface. (Eg: on date '01-JAN-2011')
2) Run Import Items after some time. (Eg: on '02-JAN-2011')
3) The creation_date of the item in MTL_SYSTEM_ITEMS_B will be '01-JAN-2011' which is creation date for interface table.

Expected Behavior:

The creation_date and last_update_date should be the date and time when the Import Items program is run and not the date/time when the record was inserted into the mtl_system_items_interface table.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms