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
Manager Dashboard - Organization Chart- Data Security
Summary
Manager Dashboard - Organization Chart- Data SecurityContent
Hi Team,
We have applied a data security for manager role to exclude all employee and show only contingent worker, In person security profile its working fine by showing the correct employee count, But organization chart is showing all direct reports data, Can you provide the input how we can exclude specific person type employees from organization chart?
Below custom criteria used in the person security profile on top of manager Hierarchy
NOT EXISTS
(SELECT 1
FROM PER_PERSON_TYPE_USAGES_M PTU,PER_PERSON_TYPES_VL PTYPE
WHERE PTU.PERSON_ID =&TABLE_ALIAS.PERSON_ID
Tagged:
0