Skip Headers
Oracle® Business Intelligence Applications Configuration Guide for Informatica PowerCenter Users
Version 7.9.5.1
Part Number E13766-01
Home
Book List
Contents
Index
Contact Us
Previous
Next
View PDF
List of Tables
3-1 Tables in Base Table W_DAY_D Used to Store Calendar Information
3-2 Example of Hierarchy for US Acct Stored in W_HIERARCHY_D
3-3 Example Chart of Accounts
3-4 Example of Flattened Hierarchy Stored in W_HIERARCHY_D
3-5 Data Sources and Associated DATASOURCE_NUM_ID Values
3-6 Example Configuration of file_group_acct_codes_ora.csv
3-7 Internal Organization Hierarchy Mappings
4-1 Domain Values and CSV Worksheet Files for Oracle Procurement and Spend Analytics
5-1 Domain Values and CSV Worksheet Files for Oracle Financial Analytics and Oracle EBS
5-2 Domain Values and CSV Worksheet Files for Oracle Financial Analytics
5-3 Example CSV Chartfield Mapping Values
5-4 Layout of file_group_acct_codes_psft.csv File
5-5 PeopleSoft Tree Structure Types
5-6 PeopleSoft Tree Level Types
5-7 How Node E Is Stored in W_HIERARCHY_D Table
5-8 Example of CSV Chartfield Mapping Values
5-9 Winter Loose-Level Tree
5-10 GL Chartfield Hierarchy
5-11 Internal Organization Hierarchy
5-12 General Ledger Chartfield Hierarchy Mappings
5-13 General Ledger Chartfield Hierarchy Mappings
5-14 Internal Organization Hierarchy Mappings
5-15 General Ledger Chartfield Hierarchy Mappings
5-16 Universal Source for Budget Fact (file_budget.csv)
5-17 Universal Source for Budget Fact (file_acct_budget.csv)
5-18 Populating the integration_id fields in Oracle EBS Source Systems
6-1 Domain Values and CSV Worksheet Files for Oracle Supply Chain and Order Management Analytics
6-2 Sales Order Table Columns With Parent/Child Relationships
6-3 Sales Order Table Columns Without Parent/Child Relationships
6-4 Oracle 11i and Oracle R12: Backlog History Table Entry as of February 1, 2001
6-5 Oracle 11i and Oracle R12: Backlog History Table Entry as of February 2, 2001
6-6 Oracle 11i: Backlog History Table Entry as of February 28, 2001
6-7 Oracle 11i and Oracle R12: Backlog History Table Entry as of March 1, 2001
6-8 Oracle 11i and Oracle R12: Backlog History Applicable Mappings and Expression Transformations
6-9 Oracle 11i and Oracle R12: Source System Table Row After Day One Activity
6-10 Oracle 11i and Oracle R12: W_SALES_BOOKING_LINE_F Table Row After Day One Activity
6-11 Oracle 11i and Oracle R12: Source System Table Row After Day Two Activity
6-12 Oracle 11i and Oracle R12: W_SALES_BOOKING_LINE_F Table Row After Day Two Activity
6-13 Variables for the bompexpl.exploder_userexit Stored Procedure
7-1 Domain Values and CSV Worksheet Files for Oracle HR Analytics
7-2 Classification Name Parameters
7-3 Domain Values and CSV Worksheet Files for HR Analytics for PeopleSoft HCM
7-4 Pay Elements for ETL
7-5 How PS_DEPT_TBL Populates W_INT_ORG_D
7-6 How PS_DEPT_TBL Populates W_INT_ORG_DH
7-7 How Detail Ranges Populate W_INT_ORG_D
7-8 How Detail Ranges Populate W_INT_ORG_DH
8-1 User Accelerator Responsibilities
8-2 Dashboards and data-level security that are assigned to each Usage Accelerator responsibility.
8-3 User Adoption Metrics
8-4 Opportunity Updates Metrics
8-5 Information Completeness Metrics
8-6 Coverage Metrics
8-7 Seed data files
8-8 Import commands
8-9 Usage Accelerator Analytics Adapter Files
9-1 Setting up activities and date boundaries
9-2 Example records in the W_ACD_EVENT_F table
9-3 Example records in the W_ACD_EVENT_PE table
9-4 Example records in the W_ACD_EVENT_F_DEL table
9-5 Example records in the W_ACD_EVENT_F table
9-6 Date Columns and Flat Files
9-7 Configurable Flag Values and Descriptions
9-8 Expressions and Task Names
9-9 Example Call Events in a Navigation Profile
9-10 Example Navigation Path IDs
10-1 Invoice Fact Table Example
10-2 Oracle BI Repository Date Variables
10-3 Repository User Groups
11-1 Formats to Derive INTEGRATION_ID
11-2 Dimensions that are required using the SCD Category 2 update
11-3 Records Before a Wrapper Session in W_CUSTOMER
11-4 Records After a Wrapper Session in W_CUSTOMER
11-5 Columns in Code Mapplet
11-6 Columns Used in the load mapping Dimension Key Lookup