Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Release Notes

• 1.1 How to Use These Release Notes
• 1.2 General Issues and Workarounds
  • 1.2.1 New Password for BI Server Repository File OracleBIAnalyticsApps.rpd
  • 1.2.2 Certification Information
  • 1.2.3 Installation and Upgrade
    • 1.2.3.1 Oracle WebLogic NodeManager Must Be Running Before Oracle BI Applications Installation
    • 1.2.3.2 Mandatory Patch for Data Warehouse Administration Console
    • 1.2.3.3 Review the System Requirements and Supported Platforms Guide for Release 7.9.6.3 Requirements
    • 1.2.3.4 Setting the Accept Source Flag when using the DAC Upgrade/Merge Wizard
    • 1.2.3.5 Link to Upgrade Guide in the Documentation Media Library Might Not Work
    • 1.2.3.6 Errors and Warnings Reported During RPD Upgrade
    • 1.2.3.7 Upgrading the DAC Repository When Also Upgrading the Source System
    • 1.2.3.8 Unzipping Informatica PowerCenter ZIP Files
    • 1.2.3.9 Configuring the Policy Store in Non-English Environments
    • 1.2.3.10 Setting Integration Services Custom Property 'OraDateToTimestamp'
    • 1.2.3.11 Issue With OracleBIAnalyticsApps.rpd When Installing Oracle BI Applications 7.9.6.3 on a Japanese Windows machine
    • 1.2.3.12 Installing DAC on a 64-bit System
  • 1.2.4 Documentation Corrections
    • 1.2.4.1 Corrections to Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users
    • 1.2.4.2 Corrections to Oracle Business Intelligence Applications Configuration Guide for Informatica PowerCenter Users
    • 1.2.4.3 Corrections to Oracle Business Intelligence Applications Upgrade Guide for Informatica PowerCenter Users
    • 1.2.4.4 Corrections to Oracle Business Intelligence Data Warehouse Administration Console Guide
    • 1.2.4.5 Corrections to Oracle Business Analytics Warehouse Data Model Reference
    • 1.2.4.6 Corrections to Oracle Business Intelligence Applications Security Guide
