How to Update Employee Email address Through HDL in Oracle Cloud
If we have an Requirment to Mass update the Employee email addresses in Oracle cloud , then we can do with the Help of HDL tool in Oracle Cloud. HDL (HCM Data Loader) helps to Integrate the Employee Information with External system in Oracle cloud. To mass update employee email address we can use the HDL metadata to update the exiting employee email addresses in Oracle Cloud. Here below I will share the complete source code and the detail steps to Update Employee Email address Through HDL in Oracle Cloud
Step by Step to Update Employee Email address Through HDL in Oracle Cloud
Step1:- We need to use two metadata in worker file to update the email address through HDL in oracle cloud.
Meta Data :
METADATA|Worker|EffectiveStartDate|EffectiveEndDate|PersonNumber|StartDate|DateOfBirth|ActionCode|SourceSystemOwner|SourceSystemId
Meta Data Sample Data:
MERGE|Worker|2019/08/01|4712/12/31|9445444|2019/08/01|1900/01/01|HIRE|TEST|9445444
Meta Data :
METADATA|PersonEmail|SourceSystemOwner|SourceSystemId|PersonId(SourceSystemId)|DateFrom|DateTo|EmailType|EmailAddress|PrimaryFlag
Meta Data Sample Data:-
MERGE|PersonEmail|TEST|9445444_W1|9445444|2019/08/01|4712/12/31|W1|test@email.com|Y
Here below this is the Complete worker file having , Employee Header and Employee email update script to Update Employee Email address
To Import this Worker.Zip file we need to follow these steps as below.
Once the zip file have been prepared. Then We need to go Data Exchange
How to Rehire the Employee through HDL in Oracle cloud
How to Rehire the Employee through HDL in Oracle cloud
How to Update Employee Email address Through HDL in Oracle Cloud
4 comments:
Nice blog I visit this blog it's really awesome. The important thing is that in this blog content written clearly and understandable. The content of information is very informative.
Oracle Fusion HCM Online Training
Oracle Fusion Financials Online Training
How is employees work email id created. While hiring an employee it asks for work email id. How do we populate the work email id when we have not yet created work email id.
Hi , Thanks for the post. I am doing basic load and I am getting the below error. Please can you help ?
METADATA|WorkTerms|AssignmentNumber|PersonNumber|LegalEmployerName|DateStart|WorkerType|EffectiveStartDate|EffectiveEndDate|EffectiveSequence|EffectiveLatestChange|ActionCode|BusinessUnitShortCode|PersonTypeCode|NormalHours|Frequency|JobCode|PeriodOfServiceId
MERGE|WorkTerms||ET100450|DBLtd||E|2020/04/01||1|Y||||37.5|Weekly||
Error : The line for component WorkTerms with instruction MERGE doesn't include values that define a unique reference to the record. (HRC-1035347) Details: Include values for at least one of the supported keys.
I tried several times all i need to do is update the Normal hours( Working hours )
if you uploaded that dat file without taking screenshot it would have been so much trouble for you?
Post a Comment