FAW: Data Level Security Not Getting Applied Using Concat Function
(Doc ID 2980476.1)
Last updated on FEBRUARY 01, 2024
Applies to:
Fusion Analytics Warehouse - Version N/A and laterInformation in this document applies to any platform.
Symptoms
Created custom AOR (Area of Responsibility) security based on Department and Location.
But the data level security filter is not getting applied while running an analytics report or a DV workbook based on 'HCM - Workforce Core' subject area.
The filter expression is defined as follows for "Dim - Worker", "Fact - Assignment" and "Fact - Assignment Event" in Semantic model:
The session variable xxxxx is populated with concatenated value of Department Identifier and Location Identifier.
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 |
| Cause |
| Solution |
| References |