Everything You’ve Ever Wanted to Know About HR Date-Tracking in Oracle EBS

Shannon MiskevicsOracle, Technical TipsLeave a Comment


Date-tracking is an original function through Oracle E-Business Suite (EBS) Human Capital Management (HCM). This function allows companies to edit their employees’ information and create continuity between different records. Date-tracking is an important function in EBS HCM, especially when it comes to changing employee person status, job position, etc.

Correction and Update

For this example, Jim Jones started as a Sales Consultant.
To change information after it is entered so that instead Jim is married, use the correction function. When correcting an entry, it overrides the previous record with the error and replaces it with the new information. Therefore now it is shown as:
Jim started at the company as a Sales Consultant on May 14, 2008. In Oracle EBS HCM, date-tracked items that need multiple line items are marked with an end-date of December 31, 4712 (End of Time). So far only one entry was created.
If Jim Jones is promoted to a new position, as seen above, by creating the new entry with the start-date, it automatically updates the previous record with the correct end date. The end date of this new position will change to the Oracle end of time date. This is the update function. It allows creation of a new entry without erasing the valid previous entry.


When date-tracking in between two schedule records using insert, enter the new employee information before the next scheduled change. This keeps all information before and after, and allows for the addition of information that was forgotten. The dates in the table adjust accordingly with the newly inserted information. The table below shows that a position was inserted between Jim’s jobs as Sales Consultant and Sales Manager.

Delete Options

There are several delete options in Oracle: delete next, delete all, or purge. The delete options depend on when users are date-tracked.
In order to delete the Interim Sales Manager record when date-tracked to June 12, 2008, hit the remove next change option and the resulting table will be:
When date-tracked to the same date and the user needs to perform the remove all scheduled changes option, it leaves only the first record as shown below:
By using the purge function, all information pertaining to the existing record is deleted, regardless of the date-track. The record would no longer exist in the database. If the user is date-tracked to the last record in the table, the only option is purge.

Leave a Reply

Your email address will not be published. Required fields are marked *