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

How to load historical personal email addresses?

edited Aug 4, 2020 9:52AM in HCM Integrations 5 comments

Summary

How to load historical personal email addresses?

Content

Hi Team,

I am migrating data from legacy system to Fusion. There are few workers where the email address is changing:

METADATA|PersonEmail|EmailAddressId|PersonId(SourceSystemId)|PersonNumber|DateFrom|DateTo|EmailType|EmailAddress|PrimaryFlag|GUID|SourceSystemOwner|SourceSystemId
MERGE|PersonEmail||1345_PERSON||1977/12/31|2007/12/02|W1|Test12@xx.net|Y||VIS|1345_EMAIL
MERGE|PersonEmail||1345_PERSON||2007/12/03|4712/12/31|W1|Test123@xx.net|Y||VIS|1345_EMAIL

But the system throws:

You can't supply multiple data lines for the same record in the same file because the component {BUS_OBJ_NAME} isn't date-effective.

Which is correct. If I try to load using below:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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