Trying to find the list of sickness absences updated between fromdate and todate

Summary:

Trying to get list of sickness absences updated between fromdate and todate report parameters.

Example say there is an existing absence of 01-Sep-24 to 02-SEP-24.

I create an absence on 04-SEP-24 then the system is creating the new absence with the correct creation date/created by in WHO columns but its also updating the Last_update_date as its re-evaluting old absence.

Found a note which talks about this but the note is talking about future records 2797415.1. The issue I am facing is for the records in past.

Checking through the anc_per_abs_entries table and noticed that Oracle is updating the previous record and putting the current timestamp