Login
Register

Home

Trainings

Fusion Blog

EBS Blog

Authors

CONTACT US

Oracle Fusion HCM
  • 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

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 :

11 11 2015 14 57 44

Input Parameters Screenshot From Application:

11 11 2015 14 59 18

Sql Query Created Based on Input Values

 11 11 2015 15 00 06

Click on Run and Click Ok

Output : 

Output Saved in PDF Version

11 11 2015 15 02 18

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 


Ashish Harbhajanka

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

<<  Mar 2024  >>
 Mon  Tue  Wed  Thu  Fri  Sat  Sun 
      1  2  3
  4  5  6  7  8  910
11121314151617
18192021222324
25262728293031

Enquire For Training

Fusion Training Packages

Get Email Updates


Powered by Google FeedBurner