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 to update an Assignment Number using HDL?

    edited Aug 23, 2017 3:04PM in Human Capital Management 7 comments

    Summary

    How to update an Assignment Number using HDL?

    Content

    Hi Friends,

    We were converting employees in HCM, and wanted the person number to be generated automatically which worked really fine.

    Unfortunately we have hardcoded Assignment Number in HDL Assignment and work terms file as a combination of E|legacyemployee number,ET|legacyemployee number due to this the Person Number and Assignment number are mismatched.

    I did work on a fix for the same and thought this would be helpful to share it here with the group.

    Please find the attached file which has the sql's including the Assignment and Work Terms in HDL file formats.

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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