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
Person Security - Custom Criteria SQL
Summary
SQL Query to restrict the person data based on the division associated with an assignment department.Content
Team,
Here is an example of data. Department is associated with an employee and the division name can be taken from Department Name (After Hyphen (-) in department name which is division name). We need to write an SQL to restrict the data at division level.
In the following case Employee 101 can access to 103 records as the division names are same (DIV1), but cannot access to 102.
DepartmentName|Division Name|Employee No
DEP1-DIV1|DIV1|101
DEP1-DIV2|DIV2|102
DEP2-DIV1|DIV1|103
I wrote the below SQL for Custom Criteria but its not working.
Tagged:
0