Change the start date / hire date / effective start date of Worker with HDL

Change hire date of Worker using HDL :

The start date of a work relationship means the Hire Date. To change the Hire Date we need to use the NewStartDate in work relationship Metadata.

only work relationship is sufficient to change the hire date of an employee.

Worker.dat:

SET PURGE_FUTURE_CHANGES N
METADATA|WorkRelationship|SourceSystemOwner|SourceSystemId|PersonNumber|LegalEmployerName|NewStartDate
MERGE|WorkRelationship|FUSION|100000895467|1234|TEST_LE|2017/07/24


To get source system Id:


SELECT PERSON_ID FROM fusion.PER_ALL_PEOPLE_F WHERE PERSON_NUMBER ='1234'

SELECT PERIOD_OF_SERVICE_ID FROM fusion.PER_PERIODS_OF_SERVICE WHERE PERSON_ID =123456788964

SELECT SURROGATE_ID FROM fusion.HRC_INTEGRATION_KEY_MAP

WHERE SURROGATE_ID = 100000895467
  --(SURROGATE_ID =PERIOD_OF_SERVICE_ID )

Note:
Currently Oracle's Fusion Application doesn't support "changing Start Date of Work Relationship created because of global transfer". This is neither supported from HDL(HCM Data Loader) nor from Fusion User Interface.
When a Fusion user perform the global transfer, it will terminate old WorkRelationship(WR)  and create new one. NewStartDate in HDL is to change the hire date of first work relationship of a person and can not be used to change Global transfer new WR start date.

For changing the start date of the Work Relationship created because of global transfer, you have to cancel that Work Relationship and you have to perform global transfer again with correct date.

It may helpful for you. please visit blog for more information and share your ideas.

Thanks,
Sainath