Skip Headers
Oracle® Business Intelligence Applications Release Notes
Version 7.9.6
Part Number E14222-19
Home
Book List
Contact Us
Next
View PDF
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
New Password for BI Server Repository File OracleBIAnalyticsApps.rpd
1.2.3
Certification Information
1.2.4
Documentation for Oracle Business Intelligence Applications Version 7.9.6.2.
1.2.5
Installation and Upgrade
1.2.5.1
Mandatory Patch for Data Warehouse Administration Console
1.2.5.2
Review the System Requirements and Supported Platforms Guide for Release 7.9.6.2 Requirements
1.2.5.3
Installation Error Caused by Invalid Characters in Installation Directory Names
1.2.5.4
Setting the Accept Source Flag when using the DAC Upgrade/Merge Wizard
1.2.5.5
Issues with Extracting Informatica PowerCenter Zipped Media Files
1.2.5.6
796_UPGRADE_POST_SCRIPT.sql Fails to Drop Indexes During Upgrade
1.2.5.7
Installer Generates Invalid RPD File for Oracle Pharma Sales Analytics (Disconnected)
1.2.5.8
Missing Repository RPD Files in \OracleBI\Upgrade Folder
1.2.5.9
Task SDE_PSFT_PROJECTDIMENSION_UPG796 Fails During Upgrade
1.2.5.10
Correction in Siebel Repository Upgrade From V7.9.5.1 to V7.9.6
1.2.5.11
JDE Upgrade - JDE Parameters Missing From 7961_UPG_PARAMS.TXT
1.2.5.12
UPGRADE 7951 to 7961: W_DTL_FCST_F.OWNER_POSTN_DH_WID DIFFERENCES
1.2.5.13
GLOBAL1_TAX_AMOUNTS Getting Null Values in Siebel Service 796 to 7961 Upgrade
1.2.5.14
Installation Instructions For JD Edwards Source Systems
1.2.5.15
Missing Records in W_PURCH_COST and W_PURCH_COST_FS with Informatica PowerCenter 8.6.1 Hot Fix 10
1.2.5.16
PLP_SALESBACKLOGLINESFACT_LOAD_SCHEDULELINES Mapping Fails With Informatica PowerCenter 8.6.1 Hot Fix 10
1.2.5.17
Installing DAC on a 64-bit System
1.2.6
Documentation Corrections
1.2.6.1
Corrections to
Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users
1.2.6.2
Corrections to
Oracle Business Intelligence Applications Configuration Guide for Informatica PowerCenter Users
1.2.6.3
Corrections to
Oracle Business Intelligence Applications Upgrade Guide for Informatica PowerCenter Users
1.2.6.4
Corrections to
Oracle Business Intelligence Data Warehouse Administration Console Guide
1.2.6.5
Corrections to
Oracle Business Analytics Warehouse Data Model Reference
1.2.6.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
1.3.75
Available Inventory Value NULL in W_INVENTORY_DAILY_BAL_F for Average Costing Organization
1.3.76
Issue with DB2 9.1 Databases During Full ETL Loads
1.3.77
Currency Conversion Not Done in Purchase Agreement for Oracle Procurement and Spend Analytics
1.3.78
Physical Join Condition on DIM_W_CHNL_TYPE_D_SALES and FACT_W_SALES_ORDER_LINE_F
1.3.79
Prod_HierX_Codes and Prod_HierX_Names in W_PRODUCT_D Are Obsolete
1.3.80
Specifying a Fiscal Year End Date For a 4-4-5 Calendar Using REFERENCE_DATE
1.3.81
Performance Issue with PLP_GLBALANCEAGGRBYACCTSEGCODS
1.3.82
'OTHER OPERATING EXPENSES' NOT INCLUDED IN PROFIT AND LOSS REPORTS
1.3.83
'CHARGEBACK' TRANSACTIONS NOT INCLUDED IN AR AGING REPORT
1.3.84
'DAYS PAYABLES OUTSTANDING' AND 'AP TURNOVER' COLUMNS ARE MISSING
1.3.85
Error During Import Of New Schema Definitions Into Siebel Transactional Database
1.3.86
SDE_PSFT_GLJournals_Extract_Full Fails Due to Data Type Mismatch
1.3.87
SIL_GLAccountDimension_HierarchyUpdate Task Fails on DB2
1.3.88
Error in SIL_HouseholdDimension_SCDUpdate_Full Mapping
1.3.89
Intermittent Communication Failure Between DAC and Informatica
1.3.90
Recruitment Metric "Time to Fill (Days)" Has Incorrect Denominator
1.3.91
GL Journals Using Wrong Currency Conversion Date
1.3.92
SDE_ORA_APTRANSACTIONFACT_DISTRIBUTIONS Uses Incorrect Extract Date
1.3.93
COGS SDE Mappings Might Fail When Sourcing From Multiple EBS 11i Instances
1.3.94
Reloading Time Dimension Tables
1.3.95
Recruitment Showing Incorrect Hire Date for Internal Applicant
1.3.96
Project Chartfields Missed in GL Balance Extract
1.3.97
Task PLP_APXACTSGROUPACCOUNT_A1_LOAD Takes a Long Time to Complete
1.3.98
W_GL_BALANCE_F_U1 Index Creation Fails When Loading From PeopleSoft Financials
1.3.99
Setting Variables For SIL_TIMEDIMENSION_MCALPERIOD
1.3.100
DATASOURCE_NUM_ID Values
1.3.101
W_WRKFC_EVENT_TYPE_D Domain Values
1.3.102
Upgrading the DAC Repository When Also Upgrading the Source System
1.3.103
Setting Integration Services Custom Property "OraDateToTimestamp"