How to restrict user based on Cost Center to view OTBI Report

Raoof Ahmed

Summary:

I have created Dashboard for Budget Vs actual.

The user has Access to all the Cost Center data in dashboard. How to restrict user based on Cost Center (the user shouldn't see another cost center data).

Fiona Marran

Hi - did you get any response to this query? I'm also interested in this solution!

Nathan CCC

Hi Raoof, Out of the box you can use the data security policies such as the in job role such General Accountant to setup on page Manage Data Access for Users data security on context Data Access Set by ledger. But if cost centre is one of the segments in your charts of accounts(s)? Then maybe get your application implementation consultant for application financials to set up data security based on the values of that segment. Then see if you have a data security policy that is used by your subject area to add a where clause to your logical query at runtime with segment level data security for your user to see cost centre segment n value = A but not B in OTBI.

For more information see

Oracle Fusion Cloud Financials
Implementing Enterprise Structures and General Ledger
G12433-03 24D

https://docs.oracle.com/en/cloud/saas/financials/24d/faigl/overview-of-segment-value-security.html