Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documentation
• Conventions

What's New in This Release

• New Features in Release 11.1.1.7.1

1 Overview

Part I Functional Configuration for Oracle Business Intelligence Applications

2 Overview of Functional Configuration in Oracle BI Applications

• 2.1 Terminology
• 2.2 Overview of Oracle BI Applications Configuration Manager and Functional Setup Manager
  • 2.2.1 What is Oracle BI Applications Configuration Manager?
  • 2.2.2 What is Functional Setup Manager?
• 2.3 Getting Started With Oracle BI Applications Configuration Manager
  • 2.3.1 About Getting Help
  • 2.3.2 About Setup Data Migration in Oracle BI Applications Configuration Manager
• 2.4 About Users and Roles in Oracle BI Applications Configuration Manager
• 2.5 About the Main Task Areas in Oracle BI Applications Configuration Manager
• 2.6 About Functional Setup Tasks in FSM
• 2.7 About Setup Objects in Oracle BI Applications Configuration Manager
• 2.8 About the Work Area in Oracle BI Applications Configuration Manager
  • 2.8.1 About the Work Area
  • 2.8.2 About the Menu Options
  • 2.8.3 About the Icons
  • 2.8.4 About sorting items
  • 2.8.5 How to use Query By Example
• 2.9 About Accessibility Features In Oracle BI Applications Configuration Manager

3 Performing Functional Configuration

• 3.1 What is Functional Configuration?
  • 3.1.1 About Task Lists and Tasks for Oracle Business Intelligence Applications Offerings
  • 3.1.2 About Administrator Passwords
• 3.2 Roadmap for Functional Configuration
• 3.3 Performing Functional Configuration
  • 3.3.1 How to Enable Offerings
  • 3.3.2 How to Create an Implementation Project and Select Offerings
  • 3.3.3 Additional Steps for Managing Projects in FSM
    • 3.3.3.1 About Performing Functional Tasks
    • 3.3.3.2 How to Assign Tasks to Functional Developers
    • 3.3.3.3 How to Perform Functional Tasks using the Administrator role
    • 3.3.3.4 How to Perform Functional Tasks using the Functional Developer role
    • 3.3.3.5 How to Monitor Implementation Projects
    • 3.3.3.6 How to Monitor Functional Setup Tasks
    • 3.3.3.7 About Completing Tasks in the Common Areas and Dimensions Configurations Task List

4 Administering and Maintaining Functional Configuration Data

• 4.1 About Maintaining and Administering Functional Configuration Data
• 4.2 Roadmap for Setup Data Maintenance and Administration
• 4.3 About Functional Configuration Data
• 4.4 About Working With Domains and Domain Mappings
  • 4.4.1 About Domain Mappings and Domain Member Mappings
    • 4.4.1.1 About Regular Domains and Band Domains
  • 4.4.2 About Source Domains
  • 4.4.3 About Warehouse Domains
  • 4.4.4 About Warehouse Domain Hierarchies
  • 4.4.5 About Setting Up Domain Member Mappings
    • 4.4.5.1 How to edit a Domain Member Mapping
    • 4.4.5.2 How to add a Range Member Mapping
    • 4.4.5.3 How to add a Target Domain Member
    • 4.4.5.4 How to Localize a New Domain Member
    • 4.4.5.5 How to Add String Localizations for Oracle BI Repository Metadata
    • 4.4.5.6 How to use Sync to Source to synchronize a Target Domain with a Source Domain
    • 4.4.5.7 How to use Batch Edit to update multiple Target Domain Member Values
  • 4.4.6 How to modify a Warehouse Domain Hierarchy
  • 4.4.7 Why are some domains non-extensible?
  • 4.4.8 How to Configure Externally Conformed Domains
• 4.5 About Working With Data Load Parameters
  • 4.5.1 Key points about working with Data Load Parameters
  • 4.5.2 About editing Data Load Parameters
  • 4.5.3 About Editing Global Data Load Parameters
  • 4.5.4 About Editing Application Specific Parameter Values
  • 4.5.5 How to Edit a Data Load Parameter value
• 4.6 About Working With Reporting Parameters
• 4.7 How to Monitor Setup Data
• 4.8 How to Change Configuration Values Using Oracle BI Applications Configuration Manager
• 4.9 How to Locate Unmapped Domain Values in Oracle BI Applications Configuration Manager
• 4.10 How to Locate Data Load Parameters with no Values in Oracle BI Applications Configuration Manager
• 4.11 About Adding Target Domain Members
  • 4.11.1 How to add a Target Domain Member
• 4.12 Viewing Domain Hierarchies
• 4.13 About Exporting and Importing Setup Data for Oracle BI Applications Configuration Manager
  • 4.13.1 What Data is Exported?
  • 4.13.2 What Data is Imported?
  • 4.13.3 About Migrating Setup Data
  • 4.13.4 About Backing-up Setup Data
  • 4.13.5 How to Export Setup Data
  • 4.13.6 How to Import Setup Data

Part II Appendices

A Supporting Tasks

• A.1 How to Log Into Oracle BI Applications Configuration Manager

B Functional Configuration Task Reference

• B.1 Example Functional Configuration Tasks For Multiple Offerings
• B.2 Informational Task Reference - Miscellaneous
  • B.2.1 Getting Started With Functional Configuration
  • B.2.2 How to Add Closed Orders to Backlog Calculations
  • B.2.3 How to Include Non-booked Orders in Order Line and Schedule Line Tables
  • B.2.4 How to Track Multiple Attribute Changes in Bookings
  • B.2.5 Review Table Partitioning for Human Resource Analytics
  • B.2.6 How to Implement Accounts Receivable Security for PeopleSoft
  • B.2.7 How to Implement Accounts Payable Security for Oracle Fusion Applications
  • B.2.8 How to Set Up Accounts Payable Security for Oracle E-Business Suite
  • B.2.9 How to implement Accounts Payable Security for PeopleSoft
  • B.2.10 How to Set Up Accounts Receivable Security for Oracle Fusion Applications
  • B.2.11 How to Set Up Accounts Receivable Security for Oracle E-Business Suite
  • B.2.12 How to Deploy Objects in Oracle E-Business Suite for Exploding the Bill Of Materials
  • B.2.13 How To Configure JD Edwards EnterpriseOne Category Codes
  • B.2.14 How to Configure Self-Service Timecard Attributes to Business Object Natural Keys
  • B.2.15 How to Make Corrections to the Group Account Number Configuration for PeopleSoft
  • B.2.16 Configure Data Load Parameter for JD Edwards EnterpriseOne Rate Type
  • B.2.17 How to Add Dates to the Order Cycle Time Table for Post-Load Processing
  • B.2.18 How to Set Up Group Account Numbers for Oracle E-Business Suite
    • B.2.18.1 Overview of Mapping Oracle GL Accounts to Group Account Numbers
    • B.2.18.2 How to Map Oracle GL Account Numbers to Group Account Numbers
    • B.2.18.3 Example of Adding Group Account Number Metrics to the Oracle BI Repository
  • B.2.19 How to Set Up Group Account Numbers for Peoplesoft
    • B.2.19.1 Overview of Mapping GL Accounts to Group Account Numbers
    • B.2.19.2 How to Map GL Account Numbers to Group Account Numbers
  • B.2.20 How to Configure GL Account and GL Segments for Oracle E-Business Suite
    • B.2.20.1 Overview
    • B.2.20.2 Example of Data Configuration for a Chart of Accounts
    • B.2.20.3 How to Set Up the GL Segment Configuration File
    • B.2.20.4 How to Configure GL Segments and Hierarchies Using Value Set Definitions
  • B.2.21 How to Configure GL Account and GL Segments for Oracle PeopleSoft
  • B.2.22 How to Make Corrections to the Group Account Number Configuration for Oracle E-Business Suite
  • B.2.23 How to Configure Number of Days based Metrics for PeopleSoft
  • B.2.24 How to Update Dashboard Pages with PeopleSoft Prompts
  • B.2.25 How to Configure Original Job Requisition Status
  • B.2.26 How to Set Up Fixed Asset Security for Oracle Fusion Applications
  • B.2.27 How to Set Up Fixed Asset Security for E-Business Suite
  • B.2.28 How to Set Up Fixed Asset Security for PeopleSoft
  • B.2.29 How to Configure the Asset Category Dimension for E-Business Suite
  • B.2.30 How to Configure the Customer Costs Lines and Product Costs Lines Tables
    • B.2.30.1 About the Customer Costs Lines and Product Costs Lines Tables for Financial Profitability Analytics
    • B.2.30.2 How to Configure the Customer Costs Lines and Product Costs Lines Tables for Financial Profitability Analytics
  • B.2.31 How to Configure Budgets for Oracle General Ledger Analytics
    • B.2.31.1 About Configuring Universal Source Files
    • B.2.31.2 How to Import Budget Data into the Data Warehouse Through the Universal Adapter
  • B.2.32 How to Set Up Workforce Frozen Snapshots
  • B.2.33 How to Use Workforce Deployment Subject Area
  • B.2.34 How to Retrieve Information Stored in Flexfield Columns
  • B.2.35 How to Add Payroll Balances to BI Payroll Balance Group
    • B.2.35.1 Steps for Fusion
    • B.2.35.2 Steps for PeopleSoft Global Payroll
    • B.2.35.3 Steps for PeopleSoft North America Payroll
    • B.2.35.4 Steps for E-Business Suite
  • B.2.36 How to Configure Band Dimensions
  • B.2.37 How to control HR Future-Data Transaction Data Visibility
  • B.2.38 How to Set Up Manager Hierarchy Base Security for Peoplesoft
  • B.2.39 How To Configure Quarters for a Fiscal Time Dimensions
  • B.2.40 How to Map GL Accounts to Group Account Numbers for JD Edwards EnterpriseOne
    • B.2.40.1 Overview of Mapping GL Accounts to Group Account Numbers
    • B.2.40.2 How to Map GL Account Numbers to Group Account Numbers
  • B.2.41 How to Configure Incremental Extract for Projects Facts for PeopleSoft
    • B.2.41.1 How to Configure Incremental extract for projects facts for PeopleSoft Using DB Triggers
    • B.2.41.2 How to Configure Incremental extract for projects facts for PeopleSoft Using Materialized Views
  • B.2.42 How to Set Up Project Cost and Control Security for PeopleSoft
    • B.2.42.1 Security by Business Unit
    • B.2.42.2 Security by Project
    • B.2.42.3 Configuring BI Duty Roles
  • B.2.43 How to Set Up Project Billing and Revenue Security for Peoplesoft
    • B.2.43.1 Security by Business Unit
    • B.2.43.2 Security by Project
    • B.2.43.3 Configuring BI Duty Roles
  • B.2.44 How to Define New Groups and Mappings for Users and BI Roles
    • B.2.44.1 How to Use Fusion Middleware (FMW) to Provision an End User
    • B.2.44.2 How to Use An RPD Init Block to Provision an End User
  • B.2.45 How to Configure Projects Capitalizable Flag for PeopleSoft
  • B.2.46 How to Configure Project Budget Fact for Oracle E-Business Suite
  • B.2.47 How to Configure Project Cross Charge Fact for PeopleSoft
  • B.2.48 How to Configure Project Forecast Fact for Oracle E-Business Suite
  • B.2.49 How to Set Up Project Billing and Revenue Security For Oracle
    • B.2.49.1 Configuring BI Duty Roles
  • B.2.50 How to Extend the Project Task Hierarchy Dimension for E-Business Suite
  • B.2.51 How to Configure Project Customer in Projects Analytics for E-Business Suite
  • B.2.52 How to Configure Project Classification Dimension in Projects Analytics for Oracle E-Business Suite
  • B.2.53 How to Configure Project Funding Fact for E-Business Suite
  • B.2.54 How to Configure Projects Resource Class for PeopleSoft
    • B.2.54.1 Identify Resource Class based on a Source Type, Category, and Subcategory Combination of Values
    • B.2.54.2 Identifying Resource Class Based on a ChartField Combination of Values
  • B.2.55 How to Include Incomplete Invoice Lines
  • B.2.56 How to Set Up Project Cost and Control Security for Oracle Fusion
    • B.2.56.1 Configuring BI Duty Roles
  • B.2.57 How to Set Up CRM Primary Organization Based Security for Siebel
    • B.2.57.1 Configuring BI Duty Roles
  • B.2.58 How to Set Up CRM Primary Employee/Position Hierarchy Based Security for Siebel
    • B.2.58.1 Configuring BI Duty Roles
  • B.2.59 How to Configure Workforce Bypass Fast Formula
  • B.2.60 How to Disable Projects Invoice Line Fact in the RPD for Fusion Applications
    • B.2.60.1 How to Delete Unnecessary Metrics
    • B.2.60.2 How to Disable Invoice Line Fact
  • B.2.61 How to Set Up SIA Student Financial Security for Peoplesoft
  • B.2.62 How to Set Up SIA Administration Recruiting Security for Peoplesoft
  • B.2.63 How to Set Up SIA Student Records Security for Peoplesoft
  • B.2.64 How to Configure Projects Forecast Fact for PeopleSoft
  • B.2.65 How to Implement Security For Order Management Analytics
    • B.2.65.1 How to implement OM Inventory Org Based Security for EBS
    • B.2.65.2 How to implement OM Inventory Org Based Security for Oracle Fusion Applications
    • B.2.65.3 How to implement OM Operating Unit Org-based Security for EBS
    • B.2.65.4 How to implement OM Operating Unit Org-based Security for Oracle Fusion Applications
    • B.2.65.5 How to Grant Cross Functional Access to Order Management Users
  • B.2.66 How to Deploy Audit Trail Stored Procedures
  • B.2.67 How to Configure Aggregate tables for Inventory Balances and Transactions
  • B.2.68 How to Deploy the Stored Procedure for the Left Bound and Right Bound Calculation Option
    • B.2.68.1 How to Configure the Left Bound and Right Bound Calculation Option
  • B.2.69 How to Configure Hours Per Absence Day
  • B.2.70 How to Configure Payroll Balance Filter
  • B.2.71 How to Configure Accrual Extract Months for Incremental ETL
  • B.2.72 How to Add New Country Code
  • B.2.73 How to Configure Accrual Fast Formula Function Calls
  • B.2.74 How to set up HR Supervisor Hierarchy Based Data Security
    • B.2.74.1 Introduction
    • B.2.74.2 Line Manager (secured by HR Supervisor Hierarchy List) AU BI Data
    • B.2.74.3 Payroll Manager (secured by HR Supervisor Hierarchy List) AU BI Data
    • B.2.74.4 Compensation Analyst (secured by HR Supervisor Hierarchy List) AU BI Data
    • B.2.74.5 Compensation Manager (secured by HR Supervisor Hierarchy List) AU BI Data
    • B.2.74.6 Recruiting Manager (secured by HR Supervisor Hierarchy List) AU BI Data
    • B.2.74.7 Recruiting VP (secured by HR Supervisor Hierarchy List) AU BI Data
    • B.2.74.8 Time Collection Manager (secured by HR Supervisor Hierarchy List) AU BI Data
    • B.2.74.9 Human Resource VP (secured by HR Supervisor Hierarchy List) AU BI Data
    • B.2.74.10 Human Resource Analyst (secured by HR Supervisor Hierarchy List) AU BI Data
    • B.2.74.11 Human Resource Manager (secured by HR Supervisor Hierarchy List) AU BI Data
    • B.2.74.12 Learning Manager (secured by HR Supervisor Hierarchy List) AU BI Data
    • B.2.74.13 HR Duty Role to Oracle BI Applications HR Presentation Catalog Mapping
  • B.2.75 How to set up Department Based Data Security
    • B.2.75.1 Introduction
    • B.2.75.2 Line Manager (secured by Department List) AU BI Data
    • B.2.75.3 Payroll Manager (secured by Department List) AU BI Data
    • B.2.75.4 Compensation Analyst (secured by Department List) AU BI Data
    • B.2.75.5 Compensation Manager (secured by Department List) AU BI Data
    • B.2.75.6 Recruiting Manager (secured by Department List) AU BI Data
    • B.2.75.7 Recruiting VP (secured by Department List) AU BI Data
    • B.2.75.8 Time Collection Manager (secured by Department List) AU BI Data
    • B.2.75.9 Human Resource VP (secured by Department List) AU BI Data
    • B.2.75.10 Human Resource Analyst (secured by Department List) AU BI Data
    • B.2.75.11 Human Resource Manager (secured by Department List) AU BI Data
    • B.2.75.12 Learning Manager (secured by Department List) AU BI Data
    • B.2.75.13 HR Duty Role to Oracle BI Applications HR Presentation Catalog Mapping
  • B.2.76 How to Set Up Price Analytics Security for EBS
  • B.2.77 How to Perform RPD Modifications for Cost and Revenue Time Grain Changes
    • B.2.77.1 Setting the Time Grain Parameters in FSM
    • B.2.77.2 Changing the Time Grain of the Cost Aggregate table to Fiscal/Project/Enterprise Period
    • B.2.77.3 Changing the Time Grain of the Revenue Aggregate table to Fiscal/Project/Enterprise Period
    • B.2.77.4 Changing the Time Grain of the Cost Aggregate table to Fiscal/Project/Enterprise Quarter
    • B.2.77.5 Changing the Time Grain of the Revenue Aggregate table to Fiscal/Project/Enterprise Quarter
    • B.2.77.6 Changing the Time Grain of the Cost Aggregate table to Fiscal/Project/Enterprise Year
    • B.2.77.7 Changing the Time grain of the Revenue Aggregate table to Fiscal/Project/Enterprise Year
  • B.2.78 How to configure E-Business Suite Accrual Extract Mode
  • B.2.79 How to Configure GL Account Hierarchies using FSG definitions for E-Business Suite
  • B.2.80 How to Configure Domains and Member Mappings for Employment Dimension
  • B.2.81 How to Configure Projects Costing Burden Cost for PeopleSoft
    • B.2.81.1 Identifying Project Cost Burden Costs based on Analysis Type
    • B.2.81.2 Identifying Project Cost Burden Costs based on a Source Type, Category, and Subcategory Combination of Values
  • B.2.82 How to Configure Project Commitment Fact for EBS
  • B.2.83 Manage Domains and Member Mappings for Time and Labor - Reported Time
  • B.2.84 How to set up HR Position Hierarchy Based Data Security
    • B.2.84.1 Introduction
    • B.2.84.2 Line Manager (secured by HR Position Hierarchy List) AU BI Data
    • B.2.84.3 Payroll Manager (secured by HR Position Hierarchy List) AU BI Data
    • B.2.84.4 Compensation Analyst (secured by HR Position Hierarchy List) AU BI Data
    • B.2.84.5 Compensation Manager (secured by HR Position Hierarchy List) AU BI Data
    • B.2.84.6 Recruiting Manager (secured by HR Position Hierarchy List) AU BI Data
    • B.2.84.7 Recruiting VP (secured by HR Position Hierarchy List) AU BI Data
    • B.2.84.8 Time Collection Manager (secured by HR Position Hierarchy List) AU BI Data
    • B.2.84.9 Human Resource VP (secured by HR Position Hierarchy List) AU BI Data
    • B.2.84.10 Human Resource Analyst (secured by HR Position Hierarchy List) AU BI Data
    • B.2.84.11 Human Resource Manager (secured by HR Position Hierarchy List) AU BI Data
    • B.2.84.12 Learning Manager (secured by HR Position Hierarchy List) AU BI Data
    • B.2.84.13 HR Duty Role to Oracle BI Applications HR Presentation Catalog Mapping
  • B.2.85 How to set up Payroll Legislative Data Group Based Data Security
  • B.2.86 How to set up Payroll Based Data Security
  • B.2.87 How to Configure Workforce Revalidate Option
  • B.2.88 How to Manage Domains and Member Mappings for Recruitment Event Type
  • B.2.89 How to Set Up Project GL Reconciliation Security for Peoplesoft
    • B.2.89.1 Configuring BI Duty Roles
  • B.2.90 How to Configure Project Commitment Fact for PeopleSoft
  • B.2.91 How to Set Up Project Resource Management Security for Peoplesoft
    • B.2.91.1 Security by Business Unit
    • B.2.91.2 Security by Project
    • B.2.91.3 Configuring BI Duty Roles
  • B.2.92 How to Set Up RPD For Budgetary Control For PeopleSoft
  • B.2.93 How to Set Up General Ledger Security for Peoplesoft
    • B.2.93.1 Configuring Ledger Security
    • B.2.93.2 Configuring GL Segment Security using PeopleSoft Chartfields
    • B.2.93.3 Configuring GL Segment Security
    • B.2.93.4 Configuring BI Duty Roles
  • B.2.94 How to Set Up Project GL Reconcilliation Security for PeopleSoft
    • B.2.94.1 Configuring BI Duty Roles
  • B.2.95 How to Configure Project Budget Fact for PeopleSoft
  • B.2.96 How to Set Up General Ledger Security for E-Business Suite
    • B.2.96.1 Configuring Ledger Security
    • B.2.96.2 Configuring GL Segment Security
    • B.2.96.3 Configuring BI Duty Roles
  • B.2.97 How to Set Up General Ledger Security for Fusion Applications
    • B.2.97.1 Introduction
    • B.2.97.2 Configuring GL Segment Security
  • B.2.98 How to Configure Financial Analytics CSV Files for JD Edwards EnterpriseOne
    • B.2.98.1 How to Configure the file_lkp_fiscal_period_Qtr_Config_jde.csv
  • B.2.99 How to Set Up CRM Territory Hierarchy Based Security for Oracle Fusion
    • B.2.99.1 Configuring BI Duty Roles
  • B.2.100 How to Configure the Asset Location Dimension for E-Business Suite
  • B.2.101 How to Configure Project Invoice Fact for E-Business Suite
  • B.2.102 How to Set Up Project Billing and Revenue Security for E-Business Suite
    • B.2.102.1 Configuring BI Duty Roles
  • B.2.103 How to Set Up CRM Resource Organization Based Security for Oracle Fusion
    • B.2.103.1 Configuring BI Duty Roles
  • B.2.104 How to Configure Flat Files For Order Item Fact E-Business Suite
  • B.2.105 How to Configure Flat Files For Price Segment Dimension For E-Business Suite
  • B.2.106 How to Configure Flat Files For Price Strategy Dimension For E-Business Suite
  • B.2.107 How to Configure Flat Files For Price Waterfall Element Dimension For E-Business Suite
  • B.2.108 How to Configure Flat Files For Quote Item Fact For E-Business Suite file_quoteitem_fs.csv
  • B.2.109 How to Configure Flat Files For Source Domains in Price Analytics for E-Business Suite
  • B.2.110 How to Configure Flat Files in Price Analytics for E-Business Suite
  • B.2.111 How to Configure Flat Files For Source Domains in Price Analytics for Siebel Applications
    • B.2.111.1 How to Configure Source Domain Member Name Values
    • B.2.111.2 How To Configure Conformed Domain Members
    • B.2.111.3 Default Seeded Domain Members
  • B.2.112 How To Configure Flat Files in Price Analytics for Siebel Applications
    • B.2.112.1 Configuration Required Before a Full Load for Oracle Price Analytics
    • B.2.112.2 Price Waterfall Element Sample Data
  • B.2.113 How to Configure Flat Files For Source Domains in Price Analytics for Universal
    • B.2.113.1 How to Configure Source Domain Member Name Values
    • B.2.113.2 How To Configure Conformed Domain Members
    • B.2.113.3 Default Seeded Domain Members
  • B.2.114 How to Set Up Price Analytics Security for Siebel Applications
    • B.2.114.1 Configuring BI Duty Roles
  • B.2.115 How to configure UOMs
  • B.2.116 How to Set Up Default Fiscal Calendars for PeopleSoft
  • B.2.117 How to Configure Cost Fact In Projects Analytics for EBS
  • B.2.118 How to configure Project UOM for E-Business Suite
  • B.2.119 How to Set Up Project Cost and Control Security for E-Business Suite
    • B.2.119.1 Configuring BI Duty Roles
  • B.2.120 How to Configure Project Retention Fact for PeopleSoft
    • B.2.120.1 How to enable Retention Fact
    • B.2.120.2 How to un-map extraneous metric definitions
  • B.2.121 How to implement Security for Supply Chain Analytics
    • B.2.121.1 Configuring BI Duty Roles
  • B.2.122 How to Configure Job Dimension in Projects Analytics for E-Business Suite
    • B.2.122.1 How to Extend the Project Task Hierarchy Dimension for E-Business Suite
    • B.2.122.2 How to Configure Project Customer in Projects Analytics for E-Business Suite
    • B.2.122.3 About Configuring Project Classification Dimension in Projects Analytics for E-Business Suite
    • B.2.122.4 About Configuring Project Funding Fact for E-Business Suite
  • B.2.123 How to Configure Projects GL Reconciliation Solution for E-Business Suite 11.5.10
  • B.2.124 Additional Information About GL Reconcilliation in Project Analytics
    • B.2.124.1 Overview
    • B.2.124.2 Configuring ETL Parameters
  • B.2.125 How to Set Up CRM Partner Organization Based Security for Oracle Fusion
    • B.2.125.1 Configuring BI Duty Roles
  • B.2.126 How to Configure Projects GL Reconciliation Manual Journal Entries
  • B.2.127 How to Define Aging Bucket Ranges in Accounts Payable and Accounts Receivable
  • B.2.128 Manage Domains and Member Mappings for Timecard Entry Status
  • B.2.129 Manage Domains and Member Mappings for Payroll Balance Dimension
  • B.2.130 How to Set Up Service Analytics Security for Siebel
  • B.2.131 How to implement Inventory Org Based Security for EBS Manufacturing Analytics
  • B.2.132 How to Perform System Setups and Post Install Tasks for BI Applications
  • B.2.133 How to Set Up Drill Down in Oracle BI from General Ledger to Subledger
  • B.2.134 How to Integrate Financial Analytics with Project Analytics
  • B.2.135 How to Implement Asset Category and Asset Location Dimensions in Fusion Application
  • B.2.136 How to Implement GL Segment, GL Account, Asset Category and Asset Location Dimensions for Fusion Applications
    • B.2.136.1 Configuring the BI Extender
    • B.2.136.2 Configuring GL Segment and GL Account Dimensions
  • B.2.137 How To Customize Extended Cross Functional Security for Employee Expenses
  • B.2.138 How To Customize Extended Cross Functional Security for Accounts Payables
  • B.2.139 How to Grant GL Data Role to HR VP Users
  • B.2.140 How to Assign Group Account Numbers to Natural Accounts for HR Analytics
  • B.2.141 How to Set Up Group Account Numbers for Fusion Applications
  • B.2.142 How to Set up GL Segments Which Need to be Aggregated for GL Balances
  • B.2.143 How To Customize Security for Procurement Executive / Spend Analyst
  • B.2.144 How to Remove Spend Classification Integration Metadata
  • B.2.145 How to Enable Project Dimensions
  • B.2.146 How to Integrate Project Analytics with Financial Analytics
  • B.2.147 How to Configure Order Item and Service Request Flat Files For ETL
    • B.2.147.1 Flat file file_orderitem_fs.csv
    • B.2.147.2 Flat file file_srvreq_fs.csv
    • B.2.147.3 Flat file file_srvreq_ds.csv
  • B.2.148 How to Incrementally Refresh the Inventory Monthly Balance Table
  • B.2.149 How to Configure the Product Transaction Aggregate Table for ETL Runs
  • B.2.150 How to Process Bill of Material Explosion for JD Edwards EnterpriseOne
  • B.2.151 Manage Domains and Member Mappings for Timecard Entry Type Dimension
  • B.2.152 How to Set Up the C_STATE_PROV Domain
  • B.2.153 How to Configure Flat Files for Spend Planning
    • B.2.153.1 How to configure flat files
  • B.2.154 How to Configure Projects Resource Management Work Type Dimension for PeopleSoft
  • B.2.155 How to Configure Project Revenue Fact for E-Business Suite
    • B.2.155.1 Overview of Configuring Cost Fact for Oracle E-Business Suite
    • B.2.155.2 How to Configure the Project Cost Aggregate Table
    • B.2.155.3 Configuring Revenue Fact for E-Business Suite
    • B.2.155.4 How to Configure the Project Revenue Aggregate Table
    • B.2.155.5 How To Configure Project Uom For E-Business Suite
  • B.2.156 How to Set Up CRM Partner Channel Based Security for Oracle Fusion
    • B.2.156.1 Configuring BI Duty Roles
  • B.2.157 How to Configure SIA Presentation Hierarchy in RPD
  • B.2.158 How to Configure Backlog Period
  • B.2.159 How to Reload the Time Dimension Tables After the Data Warehouse Is Loaded
  • B.2.160 How to Set Up CRM Partner Account Team Based Security for Oracle Fusion
    • B.2.160.1 Configuring BI Duty Roles
  • B.2.161 How to Set Up Project Resource Management Security for E-Business Suite
    • B.2.161.1 Configuring BI Duty Roles
  • B.2.162 How to Implement Procurement and Spend Analytics Security
    • B.2.162.1 How to implement Hierarchy Based Security for Employee Expense Subject Areas
    • B.2.162.2 How to implement Org Based Security for Employee Expense Subject Areas
    • B.2.162.3 How to implement Procurement and Spend Subject Areas Security for Suppliers
    • B.2.162.4 How to implement Procurement and Spend Security for Procurement users
    • B.2.162.5 Other Security in Procurement and Spend
  • B.2.163 How to Configure Scorecard Target Before Running ETL
  • B.2.164 About Configuring Purchase Cycle Lines Aggregate Fact
  • B.2.165 About Configuring Purchase Receipts Aggregate Fact
  • B.2.166 How to Set Up CRM Resource Hierarchy Based Security for Oracle Fusion
    • B.2.166.1 Configuring BI Duty Roles
  • B.2.167 About Manage Domains and Member Mappings for Workforce Event
  • B.2.168 Integration of Procurement and Spend Analytics with Project Analytics
  • B.2.169 How to Integrate Procurement and Spend Analytics with Spend Classification
    • B.2.169.1 Overview to Oracle Spend Classification Integration
    • B.2.169.2 About the Oracle Spend Classification Metadata
    • B.2.169.3 How to deploy UNSPSC, Oracle Purchasing Categories, and Custom Category1
    • B.2.169.4 How to deploy the additional Custom Category2 and Custom Category3
  • B.2.170 How to Integrate Project Analytics with Financial Analytics
  • B.2.171 About Configuring Enterprise Calendars
  • B.2.172 How to Configure the Master Inventory Organization in Product Dimension Extract for Oracle 11i Adapter (Except for GL & HR Modules)
  • B.2.173 How to Assign UNSPSC Codes to Products
