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
    • Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

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

    HDL Transformation Formula With Element Entry to load Multiple Input Values from Single Line

    edited May 13, 2020 4:21PM in HCM Integrations 10 comments

    Summary

    HDL Transformation Formula With Element Entry to load Multiple Input Values from Single Line

    Content

    I am trying to load Element Entrry using HDL transformation formula.  

    Input File Is below:

    EMPLID|GID|SSN|ERNCD|AMOUNT|SEPCHK|GROSS_UP|DISABLE_DD|REASON_CODE|OFFSET_FLAG|STATE_CODE|ASSIGNMENT_NUMBER|COMMENTS
    235XXX|||SAW|100.86|Y|N|||Y||

    Multiple Input Value is below :
    Amount
    Offset Eligible
    Pay Separately
    Earned Date


    Expected HDL File :

    METADATA|ElementEntry|AssignmentNumber|EffectiveStartDate|EffectiveEndDate|ElementName|EntryType|LegislativeDataGroupName|MultipleEntryCount|ReplaceLastEffectiveEndDate
    MERGE|ElementEntry|E235XXX|2020/05/11|2020/05/24|Siemens Stock Award|E|US Legislative Data Group|2|Y
    METADATA|ElementEntryValue|AssignmentNumber|EffectiveStartDate|EffectiveEndDate|ElementName|EntryType|LegislativeDataGroupName|MultipleEntryCount|InputValueName|ScreenEntryValue|ReplaceLastEffectiveEndDate

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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