E1: 08: F08042 History table does not store timestamp (Doc ID 1676646.1)

Last updated on NOVEMBER 30, 2015

Applies to:

JD Edwards EnterpriseOne Human Resources Management - Version 9.0 and later
Information in this document applies to any platform.

Symptoms

Users will incorrectly let today's date default into their changes, then when they discover they used the wrong effective date, have gone in and changed the record again with the correct effective date. When another user reviews the history P050242 Employee History Inquiry or runs the R080423 Employee History Inquiry report it is very confusing since it cannot be determined which change went in first.  

The sequence is meant to differentiate if the same data item is changed twice with the same effective date.  There is a Date Updated audit field but no time (or a UKID).  The real order if done on the same Date Updated could not be determined.

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