Email ID in PER_LDAP_USERS is getting end dated for some individuals
Summary:
From our understanding, the Email ID in Security Console comes from PER_LDAP_USERS. Also, as per our understanding, the latest record in PER_LDAP_USERS is found by referencing PER_USER_HISTORY.
But we found that for many users we have found that the latest record in PER_USER_HISTORY points to a row in PER_LDAP_USERS where the email ID has been removed. Older rows will have the email ID, but the latest row has email ID field as blank.
Any thoughts on what we are doing wrong here? Thanks in advance for any direction that can be provided in this case.