Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Fusion Blog
  • Register

Oracle Gold Partners, our very popular training packages, training schedule is listed here
Designed by Five Star Rated Oracle Press Authors & Oracle ACE's.

webinar new

Search Courses

Introduction

Many a times we have to create some sample data into the application either for Client Demo (CRP) or even for sanity testing (to check that basic application works as expected) after any major upgrade or patching activity. We do create dummy employees for such purposes. However, once the purpose is served there might be a need to ensure such records are completely removed from the system.

This kind of functionality is only available in Non-Production Environments only and until release 11 this was achieved by a Diagnostic Test named ‘HCM Delete Object’ (do refer article here for complete details).Starting Release 11 there is a new diagnostic test ‘Purge Person’ which is enabled into Test and Stage Environments post you raise an explicit Service Request in My Oracle Support (MOS). 

Until release 13 18b Oracle advised to use “Purge Person” diagnostic test (read complete article here ) but now that option has been removed and the new option is “Purge Person Data from Test Environments” . As the name suggests this Schedule process is only available in Non-Prod environments and before one can use this feature one would need to enable the same in the SaaS environment. This topic explains how to enable the process and identifies the data that it purges.

Enabling the Purge Process for Person Data

To use the Purge Person Data in Test Environments process, you must raise a service request (SR). In response, Oracle Support supplies a key to enable the process. When you have the key, which is specific to your environment, follow these steps:

  1. In the Setup and Maintenance work area, go to the following for your offering:
    • Functional Area: HCM Data Loader
    • Task: Configure HCM Data Loader
  2. On the Configure HCM Data Loader page, enter the key from Oracle Support in the Value field for the Purge Person Enabled Key parameter.
  3. Click Save and Close.

 

We can now run the Purge Person Data in Test Environments process.

Purging Person Data

The Purge Person Data in Test Environments process purges person records, including passports, citizenship records, licenses, emails, addresses, national identifiers, and extra information type data. It also purges dependent data of the following types:

  • Absences
  • Assignments, including extra information type data
  • Benefits
  • Calculation cards
  • Compensation
  • Contacts and contact relationships
  • Documents and attachments
  • Element entries
  • Goals
  • Payroll relationships
  • Performance records
  • Roles and user details
  • Talent profiles
  • Work relationships

Deletion requests are generated for user accounts in the test environment. To process these requests, you must run the Send Pending LDAP Requests process when Purge Person Data in Test Environments completes.

Exclusions from the Purge Process

The Purge Person Data in Test Environments process doesn't purge data of the following types:

  • Predefined person data.
  • Person data that was loaded using HCM File-Based Loader.
  • Oracle Trading Community Architecture (TCA) data.

The process inactivates dependent TCA records in the TCA tables but doesn't purge them.If processed payroll actions are associated with a worker, then the worker isn't purged. You must roll back relevant payroll processes before you can purge such workers.

Run the Purge Person Data in Test Environments Process

You must have the Purge Person Data in Test Environments function security privilege to run this process. The predefined Human Capital Management Integration Specialist job role has this privilege.

Sign in and follow these steps:

  • Select Navigator > Tools > Scheduled Processes.
  • In the Scheduled Processes work area, click Schedule New Process.
  • In the Schedule New Process dialog box, search for and select the Purge Person Data in Test Environments process.
  • In the Process Details dialog box, set one of the following parameters to identify the person data to purge.

 

Parameter

Description

Example

Person ID

Provide one or more person IDs. Separate multiple IDs with commas. 

100010034148157,100010034148169,100010034148181,100010034148192.

Person Number

Provide one or more person numbers. Separate multiple numbers with commas. You can use the wildcard character to supply partial values.

PER%,Test%,%abc%.

Person Query

Enter a SQL query to return the person IDs of all persons whose data you want to purge.

To return the person IDs of all person records where the last name starts with the characters John, you could use the following SQL query:

SELECT papf.person_id FROM per_all_people_f papf, per_person_names_f ppnf WHERE ppnf.last_name like 'John%' and ppnf.person_id = papf.person_id






Set the Save parameter, as follows.

Save Value

Description

N

Lists the persons whose data would be purged by the process. No data is purged.

Y

Purges the person data.

Run the Send Pending LDAP Requests Process

Purge Person Data in Test Environments generates requests to delete user accounts from your LDAP directory. To process these requests, run the Send Pending LDAP Requests process. If this process isn't scheduled to run in the test environment, then follow these steps when Purge Person Data in Test Environments completes:

  • In the Scheduled Processes work area, click Schedule New Process.
  • In the Schedule New Process dialog box, search for and select the Send Pending LDAP Requests process.
  • In the Process Details dialog box:
    • Set User Type to All.
    • Leave Batch Size set to A, which means that the processing batch size is calculated automatically.
  • Click Submit.

