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:

• Contains additional information that only applies when using Oracle BI Publisher as part of Oracle Fusion Applications

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 https://support.oracle.com.

Important:

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