Effective Dates add the dimension of time to the Oracle HR application. The Effective Date enables you to change your view of the information forward or backward in time to see how the information has changed.
If you query employee information in Oracle HR with your effective date set to today you may get a different result than if you query the same employee with the effective date set to one year ago. The employee could have had any number of changes, for example Last Name, Marital Status, Title.
The Effective Date also enables you to create records backward or forward in time (you can determine when these changes take effect from).
Within Employee Wizard there is an Effective Date set on the ribbon. The Effective Date will default to ‘Today’, which you can change by using the calendar button or selecting a previously used session value from the dropdown list.
The Effective Date on the ribbon affects the List of Values available in the Employee Form. Values will only be listed if they are valid as at the Effective Date.
The Effective Date on the ribbon also affects the records that are downloaded into the worksheet. Employee and Assignment information will be downloaded as at the Effective Date on the ribbon.
The Effective Date on the ribbon is also used in most update modes to avoid the 'ORA-20000: hr_person_api.update_person returned: DateTrack update not allowed for a record which started today' error. The only exception to this is in the Applicant Mode, when converting Ex Employees/Cont Workers to Applicants the Date Received, if populated in the Wizard is applied.
The ribbon effective date can be used against a single record, a selection of records or all records on the current sheet. Note: The ribbon effective date can only apply the one set date to multiple records. To apply different effective dates to multiple records, please refer to sectionBulk Upload Records with different Effective Dates