• 1.3 Oracle Business Intelligence Applications: General
  • 1.3.1 Lack of Time Zone Setting Prevents Delivery of iBots to Applications Users
  • 1.3.2 Issue with Exchange Rates and Transaction Currencies
  • 1.3.3 Contact Geography Attributes in Campaign Contacts_Segmentation Catalog Do Not Join Appropriately
  • 1.3.4 Issues with Multi-Source ETL
  • 1.3.5 Email Personalization for Siebel 8.0
    • 1.3.5.1 Updating the Repository
    • 1.3.5.2 Updating the Campaign Load Format and Email Server Format
  • 1.3.6 Error in Reports Based on 'Opportunity' Under Opportunity Contact Segmentation
  • 1.3.7 'STAT' Currency Journals or Accounts in Financial Analytics
  • 1.3.8 Joining Campaign History Fact With Industry Dimension with Oracle Marketing Analytics
  • 1.3.9 Employee Headcount Returns Null When Combined With Absence Type in Oracle HR Analytics
  • 1.3.10 Learning Error When Selecting Learning Course and Activity in Oracle Human Resource Analytics
  • 1.3.11 Division Name Pointing To An Obsolete Column In Oracle Sales Analytics
  • 1.3.12 Tasks Not Auto-Generated When Subject Area is Assembled for JDE With Oracle Financial Analytics
  • 1.3.13 Revenue Ago Metrics Using GL_Accounting_Period_WID Not Supported by PSFT in Oracle Project Analytics
  • 1.3.14 ACTIVE_FLG Column Not Populated Correctly in W_XACT_TYPE_D in Oracle Project Analytics
  • 1.3.15 Writeoff LOC Amounts and Exchange Rates Incorrect in Oracle Project Analytics
  • 1.3.16 Potential Performance Issue in Absence ETL Mapping SDE_ORA_ABSENCEEVENT_FULL
  • 1.3.17 Duplicate Rows in W_PRODCAT_DH Tables
  • 1.3.18 ORA-00604: Error Reported During ETL
  • 1.3.19 Loyalty AN Metric "# OF MEMBERS" Gives Incorrect Results When Grouped by Quarter
  • 1.3.20 TREE_FLAG Attribute in Segment Dimension W_SEGMENT_D is Derived Incorrectly in Oracle Marketing Analytics
  • 1.3.21 Marketing - Actual Cost Metric Is Mapped to the Wrong Source Fields in Oracle Marketing Analytics
  • 1.3.22 Numeric Overflow Error When Targeting Teradata
  • 1.3.23 How to Secure the Employee Dimension in Oracle HR Analytics
  • 1.3.24 DIM - CUSTOMER"."HIERARCHY BASED LOGIN" Defined Incorrectly In The BI Repository RPD
  • 1.3.25 Missing Records When Filtering Reports By Project Organization Name in Oracle Project Analytics
  • 1.3.26 Employee Name (From Position Dimension) Shows Incorrectly In Reports
  • 1.3.27 Available Inventory Value NULL in W_INVENTORY_DAILY_BAL_F for Average Costing Organization
  • 1.3.28 Currency Conversion Not Done in Purchase Agreement for Oracle Procurement and Spend Analytics
  • 1.3.29 Performance Issue with PLP_GLBALANCEAGGRBYACCTSEGCODS
  • 1.3.30 'Other Operating Expenses' Not Included in Profit and Loss Reports
  • 1.3.31 Chargeback Transactions Not Included in AR Aging Report
  • 1.3.32 'Days Payables Outstanding' and 'AP Turnover' Columns Are Missing
  • 1.3.33 Error During Import Of New Schema Definitions Into Siebel Transactional Database
  • 1.3.34 SDE_PSFT_GLJournals_Extract_Full Fails Due to Data Type Mismatch
  • 1.3.35 SIL_GLAccountDimension_HierarchyUpdate Task Fails on DB2
  • 1.3.36 Error in SIL_HouseholdDimension_SCDUpdate_Full Mapping
  • 1.3.37 Intermittent Communication Failure Between DAC and Informatica
  • 1.3.38 Recruitment Metric "Time to Fill (Days)" Has Incorrect Denominator
  • 1.3.39 SIL_EmployeeDimension_SCDUpdate Hangs in Incremental Load With SQL Server 2005
  • 1.3.40 Issue with DB2 9.1 Databases During Full ETL Loads
  • 1.3.41 Country and State Names in mplt_CODES_GeographDimension Mapplet Fail for JD Edwards Source Systems
  • 1.3.42 Querying Across Subject Areas
  • 1.3.43 Oracle EBS 12.1.3 - Contract Lifecycle Management Impact on Oracle BI Applications Release 7.9.6.3
  • 1.3.44 Task PLP_APXACTSGROUPACCOUNT_A1_LOAD Takes a Long Time to Complete
  • 1.3.45 Project Chartfields Missed in GL Balance Extract
  • 1.3.46 COGS SDE Mappings Might Fail When Sourcing From Multiple EBS 11i Instances
  • 1.3.47 GL Journals Using Wrong Currency Conversion Date
  • 1.3.48 W_GL_BALANCE_F_U1 Index Creation Fails When Loading From PeopleSoft Financials
  • 1.3.49 SDE_ORA_APTRANSACTIONFACT_DISTRIBUTIONS Uses Incorrect Extract Date
  • 1.3.50 Verify Data Warehouse Tables After ETL with DB2 UDB v9.7 and Siebel 8.1.1
  • 1.3.51 PLP_LoyMemberTierMovementQtrAggr fails On Non-Oracle Databases for Oracle Loyalty Analytics
  • 1.3.52 Dashboard Tooltips Are Displayed In English Only
  • 1.3.53 Metrics Error in Next Product Purchased Report in B2B Customer Insight Dashboard
  • 1.3.54 Truncate Should Always Be Set For W_POSITION_DH_PRE_CHG_TMP TABLE In DAC
  • 1.3.55 Recruitment Showing Incorrect Hire Date for Internal Applicant
  • 1.3.56 EXPENSE_INVOICE_POSTED_DT Not Pulled From AP_CHECKS_ALL.CHECK_DATE for Oracle E-Business Suite
• 1.4 Teradata-specific Issues
  • 1.4.1 Teradata Connection Configuration
  • 1.4.2 Sales Analytics Reports With Top 'N' Filters Error Against Teradata
  • 1.4.3 PLP_LoyMemberTierMovementQtrAggr Fails on Teradata Databases
  • 1.4.4 SIEBEL SIA: Interval Field Overflow Error On Teradata Database