• Post category:Core HR
  • Post comments:0 Comments
  • Post last modified:June 17, 2022
  • Reading time:16 mins read
You are currently viewing How to Purge Person Data from Non-Prod Instances?
How to Purge Person Data from Non-Prod Instances?

We will review the purge process to delete the data from Non-PROD/Test instances.

Pre-Requisites:

User needs to have the Human Capital Management Integration Specialist job role or the “Purge Person Data in Test Environments” functional security privilege added to one of the roles.

Get the list of Person Numbers or Person IDs that must be purged. We can get this information from the Person Management screen or by querying the PER_ALL_PEOPLE_F table.

Navigate to Tools > Scheduled Processes

Click on Schedule New Process

Search for “Purge Person Data in Test Environments” process

image 4 1024x402 - How to Purge Person Data from Non-Prod Instances?

We need to input the parameters for this process.

image 5 - How to Purge Person Data from Non-Prod Instances?

Once we input the Person IDs or Person Numbers or the Person Query, we can click submit and the process will purge the employees from all the tables.

After this process runs to success, we need to run the Send Pending LDAP Requests Process to delete the user accounts. The “Purge Person Data in Test Environments” generates the requests to delete the user accounts but the actual user accounts get deleted only if we run the “Send Pending LDAP Requests” process.

Note: The Purge Person Data process will not purge person data if they have any payrolls processed. We need to roll back the Payroll information first followed by running the purge process.

Here is the complete list of tables from which the purge process deletes the data from:

