Fusion Projects OTBI: Release 12 Upgrade Document On Oracle Transactional Business Intelligence (OTBI) Role Provisioning

(Doc ID 2308366.1)

Last updated on SEPTEMBER 18, 2017

Applies to:

Oracle Fusion Project Foundation Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Goal

Users are unable to view the data in Oracle Transactional Business Intelligence (OTBI) reports (amounts appear as 0) after upgrade to Release 12. In Release 12, data security access for OTBI is granted through the application job roles instead of existing duty ORA_PJF_PROJECTS_REPORTING_ANALYSIS_DUTY for enterprise job roles. Due to this change in the data security implementation, upgraded customers are unable to view data in Analysis and the dashboards created in OTBI.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms