Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
can't find element group (object group) in payroll
Hello, I'm trying this query to get the employees who are included in an element group (object group) but it didn't results in anything SELECT distinct person_number,person_id FROM per_all_people_f WHERE person_id IN ( SELECT person_id FROM pay_pay_relationships_dn WHERE payroll_relationship_id IN (SELECT OBJECT_ID FROM pay_object_group_amends WHERE object_group_id in (Select object_group_id from PAY_OBJECT_GROUPS where BASE_OBJECT_GROUP_NAME='....................') and INCLUDE_OR_EXCLUDE = 'I')) order by person_number What's the issue here?
1