ProductTable
Absence ManagementANC_PER_ABS_CERTS
Absence ManagementANC_PER_ABS_ENTRIES
Absence ManagementANC_PER_ABS_ENTRY_DTLS
Absence ManagementANC_PER_ABS_MATERNITY
Absence ManagementANC_PER_ABS_PLAN_ENTRIES
Absence ManagementANC_PER_ABS_PLN_SUMM_ENT
Absence ManagementANC_PER_ABS_TYP_LNKG
Absence ManagementANC_PER_ABS_TYPE_ENTRIES
Absence ManagementANC_PER_ACCRUAL_ENTRIES
Absence ManagementANC_PER_ACRL_ENTRY_DTLS
Absence ManagementANC_PER_EVENTS
Absence ManagementANC_PER_PLAN_ENROLLMENT
BenefitsBEN_BATCH_ACTN_ITEM_INFO
BenefitsBEN_BATCH_BNFT_CERT_INFO
BenefitsBEN_BATCH_COMMU_INFO
BenefitsBEN_BATCH_DPNT_INFO
BenefitsBEN_BATCH_ELCTBL_CHC_INFO
BenefitsBEN_BATCH_ELIG_INFO
BenefitsBEN_BATCH_LER_INFO
BenefitsBEN_BATCH_RATE_INFO
BenefitsBEN_BENEFIT_ACTIONS
BenefitsBEN_BENEFIT_RELATIONS_F
BenefitsBEN_CVRD_DPNT_CTFN_PRVDD
BenefitsBEN_ELCTBL_CHC_CTFN
BenefitsBEN_ELIG_CVRD_DPNT
BenefitsBEN_ELIG_DPNT
BenefitsBEN_ELIG_FLX_CRDT_POOL_CHC
BenefitsBEN_ELIG_PER_ELCTBL_CHC
BenefitsBEN_ELIG_PER_F
BenefitsBEN_ELIG_PER_OPT_F
BenefitsBEN_ELIG_RSLT_F
BenefitsBEN_ENRT_BNFT
BenefitsBEN_ENRT_RT
BenefitsBEN_EXTRACT_DETAILS_ARCH
BenefitsBEN_EXTRACT_REQ_DETAILS
BenefitsBEN_FLEX_CRDT_LDGR
BenefitsBEN_PER_BENEFIT_GROUP_F
BenefitsBEN_PER_BNF_ORG
BenefitsBEN_PER_BNFTS_BAL_F
BenefitsBEN_PER_IN_LER
BenefitsBEN_PER_LE_HABITS_COV_F
BenefitsBEN_PERSON_ACTIONS
BenefitsBEN_PIL_ELCTBL_CHC_POPL
BenefitsBEN_PL_BNF
BenefitsBEN_PL_BNF_CTFN_PRVDD
BenefitsBEN_PRTT_ENRT_ACTN
BenefitsBEN_PRTT_ENRT_CTFN_PRVDD
BenefitsBEN_PRTT_ENRT_RSLT
BenefitsBEN_PRTT_LEG_DISCMR_ACTN
BenefitsBEN_PRTT_RT_VAL
BenefitsBEN_PTNL_LER_FOR_PER
BenefitsBEN_REL_ASSIGNMENTS_F
BenefitsBEN_REPORTING
Compensation ManagementCMP_BUDGET_AUDIT
Compensation ManagementCMP_BUDGET_USAGES
Compensation ManagementCMP_CWB_ALERTS
Compensation ManagementCMP_CWB_APPROVAL_HISTORY
Compensation ManagementCMP_CWB_AUDIT
Compensation ManagementCMP_CWB_FEEDBACK
Compensation ManagementCMP_CWB_HRCHY
Compensation ManagementCMP_CWB_INTCPT_APPR_DTLS
Compensation ManagementCMP_CWB_MODEL_B
Compensation ManagementCMP_CWB_MODEL_DTL
Compensation ManagementCMP_CWB_MODEL_TL
Compensation ManagementCMP_CWB_PERF_RATINGS
Compensation ManagementCMP_CWB_PERSON_DEFAULTS
Compensation ManagementCMP_CWB_PERSON_ELEMENTS
Compensation ManagementCMP_CWB_PERSON_INFO
Compensation ManagementCMP_CWB_PERSON_RATES
Compensation ManagementCMP_CWB_POST_LOG
Compensation ManagementCMP_CWB_POST_PERSON
Compensation ManagementCMP_CWB_PROMOTIONS
Compensation ManagementCMP_CWB_RANKS
Compensation ManagementCMP_CWB_SUMMARY
Compensation ManagementCMP_CWB_SWITCH_MANAGERS
Compensation ManagementCMP_DYNAMIC_FILTER
Compensation ManagementCMP_INTERCEPT_APPROVERS
Compensation ManagementCMP_PERSON_BUDGETS
Compensation ManagementCMP_PROCESS_DATA
Compensation ManagementCMP_PROCESS_RUN_INFO
Compensation ManagementCMP_SALARY
Compensation ManagementCMP_SALARY_COMPONENTS
Compensation ManagementCMP_SALARY_EXPORT
Compensation ManagementCMP_STOCK_DETAILS
Compensation ManagementCMP_TCS_PER_ITEM_VALUE
Compensation ManagementCMP_TCS_PER_PERD
Compensation ManagementCMP_TCS_PER_PERD_STMT
Compensation ManagementCMP_TCS_PER_PERD_STMT_CAT
Compensation ManagementCMP_TCS_PER_ROW_VALUES
Compensation ManagementCMP_TCS_REPORT_DETAILS
Compensation ManagementCMP_VC_PER_ELIG_PLANS
Oracle Middleware Extensions for ApplicationsFND_ATTACHED_DOCUMENTS
Oracle Middleware Extensions for ApplicationsFND_DOCUMENTS
Oracle Middleware Extensions for ApplicationsFND_DOCUMENTS_TL
Oracle Middleware Extensions for ApplicationsFND_SESSION_USERS
Workforce ModelingHMO_MODEL_PLAN_DETAILS
Workforce ModelingHMO_MODEL_PLANS_B
Workforce ModelingHMO_MODEL_PLANS_TL
Performance ManagementHRA_EVAL_ITEMS
Performance ManagementHRA_EVAL_PARTICIPANTS
Performance ManagementHRA_EVAL_RATINGS
Performance ManagementHRA_EVAL_ROLE_ACTIONS
Performance ManagementHRA_EVAL_ROLES
Performance ManagementHRA_EVAL_SECTIONS
Performance ManagementHRA_EVAL_STEPS
Performance ManagementHRA_EVALUATIONS
Performance ManagementHRA_CHECK_IN_MEETINGS
Performance ManagementHRA_DISCUSSION_TOPICS
Goal ManagementHRG_GOAL_ACCESS
Goal ManagementHRG_GOAL_ACTIONS
Goal ManagementHRG_GOAL_ALIGNMENTS
Goal ManagementHRG_GOAL_TARGET_OUTCOMES
Goal ManagementHRG_GOALS
Succession ManagementHRM_PLANS
Succession ManagementHRM_PLAN_CANDIDATES
Succession ManagementHRM_PLAN_OWNERS
Talent ReviewHRR_DASHBOARDS
Talent ReviewHRR_MEETINGS
Talent ReviewHRR_MEETING_FACILITATORS
Talent ReviewHRR_MEETING_PARTICIPANTS
Talent ReviewHRR_MEETING_REVIEWEES
QuestionnaireHRQ_QSTN_RESPONSES
QuestionnaireHRQ_QSTNR_PARTICIPANTS
QuestionnaireHRQ_QSTNR_RESPONSES
Profile ManagementHRT_NOTES
Profile ManagementHRT_POOL_MEMBERS
Profile ManagementHRT_POOL_OWNERS
Profile ManagementHRT_PROFILE_INTERESTS
Profile ManagementHRT_PROFILE_ITEMS
Profile ManagementHRT_PROFILE_KEYWORDS
Profile ManagementHRT_PROFILE_MATCH_CRIT
Profile ManagementHRT_PROFILE_RELATIONS
Profile ManagementHRT_PROFILES_B
Profile ManagementHRT_PROFILES_TL
Workforce ManagementHWM_TM_REC
Workforce ManagementHWM_TM_REC_GRP
Workforce ManagementHWM_TM_REC_GRP_SUM
Workforce ManagementHWM_TM_REC_GRP_USAGES
Workforce ManagementHWM_TM_REP_ATRB_USAGES
Workforce PredictionsHWP_ARCH_DATA_MINING_REASONS
Workforce PredictionsHWP_ARCH_DATA_MINING_RESULTS
Workforce PredictionsHWP_DATA_INPUT_VALUES
Workforce PredictionsHWP_DATA_MINING_REASONS
Workforce PredictionsHWP_DATA_MINING_RESULTS
Workforce PredictionsHWP_WHATIF_PRED_DETAILS
Global PayrollPAY_ASSIGNED_PAYROLL
Global PayrollPAY_ASSIGNED_PAYROLLS_DN
Global PayrollPAY_ASSIGNED_PAYROLLS_DN_
Global PayrollPAY_ASSIGNED_PAYROLLS_F
Global PayrollPAY_ASSIGNED_PAYROLLS_F_
Global PayrollPAY_DATES
Global PayrollPAY_DIR_CARD_COMPONENTS_F
Global PayrollPAY_DIR_CARD_COMPONENTS_F_
Global PayrollPAY_DIR_CARDS_F
Global PayrollPAY_DIR_CARDS_F_
Global PayrollPAY_DIR_COMP_DETAILS_F
Global PayrollPAY_DIR_COMP_DETAILS_F_
Global PayrollPAY_DIR_REP_CARD_USAGES_F
Global PayrollPAY_DIR_REP_CARD_USAGES_F_
Global PayrollPAY_DIR_REP_CARDS_F
Global PayrollPAY_DIR_REP_CARDS_F_
Global PayrollPAY_ELEMENT_ENTRIES_F
Global PayrollPAY_ELEMENT_ENTRIES_F_
Global PayrollPAY_ELEMENT_ENTRY_VALUES_F
Global PayrollPAY_ELEMENT_ENTRY_VALUES_F_
Global PayrollPAY_ENTRY_PCT_DIST
Global PayrollPAY_ENTRY_PROC_DETAILS
Global PayrollPAY_ENTRY_USAGES
Global PayrollPAY_PAY_RELATIONSHIPS_DN
Global PayrollPAY_PAY_RELATIONSHIPS_F
Global PayrollPAY_PERSON_PAY_METHODS_F_
Global PayrollPAY_RANGE_ITEMS_F
Global PayrollPAY_RANGE_ITEMS_F_
Global PayrollPAY_REL_GROUPS_DN
Global PayrollPAY_REL_GROUPS_F
Global PayrollPAY_RETRO_ENTRIES
Global PayrollPAY_VALUE_DEFINITIONS_F
Global PayrollPAY_VALUE_DEFINITIONS_F_
Global Human ResourcesHR_DOCUMENT_DELIVERY_PREFS
Global Human ResourcesHR_DOCUMENTS_OF_RECORD
Global Human ResourcesPER_ABSENCE_CASES
Global Human ResourcesPER_ACTION_OCCURRENCES
Global Human ResourcesPER_ADDRESSES_F
Global Human ResourcesPER_ALL_ASSIGNMENTS_M
Global Human ResourcesPER_ALL_PEOPLE_F
Global Human ResourcesPER_ALLOCATED_CHECKLISTS
Global Human ResourcesPER_ALLOCATED_TASKS
Global Human ResourcesPER_ASG_RESPONSIBILITIES
Global Human ResourcesPER_ASSIGN_GRADE_STEPS_F
Global Human ResourcesPER_ASSIGN_WORK_MEASURES_F
Global Human ResourcesPER_ASSIGNMENT_EXTRA_INFO_M
Global Human ResourcesPER_ASSIGNMENT_SUPERVISORS_F
Global Human ResourcesPER_CITIZENSHIPS
Global Human ResourcesPER_CONTACT_EXTRA_INFO_F
Global Human ResourcesPER_CONTACT_RELSHIPS_F
Global Human ResourcesPER_CONTRACTS_F
Global Human ResourcesPER_DELEGATED_ROLES
Global Human ResourcesPER_DISABILITIES_F
Global Human ResourcesPER_DRIVERS_LICENSE_TYPES
Global Human ResourcesPER_DRIVERS_LICENSES
Global Human ResourcesPER_EMAIL_ADDRESSES
Global Human ResourcesPER_ETHNICITIES
Global Human ResourcesPER_IMAGES
Global Human ResourcesPER_KEYWORDS
Global Human ResourcesPER_LDAP_REQUESTS
Global Human ResourcesPER_LDAP_ROLE_MEMBERSHIPS
Global Human ResourcesPER_LDAP_USERS
Global Human ResourcesPER_MANAGER_HRCHY_DN
Global Human ResourcesPER_NATIONAL_IDENTIFIERS
Global Human ResourcesPER_PASSPORTS
Global Human ResourcesPER_PEOPLE_EXTRA_INFO_F
Global Human ResourcesPER_PEOPLE_LEGISLATIVE_F
Global Human ResourcesPER_PERIODS_OF_SERVICE
Global Human ResourcesPER_PERSON_ADDR_USAGES_F
Global Human ResourcesPER_PERSON_DLVRY_METHODS
Global Human ResourcesPER_PERSON_NAMES_F
Global Human ResourcesPER_PERSON_TYPE_USAGES_M
Global Human ResourcesPER_PERSONS
Global Human ResourcesPER_PHONES
Global Human ResourcesPER_PORTRAIT_CARD_CONFIG
Global Human ResourcesPER_PORTRAIT_PREFERENCES
Global Human ResourcesPER_RELIGIONS
Global Human ResourcesPER_SCHEDULE_ASSIGNMENTS
Global Human ResourcesPER_SHARE_INFORMATION
Global Human ResourcesPER_USER_HISTORY
Global Human ResourcesPER_USER_ROLES
Global Human ResourcesPER_USERS
Global Human ResourcesPER_VISAS_PERMITS_F
If you like the content, please follow us on LinkedInFacebook, and Twitter to get updated with the latest content.