Skip Headers
Oracle® Fusion Middleware Data Modeling Guide for Oracle Business Intelligence Publisher (Oracle Fusion Applications Edition)
11g Release 1 (11.1.1)

Part Number E26386-03
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub

Creating Data Models in Oracle Fusion Applications

The Data Modeling Guide for Oracle Business Intelligence Publisher contains information about creating data models in generic Oracle BI Publisher implementations.

This Oracle Fusion Applications Edition version of the guide:

Oracle Fusion Applications-specific Information

The following information is specific to building data models in Oracle Fusion Applications.

Role Required for Editing or Creating Data Models

In Oracle Fusion Applications the BI Author role does not provide adequate permissions for editing data models, you must also have the BI Publisher Data Model Developer role to edit or create data models. This role is included in the Application Developer role. To assign one of these roles for editing data models, follow the guidelines in the "Configuring Roles" section in the Oracle Fusion Applications Administrator's Guide. For Oracle Cloud implementations, request this role by logging a service request using My Oracle Support at


Because the BI Publisher Data Model Developer role enables the ability to write SQL, it carries substantial access privileges and should only be assigned when needed. As a guideline: Developers should be granted this access in development environments; only trusted individuals should be granted this access in test environments. Implementers should consider not extending this privilege to any user in a production environment.

Creating Data Models Against Oracle Fusion Applications

You can create a SQL-based query data model against the Oracle Fusion Applications tables. In BI Publisher the Oracle Fusion Applications tables are provisioned as follows: