Old Password Reset Request records disappear or cannot be found due to system automatic clean up

Issue

Password Reset Request records more than three months old are no longer in the instance and cannot be found anywhere. This has caused confusion as to why these records were gone and where they went because Password Reset Request records contained user data.

Cause

Instances by default have an auto flush function activated for table pwd_reset_request and pwd_reset_activity. Table pwd_reset_request and pwd_reset_activity contain the records for Password Reset Requests and Password Reset Activity history. These auto flush configurations are in the table sys_auto_flush. By default, the auto flush function would automatically delete the records older than 90 days in these two tables.

Solution

If you don't want to delete any Password Reset history records, you can find the related records in table sys_auto_flush and disable them to stop the automatic clean up. You can also change the field Age in seconds from the default 7,776,000 seconds (90 days) to a longer period to keep more records.