Tables Purged by the Purge Person Data in Test Environments Process

Whenever we run the “Purge Person Data from Test Environments” schedule process data gets deleted from lot many tables. The complete list is mentioned below for ready reference:

Product

Tables

Absence Management

  • ANC_PER_ABS_CERTS
  • ANC_PER_ABS_ENTRIES
  • ANC_PER_ABS_ENTRY_DTLS
  • ANC_PER_ABS_MATERNITY
  • ANC_PER_ABS_PLAN_ENTRIES
  • ANC_PER_ABS_PLN_SUMM_ENT
  • ANC_PER_ABS_TYP_LNKG
  • ANC_PER_ABS_TYPE_ENTRIES
  • ANC_PER_ACCRUAL_ENTRIES
  • ANC_PER_ACRL_ENTRY_DTLS
  • ANC_PER_EVENTS
  • ANC_PER_PLAN_ENROLLMENT

Benefits

  • BEN_BATCH_ACTN_ITEM_INFO
  • BEN_BATCH_BNFT_CERT_INFO
  • BEN_BATCH_COMMU_INFO
  • BEN_BATCH_DPNT_INFO
  • BEN_BATCH_ELCTBL_CHC_INFO
  • BEN_BATCH_ELIG_INFO
  • BEN_BATCH_LER_INFO
  • BEN_BATCH_RATE_INFO
  • BEN_BENEFIT_ACTIONS
  • BEN_BENEFIT_RELATIONS_F
  • BEN_CVRD_DPNT_CTFN_PRVDD
  • BEN_ELCTBL_CHC_CTFN
  • BEN_ELIG_CVRD_DPNT
  • BEN_ELIG_DPNT
  • BEN_ELIG_FLX_CRDT_POOL_CHC
  • BEN_ELIG_PER_ELCTBL_CHC
  • BEN_ELIG_PER_F
  • BEN_ELIG_PER_OPT_F
  • BEN_ELIG_RSLT_F
  • BEN_ENRT_BNFT
  • BEN_ENRT_RT
  • BEN_EXTRACT_DETAILS_ARCH
  • BEN_EXTRACT_REQ_DETAILS
  • BEN_FLEX_CRDT_LDGR
  • BEN_PER_BENEFIT_GROUP_F
  • BEN_PER_BNF_ORG
  • BEN_PER_BNFTS_BAL_F
  • BEN_PER_IN_LER
  • BEN_PER_LE_HABITS_COV_F
  • BEN_PERSON_ACTIONS
  • BEN_PIL_ELCTBL_CHC_POPL
  • BEN_PL_BNF
  • BEN_PL_BNF_CTFN_PRVDD
  • BEN_PRTT_ENRT_ACTN
  • BEN_PRTT_ENRT_CTFN_PRVDD
  • BEN_PRTT_ENRT_RSLT
  • BEN_PRTT_LEG_DISCMR_ACTN
  • BEN_PRTT_RT_VAL
  • BEN_PTNL_LER_FOR_PER
  • BEN_REL_ASSIGNMENTS_F
  • BEN_REPORTING

Compensation Management

  • CMP_BUDGET_AUDIT
  • CMP_BUDGET_USAGES
  • CMP_CWB_ALERTS
  • CMP_CWB_APPROVAL_HISTORY
  • CMP_CWB_AUDIT
  • CMP_CWB_FEEDBACK
  • CMP_CWB_HRCHY
  • CMP_CWB_INTCPT_APPR_DTLS
  • CMP_CWB_MODEL_B
  • CMP_CWB_MODEL_DTL
  • CMP_CWB_MODEL_TL
  • CMP_CWB_PERF_RATINGS
  • CMP_CWB_PERSON_DEFAULTS
  • CMP_CWB_PERSON_ELEMENTS
  • CMP_CWB_PERSON_INFO
  • CMP_CWB_PERSON_RATES
  • CMP_CWB_POST_LOG
  • CMP_CWB_POST_PERSON
  • CMP_CWB_PROMOTIONS
  • CMP_CWB_RANKS
  • CMP_CWB_SUMMARY
  • CMP_CWB_SWITCH_MANAGERS
  • CMP_DYNAMIC_FILTER
  • CMP_INTERCEPT_APPROVERS
  • CMP_PERSON_BUDGETS
  • CMP_PROCESS_DATA
  • CMP_PROCESS_RUN_INFO
  • CMP_SALARY
  • CMP_SALARY_COMPONENTS
  • CMP_SALARY_EXPORT
  • CMP_STOCK_DETAILS
  • CMP_TCS_PER_ITEM_VALUE
  • CMP_TCS_PER_PERD
  • CMP_TCS_PER_PERD_STMT
  • CMP_TCS_PER_PERD_STMT_CAT
  • CMP_TCS_PER_ROW_VALUES
  • CMP_TCS_REPORT_DETAILS
  • CMP_VC_PER_ELIG_PLANS

