Categories
- All Categories
- 16 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 224 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.8K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 83 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Person Records Secured By AOR Does Not Restrict Data Reflected In OTBI Reports
Answers
-
Hi all, has anyone found a solution to this issue?
Our issues is a user with data assigned AOR is showing the employees correctly in UI, but in BIP using the secured views and returning no data.
0 -
Hi Sarah,
What secured views you are using in BIP? Also, are you using person or assignment security in your Org?
Thanks.
0 -
Hi Mandeep, we are using
PER_ASSIGNMENT_SECURED_LIST_V
and we are using assignment security in our Org.
the strange this is, when we use PER_PERSON_SECURED_LIST_V the report returns data, but not when we use the assignment_secured_list_v
0 -
Thanks for sharing the details. Can you confirm if you have correct setup as per below note?
Fusion Global HR: Unable to access the Secured Table (KB23554).
Thanks.
0