Business Requirement
HCM Delete Diagnostics is a tool provided by Oracle to Delete Unwanted Data from the Fusion System.
Sometimes we might have to create Dummy Data into system for CRP ( Customer Room Pilot) and also at times we might encounter situations where incorrect data gets loaded using the Data Exchange Tool. In such scenarios we may use ‘HCM Delete’ as an option.
Specific Roles needs to be attached to the user to be able to use the same.
Roles Required to Enable HCM Delete Diagnostics
Once you add the role you will have the following link appearing beneath your user name as shown below :
Once the Role is available Click on ‘Run Diagnostic Tests’ and search for ‘HCM Delete’:
Input Parameters :
Input Parameters Screenshot From Application:
Sql Query Created Based on Input Values
Click on Run and Click Ok
Output :
Output Saved in PDF Version
HCM Delete Object Sample Output.pdf output is pasted below
HCM†Delete†Object
Test Name HCM Delete Object
Start Date 20151111T01:
32:23Z
End Date 20151111T01:
32:25Z
Execution Id 243AC3C29907CE8FE053B7A017908440
Run Id 243AC3EA78D6CEE1E053B7A01790E2A2
NLS Bundle
Source Language en
Status Code S
Version 11.1.10.0.0
Date Format YYYYMMDDThh:
mm:ss.sTZD
DiagnosticsflEngineflLog
Session†Information
The Test HCM Delete Object is using a database connection with Session Id 4949 and Serial Number 61769
HCM†Delete†Object
Commit (required) = N
P_OBJECT_ID = <no value specified>
Object Type (required) = AllByPerson
Created By Current (required) = N
Created By HR2HR (required) = N
P_OBJECT_GUID = <no value specified>
P_OBJECT_CLAUSE = <no value specified>
Created By = FUSION_APPS_HCM_ESS_LOADER_APPID
Batch†Parameters
pEntId = 1
SessionId = 243A49B463F29319E053B6A017900793
P_OBJECT_TYPE = AllByPerson
P_OBJECT_ID =
P_OBJECT_GUID =
P_OBJECT_CREATED_BY = FUSION_APPS_HCM_ESS_LOADER_APPID
P_OBJECT_CREATED_BY_CURRENT = N
P_OBJECT_HR2HR = N
P_OBJECT_CLAUSE =
P_OBJECT_COMMIT = N
Where†Clause
select distinct p.person_id from per_persons p , per_all_people_f paf , per_person_names_f n ,
per_email_addresses e where p.person_id = paf.person_id and p.person_id = n.person_id (+) and n.name_type
(+) = 'GLOBAL' and p.person_id = e.person_id(+) and p.business_group_id = 1 and p.created_by =
'FUSION_APPS_HCM_ESS_LOADER_APPID'
Delete†People†and†Associated†Objects
AllByPerson Objects Deleted : 2874