My Oracle Support Banner

Custom SQL for Person Security Profile that would exclude a country (Doc ID 2486467.1)

Last updated on JANUARY 18, 2020

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.18.10.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.18.10.0 version, HCM Security (Security Profiles, Users, Roles)

ACTUAL BEHAVIOR
---------------
Custom SQL Required for Person Security Profile

Due to privacy concerns related to requirements set out by the German Works Council and GDPR, we need assistance in creating a custom SQL to create a Person Security profile that would provide access to all countries (legislations) OTHER than Germany (legislation code DE) - legislation code not equal to DE. While I can create an Area of Responsibility for HR representatives who will need access to Germany person records and create a person security profile to include the AOR, it is not feasible to create 20+ areas of responsibility each for numerous HR representatives who need access to all other legislations. Since Oracle still has not provided the ability in the AOR creation to use include/exclude logic, the custom SQL is our best option to accomplish this.

Changes

 No changes.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.