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
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

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

    How we can load Historical Address data Using HDL

    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

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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