Why does PSOPRALIAS have data that is missing from PSOPRDEFN?
We found that we have several OPRID's that have been removed from PSOPRDEFN but still has a row in PSOPRALIAS. When we make a user profile change the message "Warning -- EMPLID = 'XXXXXX' assigned to another User ID." There is no other user profile on the User Profile page for the employee but the row in PSOPRALIAS is causing the message.
Does anyone know why or how the orphan rows are not being deleted?
To cleanup these records I found that the data also exists in PSUSERATTR and PSUSEREMAIL. Are there any other records that the data could be stored? I did check PSUSERPRSNLOPTN, PS_ROLEXLATOPR, and PS_RTE_CNTL_RUSER as well, these didn't have any data for the OPRD. I can't use the delete user id process because the OPRID isn't returned when searching.