Oracle Middleware Extensions for Applications

  • FND_ATTACHED_DOCUMENTS
  • FND_DOCUMENTS
  • FND_DOCUMENTS_TL
  • FND_SESSION_USERS

Workforce Modeling

  • HMO_MODEL_PLAN_DETAILS
  • HMO_MODEL_PLANS_B
  • HMO_MODEL_PLANS_TL

Performance Management

  • HRA_EVAL_ITEMS
  • HRA_EVAL_PARTICIPANTS
  • HRA_EVAL_RATINGS
  • HRA_EVAL_ROLE_ACTIONS
  • HRA_EVAL_ROLES
  • HRA_EVAL_SECTIONS
  • HRA_EVAL_STEPS
  • HRA_EVALUATIONS

Goal Management

  • HRG_GOAL_ACCESS
  • HRG_GOAL_ACTIONS
  • HRG_GOAL_ALIGNMENTS
  • HRG_GOAL_TARGET_OUTCOMES
  • HRG_GOALS

Succession Management

  • HRM_PLANS
  • HRM_PLAN_CANDIDATES
  • HRM_PLAN_OWNERS

Talent Review

  • HRR_DASHBOARDS
  • HRR_MEETINGS
  • HRR_MEETING_FACILITATORS
  • HRR_MEETING_PARTICIPANTS
  • HRR_MEETING_REVIEWEES

Questionnaire

  • HRQ_QSTN_RESPONSES
  • HRQ_QSTNR_PARTICIPANTS
  • HRQ_QSTNR_RESPONSES

Profile Management

  • HRT_NOTES
  • HRT_POOL_MEMBERS
  • HRT_POOL_OWNERS
  • HRT_PROFILE_INTERESTS
  • HRT_PROFILE_ITEMS
  • HRT_PROFILE_KEYWORDS
  • HRT_PROFILE_MATCH_CRIT
  • HRT_PROFILE_RELATIONS
  • HRT_PROFILES_B
  • HRT_PROFILES_TL

Workforce Management

  • HWM_TM_REC
  • HWM_TM_REC_GRP
  • HWM_TM_REC_GRP_SUM
  • HWM_TM_REC_GRP_USAGES
  • HWM_TM_REP_ATRB_USAGES

Workforce Predictions

  • HWP_ARCH_DATA_MINING_REASONS
  • HWP_ARCH_DATA_MINING_RESULTS
  • HWP_DATA_INPUT_VALUES
  • HWP_DATA_MINING_REASONS
  • HWP_DATA_MINING_RESULTS
  • HWP_WHATIF_PRED_DETAILS

Global Payroll

  • PAY_ASSIGNED_PAYROLL
  • PAY_ASSIGNED_PAYROLLS_DN
  • PAY_ASSIGNED_PAYROLLS_DN_
  • PAY_ASSIGNED_PAYROLLS_F
  • PAY_ASSIGNED_PAYROLLS_F_
  • PAY_DATES
  • PAY_DIR_CARD_COMPONENTS_F
  • PAY_DIR_CARD_COMPONENTS_F_
  • PAY_DIR_CARDS_F
  • PAY_DIR_CARDS_F_
  • PAY_DIR_COMP_DETAILS_F
  • PAY_DIR_COMP_DETAILS_F_
  • PAY_DIR_REP_CARD_USAGES_F
  • PAY_DIR_REP_CARD_USAGES_F_
  • PAY_DIR_REP_CARDS_F
  • PAY_DIR_REP_CARDS_F_
  • PAY_ELEMENT_ENTRIES_F
  • PAY_ELEMENT_ENTRIES_F_
  • PAY_ELEMENT_ENTRY_VALUES_F
  • PAY_ELEMENT_ENTRY_VALUES_F_
  • PAY_ENTRY_PCT_DIST
  • PAY_ENTRY_PROC_DETAILS
  • PAY_ENTRY_USAGES
  • PAY_PAY_RELATIONSHIPS_DN
  • PAY_PAY_RELATIONSHIPS_F
  • PAY_PERSON_PAY_METHODS_F_
  • PAY_RANGE_ITEMS_F
  • PAY_RANGE_ITEMS_F_
  • PAY_REL_GROUPS_DN
  • PAY_REL_GROUPS_F
  • PAY_RETRO_ENTRIES
  • PAY_VALUE_DEFINITIONS_F
  • PAY_VALUE_DEFINITIONS_F_

