This may seem like a rather basic question, but as someone new to HRMS I would appreciate your advice.

One of our users wishes to update supervisor information on the assignment record. However we can't seem to find a way of achieving this for all records fromn a particular point in time. There have been a number of date track changes to the records and it seems that the only way to achieve this is to date track, go into each record, change, date track etc. I know this could be done through something like TOAD quite easily but we want the user to be able to achieve it. Any ideas?

Hello Gareth, and welcome to the forum.

Ah, yes, the date-track update mode that never was, but should have been - "Update into the future until the value we're changing becomes something else".

Sadly, the correction of all the date-tracked rows is the only way of doing it via the assignment screen, as far as I know. I have had painful, first-hand experience of this myself recently.

The only other way of doing it would be to write a bit of pl/sql to do this, and have it set up as a concurrent program. Obviously you can make it reasonably dynamic, to the extent that the supplied parameters could include the specific column name that wants to be changed, as well as the old and new values and the date from which this change is to be rippled forwards. And in anticipation of your next question, no I don't have such a script!

You can also use employee assignment mass update. This will let you select all assignments according to a set of criteria, and then update selected assignments within the result set with required values -- including changing the supervisor.

You may need to run it a few times --
once for assignments with no changes after the effective date - Update,
once for assignments with changes after the effective date, where the future dated change can be overwritten - Update Rplace,
and once (or more times) for assignments with changes after the effective date, where the future dated change must be retained - Update Insert possibly followed by a number of Corrections on future dated assignments.

Thanks for your responses folks