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

Have anyone created a successful transformation formula for worker - New Hire, Existing, Termination

in HCM Data Loader (HDL)

Summary:

Transformation Fast Formula to accommodate 3 scenarios in one Transformation Fast Formula

Content (please ensure you mask any confidential information):

Have anyone perhaps created a transformation formula for Worker, which processes the following scenarios obtained from a 3rd party CSV all in one file-

  1. For New Hires - require File Discriminator(s): Worker, WorkRelationship, WorkTerms, Assignment, PersonName, PersonAddress, PersonEmail, PersonUserInformation, AssignmentSupervisor, AssignmentWorkMeasure

Do have fast formula that works for new hires, generate HDL correctly, Import and Load successfully.

2. EXISTING WORKERS (Updates, non-termination) — the 3rd party csv file do contain the Oracle Person Number, thus PersonNumber will be supplied where required for each File discriminator. Action Code to default as ASG_CHANGE.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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