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 Source Systems and Database Platforms Not Supported
  • 1.2.2 Certification Information
  • 1.2.3 Installation and Upgrade
    • 1.2.3.1 Installation Error Caused by Invalid Characters in Installation Directory Names
    • 1.2.3.2 Setting the Accept Source Flag when using the DAC Upgrade/Merge Wizard
    • 1.2.3.3 Issues with Extracting Informatica PowerCenter Zipped Media Files
    • 1.2.3.4 796_UPGRADE_POST_SCRIPT.sql Fails to Drop Indexes During Upgrade
    • 1.2.3.5 Installer Generates Invalid RPD File for Oracle Pharma Sales Analytics (Disconnected)
    • 1.2.3.6 Missing Repository RPD Files in \OracleBI\Upgrade Folder
    • 1.2.3.7 Task SDE_PSFT_PROJECTDIMENSION_UPG796 Fails During Upgrade
    • 1.2.3.8 Correction in Siebel Repository Upgrade From V7.9.5.1 to V7.9.6
    • 1.2.3.9 JDE Upgrade - JDE Parameters Missing From 7961_UPG_PARAMS.TXT
    • 1.2.3.10 UPGRADE 7951->7961: W_DTL_FCST_F.OWNER_POSTN_DH_WID DIFFERENCES
    • 1.2.3.11 GLOBAL1_TAX_AMOUNTS GETTING NULL VALUES IN 796 TO 7961 UPGRADE
  • 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 Incorrect Username Displayed in the Greetings Message in Oracle Business Intelligence Interactive Dashboards
  • 1.3.7 Missing Language Folders
  • 1.3.8 Error in Reports Based on 'Opportunity' Under Opportunity Contact Segmentation
  • 1.3.9 Teradata Connection Configuration
  • 1.3.10 Installation Errors with Oracle Applications Server Advanced Security Option
  • 1.3.11 ODBC Error When Generating Reports from Some Reports
  • 1.3.12 'STAT' Currency Journals or Accounts in Financial Analytics
  • 1.3.13 Requisition Age Band Calculated in RPD Using Current Date
  • 1.3.14 Performance Issue with Activity Query
  • 1.3.15 Usage Accelerator Change from Fiscal to Calendar Based Analysis
  • 1.3.16 Joining Campaign History Fact With Industry Dimension with Oracle Marketing Analytics
  • 1.3.17 Incorrect Results for Points Accrued value with Oracle Loyalty Analytics
  • 1.3.18 Incorrect Results for Frequency Score with Oracle Loyalty Analytics
  • 1.3.19 Employee Headcount Returns Null When Combined With Absence Type in Oracle HR Analytics
  • 1.3.20 HR Event Metrics and Secondary Assignments in Oracle HR Analytics
  • 1.3.21 SEBL811:W_MKTG_LEAD_F.ACTL_COST_GLOBAL1_AMT Calculation Issue For Incremental Load
  • 1.3.22 Sessions In SDE_COSTLIST Workflow Marked As Impacted
  • 1.3.23 Reports With Ago Metrics Gives An Error If Year Is Set To Blank
  • 1.3.24 Actual Versus Budget Comparison Not Supported For PeopleSoft GL Standard Budgets
  • 1.3.25 Inconsistency in Installed Repository (RPD) for Oracle Service Analytics
  • 1.3.26 Installation Procedure for Oracle BI DAC Client on Windows Vista
  • 1.3.27 Inconsistent Metadata in Repository (RPD) for Oracle Supply Chain and Order Management Analytics
  • 1.3.28 Additional step for Upgrade to Oracle BI Applications 7.9.6 for Oracle EBS Users
  • 1.3.29 APPS User Providing Generic Access Violating SOX Compliance With Oracle EBS
  • 1.3.30 Implementation of Oracle Project Analytics with Oracle eBusiness Suite 11.5.10
  • 1.3.31 Index Error Messages Reported During ETL After Upgrade
  • 1.3.32 SDE_JDEE1_90_ADAPTOR: W_MCAL_PERIOD_D - Fiscal Period Name Incorrect
  • 1.3.33 JDE: W_AP_XACT_F - Additional Record Inserted During Incremental Load
  • 1.3.34 JDE: W_AR_XACT_F - Additional Record Inserted During Incremental Load
  • 1.3.35 Enabling Initialization Blocks Required For Calendars
  • 1.3.36 Application Connections for PeopleSoft PSFT Adapters
  • 1.3.37 Learning Error When Selecting Learning Course and Activity in Oracle Human Resource Analytics
  • 1.3.38 Fiscal Calendar on Time Dimension
  • 1.3.39 Division Name Pointing To An Obsolete Column In Oracle Sales Analytics
  • 1.3.40 SQL Error ORA-00923 in DAC With Oracle EBS In Oracle Procurement and Spend Analytics
  • 1.3.41 Tasks Not Auto-Generated When Subject Area is Assembled for JDE With Oracle Financial Analytics
  • 1.3.42 Configuring the DAC Parameter when Multicurrency Processing is Disabled in JD Edwards for Oracle Financial Analytics
  • 1.3.43 PLP_LoyMemberTierMovementQtrAggr fails On Non-Oracle Databases for Oracle Loyalty Analytics
  • 1.3.44 Metrics in AR Subject Area Not Displaying Properly in Oracle Financial Analytics
  • 1.3.45 Configuring Bill of Materials Explosion for Oracle Supply Chain and Order Management Analytics
  • 1.3.46 FIND_AUDIT_VALUES Transformation In SDE_OPTYSTGFACT Missing in Teradata Repository
  • 1.3.47 Revenue Ago Metrics Using GL_Accounting_Period_WID Not Supported by PSFT in Oracle Project Analytics
  • 1.3.48 Revenue Value Changing With Multi-Currency Option in Funding Subject Area in Oracle Project Analytics
  • 1.3.49 ACTIVE_FLG Column Not Populated Correctly in W_XACT_TYPE_D in Oracle Project Analytics
  • 1.3.50 Writeoff LOC Amounts and Exchange Rates Incorrect in Oracle Project Analytics
  • 1.3.51 Potential Performance Issue in Absence ETL Mapping SDE_ORA_ABSENCEEVENT_FULL
  • 1.3.52 Learning RPD Error When Selecting Learning Course and Learning Activity
  • 1.3.53 Duplicates Inserted in Incremental Loads
  • 1.3.54 Duplicate Rows in W_PRODCAT_DH Tables
  • 1.3.55 Approved Date is Shown as Junk Date
  • 1.3.56 ORA-00604: Error Reported During ETL
  • 1.3.57 Cost Center Name is Blank
  • 1.3.58 Loyalty AN Metric "# OF MEMBERS" Gives Incorrect Results When Grouped by Quarter
  • 1.3.59 % Received Early Calculated Incorrectly in Oracle Procurement and Spend Analytics – Purchase Cycle Lines Subject Area
  • 1.3.60 TREE_FLAG Attribute in Segment Dimension W_SEGMENT_D is Derived Incorrectly in Oracle Marketing Analytics
  • 1.3.61 Marketing - Actual Cost Metric Is Mapped to the Wrong Source Fields in Oracle Marketing Analytics
  • 1.3.62 Numeric Overflow Error When Targeting Teradata
  • 1.3.63 SIL_EmployeeDimension_SCDUpdate Hangs in Incremental Load With SQL Server 2005
  • 1.3.64 How to Secure the Employee Dimension in Oracle HR Analytics
  • 1.3.65 DIM - CUSTOMER"."HIERARCHY BASED LOGIN" Defined Incorrectly In The BI Repository RPD
  • 1.3.66 Issue With Oracle Resources Analytics In PLP_RecruitmentRequisitionAggregate_Load_Update Using Teradata DB as Target
  • 1.3.67 Incremental ETL Fails For Oracle E-Business Suite Version 11.5.10
  • 1.3.68 Issue With Oracle Resources Analytics In PLP_RecruitmentRequisitionAggregate_Load Using Teradata DB as Target
  • 1.3.69 Error in ETL - GRFDerive in Teradata
  • 1.3.70 Missing Records When Filtering Reports By Project Organization Name in Oracle Project Analytics
  • 1.3.71 ETL Failure In PLP_INVENTORYMONTHLYBALANCE With Teradata Database
  • 1.3.72 Rowsize Limitation in MS SQL Server
  • 1.3.73 Quote Item Fact Not Secured By Position Hierarchy
  • 1.3.74 Employee Name (From Position Dimension) Shows Incorrectly In Reports