Build a OTBI analysis using 2 subject areas but results is giving blank table.

Sourav Bose

I am trying to build a OTBI analysis in oracle fusion application using two subject areas ' Risk Management Cloud - Advanced Financial Controls Real Time ' and ' User System Usage ' but after selecting the required columns from the both the subject area the table showing in the results tab is coming blank i.e. without any data, just the columns headers are present no data is showing in the tables.

my objective here is to get the mail id of the investigators (person who has been assigned some incidents) in the analysis, from the 'Risk Management Cloud - Advanced Financial Controls Real Time' subject area i am getting the display name in the investigator column but my requirement is to get the mail id of the investigators, I have taken the mail id column from the 'User System Usage' subject area.

Praveen Kumar Akkala-Oracle

Hello @Sourav Bose ,

Are you able to create a report with only “User System Usage” subject area and get the data out of it?

If No, Can you please review the below document.

BI : FAQ on User System Usage Subject Area (Doc ID 2663715.1)

Also are you able to get the data out of the report created only with ' Risk Management Cloud - Advanced Financial Controls Real Time ' subject area ?

Also review the below documents to see if the user has assigned with the required roles :

https://docs.oracle.com/en/cloud/saas/sales/faoec/User-System-Usage-SA-147.html#User_System_Usage_SA_147_d1e52553

https://docs.oracle.com/en/cloud/saas/risk-management-and-compliance/24a/faorm/Risk-Management-Cloud--Advanced-Access-Controls-Re-SA-4.html#Risk_Management_Cloud__Advanced_Access_Controls_Re_SA_4_d1e2283

Thanks,

Praveen