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

    Table Value Set not returning data using pay_ff_functions.gvs

    in Payroll and Global Payroll Interface (GPI) 4 comments

    Summary:

    Table Value Set not returning data while testing it using pay_ff_functions.gvs

    Content (required):

    I have created a value set of type Table using the following code:

    Value Set Code : XX_PAY_GET_ELEMENT_DATE

    Module : Global Human Resources

    *FROM Clause : pay_run_results prr,pay_run_result_values prrv,pay_element_types_f petf,pay_payroll_assignments ppasg,pay_payroll_actions ppa,pay_payroll_rel_actions ppra,pay_requests pr,pay_flow_instances pfi

    *Value Column Name: TO_CHAR(PPA.DATE_EARNED,'DD-MM-YYYY')

    Value Column Type (defaulted) : VARCHAR2

    where Clause:  ppra.payroll_rel_action_id   = prr.payroll_rel_action_id

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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