Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Sum of run result value give the YTD value — 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

Sum of run result value give the YTD value

Received Response


Hi All,

Can sum of run result value give the YTD Value?

I tried with the below code but it returns the run result value of the last run.

Any input would be much appreciated.


Content (required):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):

Select distinct





FROM pay_run_results   prr

,pay_run_result_values  prrv

,pay_element_types_f   petf

,pay_input_values_f    pivf

,pay_ele_classifications_vl pec

,pay_payroll_rel_actions pra_Inner

Howdy, Stranger!

Log In

To view full details, sign in.


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