Field 'Last_update_date' Is Set To Incorrect Value When Import Items or INCOIN is Run
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.
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.
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.
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