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

    Fast formula written error like "There is no data for array DATA_ELEMENTS"

    edited Jul 15, 2020 1:20PM in HCM Integrations 3 comments

    Summary

    HCM extract, based on rule written the assignment change flag.

    Content

    Hi ALL,

    Below fast formula written the error like

    ORA-20001: Formula XX_ASG_CHANGE_FLAG, line 14, array data value missing. Details: There is no data for array DATA_ELEMENTS, index Hire_Date. For example, if an array is set up with only two data values at indexes 1 and 3, such as a[1] = -
     
     
     
    Formula
    ++++++++++
    DEFAULT FOR DATA_ELEMENTS IS EMPTY_TEXT_TEXT
    DEFAULT FOR PARAMS IS EMPTY_TEXT_TEXT
     
    INPUTS ARE DATA_ELEMENTS  (TEXT_TEXT)
         , PARAMS         (TEXT_TEXT)
     
    l_effective_date = trunc(TO_DATE(substr(params['effective_date'], 1, 10), 'YYYY/MM/DD'))

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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