MTL_EAM_ASSET_ACTIVITIES Not Updating Last_update_date When The Record Is Updated In The Database
Last updated on JANUARY 30, 2018
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.
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