My Oracle Support Banner

MTL_EAM_ASSET_ACTIVITIES Not Updating Last_update_date When The Record Is Updated In The Database (Doc ID 2354945.1)

Last updated on MARCH 27, 2019

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, PM

There was a work order that was updated that was part of a PM. The user logged in on 11/8/2017 and filled out the actual start and end dates. They put in a start of 11/7/2017 18:00 and an end of 11/7/2017 19:30.

this updated in the table appropriately for the last_service_date and last_end date but the last_updated_date, a core field on every oracle table, did not get updated and still shows a date of 1/3/2015 1:29:53 PM. This broke a downstream process for us, and shouldn't the last_update_date get updated when a record is updated in the database

last_updated_date should be updated.


To view full details, sign in with your My Oracle Support account.

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

In this Document

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