Contents

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Release Notes

• 1.1 How to Use These Release Notes
  • 1.1.1 Oracle Business Intelligence Applications Issues and Workarounds Identified Since the Previous Revision
• 1.2 Installation, Upgrade, and Documentation Issues and Workarounds
  • 1.2.1 Installation and Upgrade
    • 1.2.1.1 Oracle BI Applications V7.9.6.4 Installer Does Not Validate The BI EE Minimum Version
    • 1.2.1.2 New Password for BI Server Repository File OracleBIAnalyticsApps.rpd
    • 1.2.1.3 Oracle WebLogic NodeManager Must Be Running Before Oracle BI Applications Installation
    • 1.2.1.4 Mandatory Patch for Data Warehouse Administration Console
    • 1.2.1.5 Review the System Requirements and Supported Platforms Guide for Release 7.9.6.3 Requirements
    • 1.2.1.6 Setting the Accept Source Flag when using the DAC Upgrade/Merge Wizard
    • 1.2.1.7 Errors and Warnings Reported During RPD Upgrade
    • 1.2.1.8 Upgrading the DAC Repository When Also Upgrading the Source System
    • 1.2.1.9 Unzipping Informatica PowerCenter ZIP Files
    • 1.2.1.10 Configuring the Policy Store in Non-English Environments
    • 1.2.1.11 Setting Integration Services Custom Property 'OraDateToTimestamp'
    • 1.2.1.12 Issue With OracleBIAnalyticsApps.rpd When Installing Oracle BI Applications on a Japanese Windows machine
    • 1.2.1.13 Installing DAC on a 64-bit System
    • 1.2.1.14 Oracle BI Applications Uninstaller Issue on Non-English Platforms
    • 1.2.1.15 Compatibility Mode for DAC Installer on Windows 2008 R2
    • 1.2.1.16 Installing Informatica PowerCenter Client
    • 1.2.1.17 Upgrade Maps Fails Due to Invalid Source and Target Configuration In Session
    • 1.2.1.18 Upgrade Maps Fail Due To Invalid Parameter File Configuration
    • 1.2.1.19 File 7964_UPGRADE_POST_SCRIPT.SQL Not Required for Version 7.9.6.4 Upgrade
    • 1.2.1.20 Application Roles Missing From JAZN File For MFG, EAM
    • 1.2.1.21 Upgrading from Version 7.9.6.2 to Version 7.9.6.3
    • 1.2.1.22 Query Indices Are Not Created After Upgrade
    • 1.2.1.23 Error in 'UPGRADE_FACTS' Workflow Causes 'ORA-00001: unique constraint (OBI_DW.W_AR_BALANCE_F_U1) violated'
    • 1.2.1.24 Informatica PowerCenter Version 9.5.1 Hot Fix 2
  • 1.2.2 Documentation Corrections
    • 1.2.2.1 Corrections to Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users
    • 1.2.2.2 Corrections to Oracle Business Intelligence Applications Configuration Guide for Informatica PowerCenter Users
    • 1.2.2.3 Corrections to Oracle Business Intelligence Applications Upgrade Guide for Informatica PowerCenter Users
    • 1.2.2.4 Corrections to Oracle Business Analytics Warehouse Data Model Reference
    • 1.2.2.5 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 Currency Conversion Not Done in Purchase Agreement for Oracle Procurement and Spend Analytics
  • 1.3.28 Performance Issue with PLP_GLBALANCEAGGRBYACCTSEGCODS
  • 1.3.29 'Other Operating Expenses' Not Included in Profit and Loss Reports
  • 1.3.30 Chargeback Transactions Not Included in AR Aging Report
  • 1.3.31 'Days Payables Outstanding' and 'AP Turnover' Columns Are Missing
  • 1.3.32 Error During Import Of New Schema Definitions Into Siebel Transactional Database
  • 1.3.33 SDE_PSFT_GLJournals_Extract_Full Fails Due to Data Type Mismatch
  • 1.3.34 SIL_GLAccountDimension_HierarchyUpdate Task Fails on DB2
  • 1.3.35 Error in SIL_HouseholdDimension_SCDUpdate_Full Mapping
  • 1.3.36 Recruitment Metric "Time to Fill (Days)" Has Incorrect Denominator
  • 1.3.37 SIL_EmployeeDimension_SCDUpdate Hangs in Incremental Load With SQL Server 2005
  • 1.3.38 Issue with DB2 9.1 Databases During Full ETL Loads
  • 1.3.39 Country and State Names in mplt_CODES_GeographDimension Mapplet Fail for JD Edwards Source Systems
  • 1.3.40 Querying Across Subject Areas
  • 1.3.41 Oracle EBS 12.1.3 - Contract Lifecycle Management Impact on Release 7.9.6.3
  • 1.3.42 Task PLP_APXACTSGROUPACCOUNT_A1_LOAD Takes a Long Time to Complete
  • 1.3.43 Project Chartfields Missed in GL Balance Extract
  • 1.3.44 COGS SDE Mappings Might Fail When Sourcing From Multiple EBS 11i Instances
  • 1.3.45 GL Journals Using Wrong Currency Conversion Date
  • 1.3.46 W_GL_BALANCE_F_U1 Index Creation Fails When Loading From PeopleSoft Financials
  • 1.3.47 SDE_ORA_APTRANSACTIONFACT_DISTRIBUTIONS Uses Incorrect Extract Date
  • 1.3.48 Verify Data Warehouse Tables After ETL with DB2 UDB v9.7 and Siebel 8.1.1
  • 1.3.49 PLP_LoyMemberTierMovementQtrAggr fails On Non-Oracle Databases for Oracle Loyalty Analytics
  • 1.3.50 Dashboard Tooltips Are Displayed In English Only
  • 1.3.51 Metrics Error in Next Product Purchased Report in B2B Customer Insight Dashboard
  • 1.3.52 Truncate Should Always Be Set For W_POSITION_DH_PRE_CHG_TMP TABLE In DAC
  • 1.3.53 Recruitment Showing Incorrect Hire Date for Internal Applicant
  • 1.3.54 APPS User Providing Generic Access Violating SOX Compliance With Oracle EBS
  • 1.3.55 Changing the Time Grain of Cost Aggregate in Project Analytics
  • 1.3.56 Unspecified Row of W_DAY_D and W_MCAL_DAY_D With the Value 1/1/1901 Causes Errors in Reports
  • 1.3.57 Asset Activity Shows All Inventory Items
  • 1.3.58 CURRENT_DAY Variable Defaults To A Static Value Instead of a Dynamic Value
  • 1.3.59 FILE_GEO_COUNTRY.csv Missing For Universal Adaptor
  • 1.3.60 Manufacturing - Production Cost Subject Area Is Designed For Work Order Analysis
  • 1.3.61 Asset History and Asset Failure Analysis - Count of Failures Shows Zero When Time Dimension Is Null
  • 1.3.62 Enterprise Asset Management Report Descriptions Are Not Translated
  • 1.3.63 Failure in SDE_PRODUCTATTRIBUTENAMEDIMENSION_STEP1 With DB2 Database
  • 1.3.64 W_MFG_PROD_XACT_TMP Must Always Have All Records, Not Only Incremental Records
  • 1.3.65 Oracle BI Repository and BI Presentation Catalog Strings Not Translated
  • 1.3.66 Exchange Rate Not Calculating Using Current Values In JD Edwards
  • 1.3.67 Time Dimension Not Reported For Unapproved Requisitions
  • 1.3.68 Terminology Issues in Danish Language
  • 1.3.69 Save System-Wide Column Formats in Oracle BI EE Answers Not Available for Admin User
• 1.4 Teradata-specific Issues
  • 1.4.1 Teradata Connection Configuration
  • 1.4.2 CRM Analytics Reports With Top/Bottom 'N' Filters Error With Teradata DB
  • 1.4.3 PLP_LoyMemberTierMovementQtrAggr Fails on Teradata Databases
  • 1.4.4 SIEBEL SIA: Interval Field Overflow Error On Teradata Database