Skip Headers
Oracle® Fusion Middleware Configuration Guide for Oracle Business Intelligence Applications
11
g
Release 1 (11.1.1.7)
Part Number E36171-03
Home
Book List
Index
Contact Us
Next
PDF
·
Mobi
·
ePub
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