Skip to content

Oracle Communities

Register to the Data Intelligence Summit Mexico Register today to the Oracle Analytics Data Intelligence Summit in Mexico on April 8th
Oracle Analytics was named as a Leader Oracle Analytics was named as a Leader in the 2024 Gartner® Magic Quadrant for Analytics and BI Platforms
New Oracle Analytics Release March 2025 New Oracle Analytics March 2025 release for Oracle Analytics Cloud and Analytics Server
Oracle Analytics Product Satisfaction Survey Share your experience and satisfaction with Oracle Analytics Product with our Product Satisfaction Survey

Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

What privilege or configuration is needed to ensure the user could view Demographic Info it in OTBI?

Received Response

11

Views

2

Comments

OliveiraRR

OliveiraRR Rank 2 - Community Beginner

March 14 in Oracle Transactional Business Intelligence

One user can see PER_PERSON_LEGISLATIVE_DFF on the screen but not in OTBI, while another user can see it both on the screen and in OTBI.

The flexfield is configured to be visible in OTBI, and the Import Oracle Fusion Data Extensions for Transactional Business Intelligence process has been run. Additionally, the Person View ORA_PER_PERSON_VIEW_DUTY_OBI and ORA_PER_PERSON_VIEW_DUTY privileges have been assigned. However, the first user can still only see the flexfield on the screen, while the other user can see it in both places.

	Demographic Info

What privilege or configuration is needed to ensure that the first user can also view it in OTBI?

The person who does not see:

The person who sees:

Version (include the version you are using, if applicable):

Tagged:

0

Answers

Bhaskar Konar Rank 7 - Analytics Coach

March 15

What privilege or configuration is needed to ensure the user could view Demographic Info it in OTBI?
OliveiraRR
Mar 14, 2025
One user can see PER_PERSON_LEGISLATIVE_DFF on the screen but not in OTBI, while another user can see it both on the screen and in OTBI.
The flexfield is configured to be visible in OTBI, and the Import Oracle Fusion Data Extensions for Transactional Business Intelligence process has been run. Additionally, the Person View ORA_PER_PERSON_VIEW_DUTY_OBI and ORA_PER_PERSON_VIEW_DUTY privileges have been assigned. However, the first user can still only see the flexfield on the screen, while the other user can see it in both places.
Demographic Info
What privilege or configuration is needed to ensure that the first user can also view it in OTBI?
https://us.v-cdn.net/6037859/uploads/X7UBL1RD8P2R/image.png
https://us.v-cdn.net/6037859/uploads/CWDOF8HZ9IFM/image.png
The person who does not see:
https://us.v-cdn.net/6037859/uploads/J3H0MP86NO1A/image.png
The person who sees:
https://us.v-cdn.net/6037859/uploads/WSIYN55E3UTP/image.png
Version (include the version you are using, if applicable):
View Post

Hi @OliveiraRR,
Can you please compare the roles that have been assigned to both the persons to see if there is any role (s) is missing from the person who is not able to see the data via OTBI Report especially data roles like 'HR View All' etc.
Hope this help.
Thank you.

0
MandeepGupta Rank 7 - Analytics Coach

March 15

What privilege or configuration is needed to ensure the user could view Demographic Info it in OTBI?
OliveiraRR
Mar 14, 2025
One user can see PER_PERSON_LEGISLATIVE_DFF on the screen but not in OTBI, while another user can see it both on the screen and in OTBI.
The flexfield is configured to be visible in OTBI, and the Import Oracle Fusion Data Extensions for Transactional Business Intelligence process has been run. Additionally, the Person View ORA_PER_PERSON_VIEW_DUTY_OBI and ORA_PER_PERSON_VIEW_DUTY privileges have been assigned. However, the first user can still only see the flexfield on the screen, while the other user can see it in both places.
Demographic Info
What privilege or configuration is needed to ensure that the first user can also view it in OTBI?
https://us.v-cdn.net/6037859/uploads/X7UBL1RD8P2R/image.png
https://us.v-cdn.net/6037859/uploads/CWDOF8HZ9IFM/image.png
The person who does not see:
https://us.v-cdn.net/6037859/uploads/J3H0MP86NO1A/image.png
The person who sees:
https://us.v-cdn.net/6037859/uploads/WSIYN55E3UTP/image.png
Version (include the version you are using, if applicable):
View Post

Can you please check for 'Workforce Confidential Reporting' duty? This duty gives access to gender and other info on demographic data.
Workforce Confidential Reporting Data Duty.
Or assign seeded Human Resources Analyst job role and then try.
Thanks.

0