Human Capital Management - EBS (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center