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

    Not able to call Table Value set using GET_VALUE_SET function from Fast Formula

    edited Jul 25, 2024 11:48AM in Payroll and Global Payroll Interface (GPI) 4 comments

    Summary:

    Not able to call Table Value set using GET_VALUE_SET function from Fast Formula

    We are trying to call Value set from Fast Formula Using Get_value_set Function which has 2 parameters 1st is person id and second Request date

    Query for value set as below:-

    -- value set name : TEST_V1
    --VAlue Column : TO_CHAR('Y')
    --Descriptio COlumn :TO_CHAR('Y')
    --ID Column :TO_CHAR('Y')
    --FROM dual
    --WHERE Clause as below

    WHere exists (
    select 1 cnt from per_all_people_f ppf,per_all_assignments_m paaf,pay_element_entries_vl ee,pay_element_types_f ede,pay_input_values_f pivf,pay_element_entry_values_f peevf,pay_payroll_assignments PPA,pay_assigned_payrolls_dn PAPDN,pay_all_payrolls_f PAP

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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