Help with Fast Formula to Check Element Entry — 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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

Help with Fast Formula to Check Element Entry

edited Nov 12, 2024 10:50AM in Payroll and Global Payroll Interface (GPI) 1 comment

Summary:

Hello, we are currently trying to create a Fast Formula. The goal of this formula is to verify if a specific Element Entry is associated with the employee. However, we are facing an issue in getting the correct result.


Content (please ensure you mask any confidential information):

Value Set.

FROM Clause: per_all_assignments_m paam,pay_element_entries_f peef,pay_element_types_f petf,pay_input_values_f pivf ,pay_element_entry_values_f peevf

Value Column Name: TO_CHAR(peevf.screen_entry_Value)

WHERE Clause:

1=1

AND paam.person_id = :{PARAMETER.PersonId}
and paam.assignment_type in ('E','C')

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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