Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
How we can load Historical Address data Using HDL — Cloud Customer Connect
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

How we can load Historical Address data Using HDL

Accepted answer
12
Views
10
Comments
edited Jun 15, 2021 5:22PM in HCM Integrations 10 comments

Summary

How we can load Historical Address data Using HDL

Content

Hi Experts,

i am trying to load Historical Data for a global transferred employee and getting the below errors

"The mailing address must be valid on the current date."

Please let me know what i can make corrections

Date Start1:01-05-2003

Date Start2:01-07-2012

The data i am trying to Load for address:

METADATA|PersonAddress|SourceSystemOwner|SourceSystemId|EffectiveStartDate|EffectiveEndDate|AddressType|PersonId(SourceSystemId)|TownOrCity|Country|PostalCode|AddressLine1|AddressLine2|AddressLine3|Region1|Region2

MERGE|PersonAddress|TEST_LOAD|82298_ADDRESS|2013/04/23|4712/12/31|HOME|82298_PERSON|Johns Creek|US|30022|ABCD|||Fulton|GA

MERGE|PersonAddress|TEST_LOAD|82298_ADDRESS1|2012/07/01|2013/04/22|MAIL|82298_PERSON|Alpharetta|US|30005|EFGH|||Fulton|GA

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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