• B.3 Informational Task Reference - Security
• B.4 Informational Task Reference - ETL Notes and Overviews
  • B.4.1 Getting Started With Functional Configurations
  • B.4.2 ETL Notes and Additional Information for Oracle Project Analytics
  • B.4.3 ETL Notes and Additional Information for Service Analytics
  • B.4.4 ETL Notes and Additional Information for Oracle Procurement and Spend Analytics
  • B.4.5 ETL Notes and Additional Information for Supply Chain and Order Management Analytics
  • B.4.6 ETL Notes and Additional Information for Project Analytics
  • B.4.7 ETL Notes and Additional Information for Sales Analytics
  • B.4.8 ETL Notes and Additional Information for Product Information Management Analytics
  • B.4.9 ETL Notes and Additional Information for Partner Analytics
  • B.4.10 ETL Notes and Additional Information for Human Resources Analytics
  • B.4.11 ETL Notes and Additional Information for Marketing Analytics
  • B.4.12 ETL Notes and Additional Information for Financial Analytics
  • B.4.13 ETL Notes and Additional Information for Customer Data Management Analytics
  • B.4.14 Overview of Student Information Analytics
    • B.4.14.1 Admissions & Recruiting Overview
    • B.4.14.2 Student Records Overview
    • B.4.14.3 Student Financials Overview
  • B.4.15 Overview of Oracle Human Resources Analytics
  • B.4.16 Overview of Oracle Price Analytics
  • B.4.17 Overview of Service Analytics
  • B.4.18 Overview of Oracle Manufacturing Analytics
  • B.4.19 Overview of Supply Chain and Order Management Analytics
  • B.4.20 Overview of Marketing Analytics
  • B.4.21 Overview of Customer Data Management Analytics
  • B.4.22 Overview of Project Resource Management Analytics for PeopleSoft
    • B.4.22.1 About Project Resource Management Analytics for PeopleSoft and E-Business Suite
    • B.4.22.2 Notes on Project Resource Management Analytics for PeopleSoft
  • B.4.23 Overview of Project Resource Management Analytics for E-Business Suite
  • B.4.24 Overview of Project Analytics
  • B.4.25 Overview of Budgetary Control in Financial Analytics
  • B.4.26 Overview of Project GL Reconcilliation Analytics for E-Business Suite 11.5.10
  • B.4.27 Overview of GL Reconcilliation Analytics for E-Business Suite R12
  • B.4.28 Overview of Project GL Reconcilliation Analytics for PeopleSoft 9.0
  • B.4.29 Overview of Oracle Procurement and Spend Analytics
  • B.4.30 Overview of Product Information Management Analytics
  • B.4.31 Overview of Partner Analytics
  • B.4.32 Overview of Financial Analytics

C Dialog Reference for Oracle BI Applications Configuration Manager

• C.1 Add Warehouse Domain Member/Add Target Domain Member button
• C.2 Add Warehouse Domain Member/Add Target Domain Member dialog
• C.3 Edit Domain Member Mappings dialog
• C.4 Edit Parameter Value dialog (for Data Load Parameters)
• C.5 Edit Parameter Value dialog (for Reporting Parameters)
• C.6 Export Data dialog
• C.7 Export Setup Data dialog
• C.8 Import Data dialog
• C.9 Import Setup Data dialog
• C.10 Manage Data Load Parameters dialog
  • C.10.1 Icons on the Data Load Parameters dialog
• C.11 Manage Domains and Mappings: Domain Mappings tab
• C.12 Manage Externally Conformed Domains dialog
• C.13 Manage Domains and Mappings: Source Domains tab
• C.14 Manage Domains and Mappings: Warehouse Domains tab
• C.15 Manage Domains and Mappings: Warehouse Domain Hierarchies tab
• C.16 Manage Reporting Parameters: Global/Application Specific tab
• C.17 Overview Page for Oracle BI Applications Configuration Manager
• C.18 Search pane

Index