|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
|PDF · Mobi · ePub|
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:
Contains additional information that only applies when using Oracle BI Publisher as part of Oracle Fusion Applications
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:
ApplicationDB_FSCM - includes the Oracle Fusion Financials applications data
ApplicationDB_CRM - includes the Oracle Fusion Customer Relationship Management applications data
ApplicationDB_HCM - includes the Oracle Fusion Human Capital Management applications data