Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Table Value Set not returning data using pay_ff_functions.gvs — Cloud Customer Connect
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

Table Value Set not returning data using pay_ff_functions.gvs

Accepted answer
1
Views
2
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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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