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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

SUM in Table Valueset

Team,

We need to use SUM in table valuset. If you have any idea then, please share. It would be helpful.

SELECT SUM(peevf.screen_entry_value)
FROM pay_element_entries_f peef,
pay_element_types_tl petl,
per_all_people_f papf,
pay_input_values_f pivf,
pay_element_entry_values_f peevf
WHERE 1=1
AND peef.element_type_id = petl.element_type_id
AND papf.person_id=peef.person_id
AND peevf.input_value_id = pivf.input_value_id
AND peevf.element_entry_id = peef.element_entry_id
AND petl.element_name IN ('Sick Leave Ent Result', 'Regular Pay', 'Shift Earnings')

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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