|Oracle® Business Intelligence Applications Configuration Guide for Informatica PowerCenter Users
Part Number E14844-01
Oracle Business Intelligence Applications are comprehensive prebuilt solutions that deliver pervasive intelligence across an organization, empowering users at all levels — from front line operational users to senior management — with the key information they need to maximize effectiveness. Intuitive and role-based, these solutions transform and integrate data from a range of enterprise sources, including Siebel, Oracle, PeopleSoft, JD Edwards, and corporate data warehouses — into actionable insight that enables more effective actions, decisions, and processes.
Oracle BI Applications are built on Oracle Business Intelligence Suite Enterprise Edition, a comprehensive next-generation BI and analytics platform.
Oracle BI Applications includes the following application families:
Oracle Contact Center Telephony Analytics
Oracle Financial Analytics
Oracle Human Resources Analytics
Oracle Loyalty Analytics
Oracle Marketing Analytics
Oracle Pharma Marketing Analytics
Oracle Pharma Sales Analytics
Oracle Price Analytics
Oracle Procurement and Spend Analytics
Oracle Project Analytics
Oracle Sales Analytics
Oracle Service Analytics
Oracle Supply Chain and Order Management Analytics
Oracle Business Intelligence Applications Configuration Guide for Informatica PowerCenter Users contains instructions for configuring and customizing Oracle BI Applications Version 18.104.22.168.
Oracle recommends reading the Oracle Business Intelligence Applications Release Notes before installing, using, or upgrading Oracle BI Applications. The Oracle Business Intelligence Applications Release Notes are available:
On the Oracle Business Intelligence Applications CD-ROM.
On the Oracle Technology Network at
http://www.oracle.com/technology/documentation/bi_apps.html (to register for a free account on the Oracle Technology Network, go to
This document is intended for BI managers and implementors of Oracle BI Applications.
Note:Many configuration tasks described in this guide require you to manually enter values obtained from querying your source system (for example, Oracle E-Business Suite). These values are unique to your source system and implementation. To retrieve these values successfully, you need to have a good technical understanding of your source system. If you need assistance in obtaining values from your source system, you should consult with someone in your organization who possesses this knowledge, or consult the Oracle Support Services team for your source system. Make sure to check your configuration entries carefully to avoid data loss during the ETL process.
Our goal is to make Oracle products, services, and supporting documentation accessible to all users, including users that are disabled. To that end, our documentation includes features that make information available to users of assistive technology. This documentation is available in HTML format, and contains markup to facilitate access by the disabled community. Accessibility standards will continue to evolve over time, and Oracle is actively engaged with other market-leading technology vendors to address technical obstacles so that our documentation can be accessible to all of our customers. For more information, visit the Oracle Accessibility Program Web site at
Accessibility of Code Examples in Documentation
Screen readers may not always correctly read the code examples in this document. The conventions for writing code require that closing braces should appear on an otherwise empty line; however, some screen readers may not always read a line of text that consists solely of a bracket or brace.
Accessibility of Links to External Web Sites in Documentation
This documentation may contain links to Web sites of other companies or organizations that Oracle does not own or control. Oracle neither evaluates nor makes any representations regarding the accessibility of these Web sites.
Deaf/Hard of Hearing Access to Oracle Support Services
To reach Oracle Support Services, use a telecommunications relay service (TRS) to call Oracle Support at 1.800.223.1711. An Oracle Support Services engineer will handle technical issues and provide customer support according to the Oracle service request process. Information about TRS is available at
http://www.fcc.gov/cgb/consumerfacts/trs.html, and a list of phone numbers is available at
For more information, see the following documents in the Oracle BI Applications Version 22.214.171.124 documentation set (available at
Oracle Business Intelligence Applications Release Notes
System Requirements and Supported Platforms for Oracle Business Intelligence Applications
Oracle Business Intelligence Applications Configuration Guide for Informatica PowerCenter Users
Oracle Business Intelligence Applications Upgrade Guide for Informatica PowerCenter Users
Oracle Business Intelligence Applications Security Guide
Oracle Business Analytics Warehouse Data Model Reference
Also see the Oracle Business Intelligence Data Warehouse Administration Console documentation set (available at
Oracle Business Intelligence Data Warehouse Administration Console Release Notes
System Requirements and Supported Platforms for Oracle Business Intelligence Data Warehouse Administration Console
Oracle Business Intelligence Data Warehouse Administration Console User's Guide
Oracle Business Intelligence Data Warehouse Administration Console Installation, Configuration and Upgrade Guide
The following text conventions are used in this document:
|boldface||Boldface type indicates graphical user interface elements associated with an action, or terms defined in text or the glossary.|
|italic||Italic type indicates book titles, emphasis, or placeholder variables for which you supply particular values.|
||Monospace type indicates commands within a paragraph, URLs, code in examples, text that appears on the screen, or text that you enter.|