Global Human Resources

  • HR_DOCUMENT_DELIVERY_PREFS
  • HR_DOCUMENTS_OF_RECORD
  • PER_ABSENCE_CASES
  • PER_ACTION_OCCURRENCES
  • PER_ADDRESSES_F
  • PER_ALL_ASSIGNMENTS_M
  • PER_ALL_PEOPLE_F
  • PER_ALLOCATED_CHECKLISTS
  • PER_ALLOCATED_TASKS
  • PER_ASG_RESPONSIBILITIES
  • PER_ASSIGN_GRADE_STEPS_F
  • PER_ASSIGN_WORK_MEASURES_F
  • PER_ASSIGNMENT_EXTRA_INFO_M
  • PER_ASSIGNMENT_SUPERVISORS_F
  • PER_CITIZENSHIPS
  • PER_CONTACT_EXTRA_INFO_F
  • PER_CONTACT_RELSHIPS_F
  • PER_CONTRACTS_F
  • PER_DELEGATED_ROLES
  • PER_DISABILITIES_F
  • PER_DRIVERS_LICENSE_TYPES
  • PER_DRIVERS_LICENSES
  • PER_EMAIL_ADDRESSES
  • PER_ETHNICITIES
  • PER_IMAGES
  • PER_KEYWORDS
  • PER_LDAP_REQUESTS
  • PER_LDAP_ROLE_MEMBERSHIPS
  • PER_LDAP_USERS
  • PER_MANAGER_HRCHY_DN
  • PER_NATIONAL_IDENTIFIERS
  • PER_PASSPORTS
  • PER_PEOPLE_EXTRA_INFO_F
  • PER_PEOPLE_LEGISLATIVE_F
  • PER_PERIODS_OF_SERVICE
  • PER_PERSON_ADDR_USAGES_F
  • PER_PERSON_DLVRY_METHODS
  • PER_PERSON_NAMES_F
  • PER_PERSON_TYPE_USAGES_M
  • PER_PERSONS
  • PER_PHONES
  • PER_PORTRAIT_CARD_CONFIG
  • PER_PORTRAIT_PREFERENCES
  • PER_RELIGIONS
  • PER_SCHEDULE_ASSIGNMENTS
  • PER_SHARE_INFORMATION
  • PER_USER_HISTORY
  • PER_USER_ROLES
  • PER_USERS
  • PER_VISAS_PERMITS_F

Ashish Harbhajanka

Comments   

0 #1 adult coloring pages 2022-05-02 09:37
each time i used to read smaller posts which as well clear their motive, and that is also happening with this piece
of writing which I am reading at this place.
Quote
0 #2 adult coloring pages 2022-05-06 15:52
It's a shame you don't have a donate button! I'd without
a doubt donate to this fantastic blog! I suppose for now i'll settle for book-marking and adding your RSS feed to my Google account.
I look forward to new updates and will share this blog with my Facebook group.
Talk soon!
Quote
0 #3 calendário de julho 2022-05-07 12:12
Ⅴery enetgetic post, I loved thɑt a lot. Will there be a part 2?



Also vіsit mmy homepage; calendário de
jᥙlho: http://prjaem.ugre.forum.mythem.es/abrocome/farcissaient/geistesblitz/invincibly
Quote
0 #4 ซื้อหวย 2022-05-26 21:37
Today, I went to the beach with my children. I found a sea shell and gave it to my 4 year old daughter and said "You can hear the ocean if you put this to your ear." She placed the
shell to her ear and screamed. There was a hermit crab inside and it
pinched her ear. She never wants to go back! LoL I know this is totally off
topic but I had to tell someone!

My webpage: ซื้อหวย: https://lookbook.nu/lottoshuay,LOTTOVIP
Quote
0 #5 RUAY 2022-06-28 01:41
Asking questions are truly good thing if you are not understanding anything totally,
except this piece of writing presents good
understanding yet.

My web site - RUAY: https://unsplash.com/@ruayshuay123
Quote

Add comment


Security code
Refresh

About the Author

Ashish Harbhajanka

 

Oracle Fusion HCM Techno Functional Consultant with overall 10 years of Experience in software industry with 5 years in EBS HRMS and rest 5 in Fusion HCM.

My areas of intesrest in Fusion HCM include :

a) Inbound Outbound Integration using FBL/HDL or BIP/HCM Extracts.

b) Fast Formula

c) BIP Reports

d) OTBI Reports

e) RESTFUL API / Web Service Call

f) Functional Setup

g) End to End Testing

h) Regression Testing

i) Preparing COnfiguration Workbooks

j) Creating Speed Solutions

k) Preparing User Guides

l) UPK

........

Search Trainings

Fully verifiable testimonials

Apps2Fusion - Event List

<<  Apr 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
  1  2  3  4  5  6  7
  8  91011121314
15161718192021
22232425262728
2930     

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner