You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Person Number bulk update via HDL

edited Sep 11, 2021 9:57PM in Human Capital Management 17 comments

Summary

Tested and working method to update Person Numbers in mass using HCM Data Loader

Content

Hi, 

In case, for some reason, you need to update the Person Numbers in Fusion HCM for a bulk of persons, HDL tool is a the best way to do it using Worker.dat. You can provide the PersonId, EffectiveStartDate, and the new PersonNumber. 
Following is an example of the file content that can be used:

METADATA|Worker|EffectiveStartDate|PersonId|PersonNumber
MERGE|Worker|1985/10/01|300000002211853|1001

The PersonId and EffectiveStartDate can be retrieved using BI Catalog.

As an IMPORTANT note, in order to accomplish the above, the person number generation method 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!