Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Custom SQL Criteria in Person Security Profile
Summary
Is it possible to use given construct to only show employees based on logged in EmployeeContent
I know I can use this kind of construct to get logged in user's details. Does this work in Custom SQL criteria If I have a complex SQL and want to pass logged in person_ID using this construct. I know it works fine in BIP.
select * from per_all_people_f where person_id in (SELECT HRC_SESSION_UTIL.GET_USER_PERSONID FROM DUAL)
Version
19C3