Person data removal tool retention period
Hopefully i have posted this in the correct forum now. (
Constraint PER_500064_EMP_RTNTN_PRD uses package PER_DRT_PKG. We have set our retention period to 24 as per the attached screen shot however the system is picking 72 from table hr_organization_information instead of our site level setting. We cant find where 72 is set, is this a bug or please explain how to set the hr_organization_information to 24.
Code from PER_DRT_PKG.per_hr_drc
SELECT count (*) INTO l_count
FROM per_periods_of_service pps
,hr_organization_information hoi
WHERE pps.person_id = p_person_id