My Oracle Support Banner

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 later
Information in this document applies to any platform.


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.


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

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