Oracle Fusion applications has created three J2EE applications to support BI:
Financials and Supply Chain Management (FSCM)—Includes Financials, Supply Chain Management, Procurement, Oracle Projects and Oracle Fusion Incentive Compensation
Customer Relationship Management (CRM)
Human Capital Management (HCM)
In addition to the standard WebLogic Server configuration required to support these applications, some manual configurations are required to correctly set the data sources or connections in the Oracle BI repository. The BI Administrator should manually configure these settings:
Database Connection Settings
Note: | For more information on Oracle Fusion Applications architecture design, refer to the Oracle Fusion Applications Concepts Guide. For more information on Oracle Fusion applications, see “Oracle Fusion Middleware Configuration Guide for Oracle Business Intelligence Applications”. |
SQL Bypass Database Settings
Note: | Setting up an SQL Bypass Database is required. |
Note: | A SQL Bypass database connection should point to the same database as an Oracle Fusion application, for example one pointed to by Transactional Business Intelligence Oracle ADF view objects. If a customer has set a replication database for Oracle Fusion OLTP database and if Transactional Business Intelligence Oracle ADF view objects are pointing to the main OLTP database, the SQL bypass connection cannot point to the replication database. |
Essbase Connection Settings
Translations Schema Connection Setting