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

    HDL Transformation formula reading the input file twice instead of once

    edited Nov 20, 2019 7:57PM in HCM Integrations 13 comments

    Content

    Hi All,

    I am trying to load a user defined table using HDL transformation formula. The UDT and columns are already setup. Now I want to read the input file and load the rows and column instances.

    Input File:

    Employee ID|Job Information Effective Date|First Name
    100018|05/03/2018|RICHARD
    100021|03/22/2013|STEVEN
    100025|06/06/2017|RUTHANNE

    HDL Transformation Formula in Code snippet and attachment section:

    HDL FF.txt

    Load Data from File (Log File with ESS_LOG_WRITE function):

    HDL log file.txt

    Can you please check the Fast Formula, Input file and the log file and let me know where I have gone wrong.

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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