Tuesday, January 14, 2014

OBIEE BUNDLE PATCH 11.1.1.7.140114 AKA 11.1.1.7.4 (?) is available

Please note OBIEE Bundle Patch 11.1.1.7.151020 is available. You might prefer it.

OBIEE 11.1.1.7 third general bundle patch, 11.1.1.7.140114 is available in Patch 17886497:
Once again, failed to download it with Firefox, had no problem with Chrome.

* Linux 64 users please note, at the moment 23-Jn-2014 the 64 bit Linux version of the Patch Set is unavailable. If you downloaded it while it was available, don't install it (as explained here).
29-Jan-2014 update: The Linux-64 patch is back (as described here).

The Patch is platform specific and is available for:
  • HP-UX Itanium
  • IBM AIX on POWER Systems (64-bit)
  • Linux x86
  • Linux x86-64
  • MS Windows (32-bit)
  • MS Windows (64-bit)
  • Oracle Solaris on SPARC (64-bit)
  • Oracle Solaris on x86-64 (64-bit)
You can read the readme file here.

Unlike 11.1.1.6 patches, this patchset is downloaded in a single big file+one bonus patch. So just for the record (since you don't need to download them separately):
Patch Abstract
16913445 Oracle Business Intelligence Installer (BIINST)
17922352 Oracle Business Intelligence Publisher (BIP)
17300417 Enterprise Performance Management Components Installed from BI Installer 11.1.1.7.0 (BIFNDNEPM)
17922552 Oracle Business Intelligence Server (BISERVER)
17922596 Oracle Business Intelligence Presentation Services (BIPS)
17300045 Oracle Real-Time Decisions (RTD)
16997936 Oracle Business Intelligence ADF Components (BIADFCOMPS)
17922577 Oracle Business Intelligence Platform Client Installers and MapViewer

As usual there is a bonus patch: Patch 16569379  (1111770)- Dynamic Monitoring Service patch. It is platform dependent. If you installed it with 11.1.1.7.1 or 11.1.1.7.131017, that's enough. It's the same.

Oracle BI EE Suite Bundle Patch 11.1.1.7.140114 contains no new features.
In the ReadMe here there are special instructions for upgrading from 11.1.1.6.X to 11.1.1.7.140114 at  "Section 3.1: For Customers Moving From 11.1.1.6.x to 11.1.1.7.140114". DON'T upgrade before you read and understand it.
The main point there: f you are upgrading from Oracle BI EE Bundle Patch 11.1.1.6.12, apply the patch for bug 16989567 after installing 11.1.1.7.140114. This bug fix was included in 11.1.1.6.12, but is not in 11.1.1.7.140114. It will be included in 11.1.1.7.140225.

Please read Section 4: Installation Instructions, before any patch installation.



Bugs fixes 

BI Publisher
 
Bugs fixed in this patch:

14808620: ONLY THE FIRST PRESENTATION VARIABLE IS PASSED TO THE DATA MODEL ENGINE

16281542: ONLY FIRST REPORT'S TEMPLATE USED FOR ALL REPORTS WHILE PREVIEWING THEM

16297877: APP-FND-02938 MULTI-ORGANIZATION ROUTINE FAILED WHEN SELECT A RESP IN MYACCOUNT

16310357: BI PUBLISHER: REPORTS ARE SCHEDULED TO RUN EVERY 2 WEEKS BUT RUN EVERY WEEK.

16410081: REPORT JOB HISTORY 50+ OUTPUTS SHOW DISABLED XML DATA FOR ALL RECORDS AFTER PREV

16432999: XLIFFUTILITY NOT FINDING THE CORRECT STRING IN A SERIES OF FO:INLINE ELEMENTS

16456421: MEMORY PROBLEMS IN FOPROCESSOR WHILE HANDLING LARGE NESTED TABLE

16596837: BIP DATA MODEL FAILS TO LOAD DATA FOR A DATA SET BASED ON XML WITH UTF-8 CHARSET

16703527: ANCHOR TWO PIVOT TABLES SO THEY APPPEAR SIDE BY SIDE IN RTF TEMPLATE IS FAILING

16703847: ACC:IE8 ENTER DOES NOT SELECT FLOATMENU HIGHLIGHTED ENTRY

16738602: PERMISSION SETTING NOT DISPLAYED PROPERLY IF MOR THAN 31 ROLES

16799504: SENDING LARGE FILES TO ORACLE CLOUD SERVER REMOVES .PART EXTENSION

16883295: BI PUBLISHER PARAMETER NAMES TRANSLATION NOT RETAINED ON REPORT REFRESH

16927933: OPENING REPORT JOBS PAGE RESULTS IN "ERROR GETTING HISTORY DATA

16941726: RESENDING A REPORT AS FTP FROM THE JOB HISTORY PAGE FAILS

17012912: AFTER APPLYING OBIEE BP1 PATCH, BI PUBLISHER STOPS WORKING

17044556: APPS - UPLOADING DATA MODEL THROWS ERROR BUT UPLOADS ANYWAY WITH INVALID DATA

17170265: UNDEFINED DISPLAYED AFTER SELECTING DATA/TIME IN SCHEDULE PAGE

17188515: BI: URLXMLPSERVER->ADMINISTRATION->SERVERCONFIGURATION->APPLY THROWS ERROR 500

17205272: 348 DIFFS IN LATEST BIPUBLISHER MAIN LABEL (130721.0533)

17209639: PREFERENCES SET FROM ANALYTICS NOT TAKING EFFECT FOR BIP

17216456: JAVA.LANG.ARRAYINDEXOUTOFBOUNDSEXCEPTION WHEN SWITCHING TEMPLATES

17251779: PARAMETER SEARCH DOESN'T WORK CORRECTLY

17291016: PROBLEMS WITH USING ORACLE BIEE DATASOUCE IN BIP DATA MODEL

17395283: BIP REPORT JOB DOES NOT SHOW CORRECT STATUS

17467379: SCHEDULED BIP REPORTS STUCK IN RUNNING STATUS, CALLBACK FAILURE TO ESS

17510819: FO FILE WITH 2 LARGE NESTED TABLES CAUSES EXTRA SHEET FOR XLSX

17566480: BIP FA - SFTP DELIVERY FAILS DUE TO JAVA.LANG.NULLPOINTEREXCEPTION

17608990: ESS MANAGE JOBS SCHEDULE FREQUENCY SHOWS ERROR FOR EVERY REPORT SCHEDULE

17696750: SPINNING IN QUERY BUILDER FOR PARSING COMMA POSITIONS


 BISERVER

Bugs fixed in this patch: 

 
11884377: E_ADFGATEWAY_UIHINTSQUERYERROR MUST NOT BE A FATAL ERROR

14711397: NEED UTILITY TO UPGRADE PREVIOUSLY INSTALLED DATA DIRECT DRIVERS

16230685: SLEAF ON ESSBASE GIVES ERROR- TARGET DATASOURE DOES NOT SUPPORT THE FUNCTION

16291580: RSUM FUNCTION GIVING THE WRONG VALUE

16384360: CREATING ESSBASE REPORT RESULTS IN ODBC ERROR

16404175: ADMINTOOL VIEWMEMBER/UPDATEMEMERCOUNT FAILS ON LEVELS FROM MULTI-HIERARCHY DIM

16612385: INCORRECT DATA IS OUTPUT WHEN USING SJIS ORACLEDB DATA SOURCE ON HP-UX

16674418: PROBLEM TURNING OFF SUBQUERY FILTERS DISABLE_SUBQUERY_CACHE_SEED=1, DISABLE_SUB

16740955: GRAND TOTALS ARE INCORRECT WHEN FILTERS APPLIED ON PIVOT TABLE

16977559: INTERNAL ERROR QUERYING MULTIPLE DIMENSION SOCPE ALIASES ONLY ON THE SAME DIM

16997189: PHYSICAL QUERIES GENERATED BY BI SERVER HAVE A SYNTAX ERROR

17155043: RANK() FUNCTION FOR NULL VALUES BEHAVING DIFFERENTLY BETWEEN 10G AND 11G

17185641: ONLINE CHECKIN LOCK ISSUE: SUVERIFY(COLOCK_ISSET(VALUE)) FAILURE

17314851: FIX FOR BUG 17314851

17384730: ADD HOSTNAME TO NODE_ID COLUMN OF USAGE TRACKING TABLES OF OBIEE

17437777: ADF_BUNDLE VARIABLE IS NOT RESOLVED WHILE RUNNING QUERY FROM ISSUESQL URL

17456520: CRASH IN NQSSERVER (SEGMENTATION FAULT)

17550496: XSD FILE IN 11.1.1.7.3 IS OUT OF DATE

17537464: PREFLIGHT:REL8:SALESCOMP BI DASHBOARDS ARE NOT SHOWING UP DUE TO INCORRECT PARTY

17579731: OTBI:REL7UPG: CUSTOM GOALS CREATED/NOT CREATED REPORT ERROR

Presentation Services
Bugs Fixed By This Patch
14110065: PERCENTAGE VALUES EXPORTED TO EXCEL AS CUSTOM DATA TYPE

14115628: TABLE VIEWS ARE STRETCHED WHEN USING PRINTABLE PDF OPTION

14126454: SOME CELLS GOT MERGED AFTER EXPORTING REPORT FROM 11G TO EXCEL, 10G IS FINE.

14226889: REMOVE GDVARIANT FROM DL API AND USE NATIVE DATA TYPES

14278050: UNABLE TO APPLY CONDITIONAL FORMAT FOR COLUMN HAVING CASE STMT IN GRAPH PIVOTED

14478665: UNABLE TO EDIT ANALYSIS WITH SELECTION STEPS WHEN SELECTED VALUES ARE RELOADED

14527683: BUBBLE CHART WITH CONDITIONAL FORMATTING ON CASE STATEMENTS SHOWS ONLY ONE COLOR

14646338: WHILE EXPORTING TO EXCEL SCALE NUMBERS ON THE HORIZONTAL AXIS OVERLAP

14768894: AXIS TICKS AND INTERVALS NOT SHOWING ROUNDED DOLLAR AMOUNTS

14781615: UNION SORT IS NOT WORKING ON TABLE VIEW

14794470: ALIGNMENT ISSUE ON EXPORT DASHBOARD WITH CELLS HAVE BOTH IMAGE&TEXT TO EXCEL

15976799: ASSERTION FAILURE ERROR WHEN HAVING GROUP BY SET IN ADVANCED TAB

16025137: ODBC ERROR AFTER SETTING A DESCRIPTOR ID COLUMN

16031545: DISPLAY COLUMNS SHOULD BE AUTO FILLED WHEN EDITING PRESENTATION LEVEL

16064049: CHROME/SAFARI: NOT ABLE TO DND COLUMN IN PIVOT

16103936: GRAND TOTAL NOT DISPLAYED WHEN MULTIPLE GROUPS ARE USED IN ANALYSIS

16368595: CHARTS SOMETIMES DISAPPEAR WHEN UNDO DRILLS ARE CLICKED

16446150: CRASH IN PDF PRINT

16490855: HIGH RESPONSETIME IN SAWSERVER FOR 28K ROW/69COL EXCEL DOWNLOAD TEST

16545327: ERROR MESSAGE NOT SHOWING WHILE UPDATING COUNTS FOR SEGMENT IN OBIEE 11.1.1.6.7

16576787: EXCEL EXPORT: CELLS SHIFTING IF THE DIMENSION/S ARE USED IN PIVOT SECTIONS.

16613671: PRIVILEGES IN WEB CATALOG FOR USER POPULATION - CAN LIST USERS REAPPEARING

16656067: GRAPH NOT RENDERED CORRECTLY WHEN USING A CUSTOM LOCALE

16725115: EXCEL: TURN OFF THE WRAP TEXT FOR COLUMN NAME FOR A PIVOT TABLE HAVING IMAGE

16757820: EXCEL 2007: PLEASE ADD A LINE SPACE IF A EXCEL CONTAINS MULTIPLE VIEWS

16758207: ACCESS DENIED IN DASHBOARD EDITOR AFTER COPYING WEBCAT FOLDERS FROM DEV TO SIT

16769606: WRITEBACK FOR DATE/TIME FIELD FAILS: JAVASCRIPT ERROR 'DATETIMEPARSER' UNDEFINED

16775374: EXPORT TO EXCEL 2K7: REDUCE THE SAW TEMP FILE SIZE

16820210: INVALID ALIAS FORMAT ERROR TABLE_NAME.COLUMN_NAME REQUIRED CASE STATEMENT SPLIT

16848479: SELECTION STEP "OVERRIDE WITH PROMPT" OPTION NOT WORKING ON DASHBOARD LOAD

16855300: USER FOLDERS GETTING DELETED DURING CATALOG VALIDATION USING REPORT OPTION

16908177: RACE CONDITION IN VIEWSTATEMANAGER GETCURRENTSTATEPATH

16919851: TABLE VIEW WITH OTHER VIEW MERGES EXCEL COLUMNS

16921100: BI EXTENDER DOES NOT DELETE FOLDER FOR BI DISABLED SEGMENT

16932974: PROPERTIES OF A THE CUBE TABLE "ALIAS" IS GRAYED OUT IN 11.1.1.7

16936249: EQUALIZERPDS/ADMINTOOL DOES NOT UNEQUALIZE ALL ALIAS COLUMNS IN CERTAIN CASES

17025157: BIP REPORT PARAMETERS MISSING IN DASHBOARD WHEN IT IS EMBEDDED AS LINK

17044720: ONLINE ADMIN CONSISTENCY CHECK DOES NOT FIX HIDDEN ERRORS

17046235: DECISION FILE PRODUCED BY PATCHRPD AND ADMINTOOL ARE NOT THE SAME

17199003: SORT AND SHOW ALL ROWS HAS CHANGED BEHAVIOUR BETWEEN 10G AND 11G

17241840: NULL VALUES REPLACED WITH 0 THROUGH CONDITIONAL FORMATTING

17273335: HIERARCHY PROMPT DEFAULTS TO CATALOG VIEW IF SPECIFIC ITEMS ARE SELECTED.

17272558: 44% TIME IN FORMATENGINE::EVAL/REPORTFORMATTINGRULE::CHECKRULE()

17272572: TOO MANY CALLS TO GETDATAMETADATA() FOR OBIPS EXPORT

17284134: NEED TO OPTIMIZE REMAINING GETDATAMETADATA CALLS FOR EXCEL EXPORT

17291877: MODIFY THE POLLING CODE IN ORDER TO BYPASS APACHE CACHE

17291926: REMOVING SAXPOSTPROCESSOR FOR EXCEL EXPORT

17320304: REL8 WEBCAT UPGRADE FAILS WITH ANALYTICS DATA LOAD LEADS EXAMPLE SAX PARSER EXC

17336119: RUNNING NQSQUERYMETADATAOBJECTS TRUNCATING CONTENT IN OUTPUT

17346561: CREATE PATCH IS THROWING NUMBERFORMATEXCEPTION

17352466: ACTION LINKS ON KPI WATCHLISTS DO NOT SHOW AS UNDERLINED

17377225: NEED TO OPTIMIZE CONDITIONAL FORMATTING FOR EXCEL EXPORTS

17405023: 17% OF CPU WAS SPENT ON STRING:: EQUAL()

17419116: FOLDER CAPTION EXTRACT DOES NOT SKIP THE FOLDERS AS EXPECTED

17425640: USING OLD C CASTING STYLE CAUSES ISSUES IN QDRXML::LOADMEMBERS()

17433563: LOGICAL SQL ERROR FOR DESCRIPTOR ID COLUMN IN SEGMENTATION

17438493: PRESENTATION VARIABLES NOT USED IN SAVED FILTER AFTER DOING "INCLUDE COLUMN

17457243: TALEO:CREATING A DASHBOARD IN A FOLDER UNDER SHARED FOLDER OF CATALOG WARNS DISP

17462992: NUMBER IS SHOWING WITH DECIMALS IN THE EXCEL

17476445: LIMIT BY ALL PROMPTS NOT WORKING IF PREVIOUS ONE IS A PRESENTATION VARIABLE

17485342: BI SERVER FAILURE DUE TO CHANGE OF LEVEL IN PARTY ID COLUMN AFTER MERGE

17485955: TALEO : APP ROLE DENIED USER POPULATION IS THROWING ERROR ON AGENT PAGE

17491720: BI SERVER CRASH ON RUNNING BIAPPS TM QUERIES

17496492: CONSISTENCY CHECK DOES NOT FIX CORRUPT REPOSITORY AND ADMINTOOL CRASHES

17505778: SHARED FOLDER IN BI CATALOG IS EMPTY AFTER PATCHING

17538876: GO-URL ISSUE

17600644: OBIEE 7.1: GRAPH PIVOTED RESULT DISPLAYS DUPLICATE NAME FOR PIE CHART TITLE.

17622366: FILTER IS NOT BEING SET AFTER SORTING THE COLUMN

17601422: TOTAL BUTTON DISAPPEAR WHEN COLUMN SELECTOR IS USED.

17636632: OPEN DOES NOT SHOW JAVASCRIPT VIEW

17656090: CONDITION REQUESTS USE EXCESSIVE DIRECTORY I/O

17753959: SHOW DATA AS - GRAND TOTAL INCORRECT

17833915: PIVOT COLUMN WITH 'SHOW DATA AS OF ROW' SHOWS WRONG VALUES IN EXCEL 2007

Ignore the readme.txt files in the Oracle BI EE Suite Bundle Patch component patches. The readme.html file in patch  17886497 contains all the installation instructions and list of bugs fixed.


Remember to upgrade the BI Administration Clients with the 17922577 patch content that comes in the bundle patch (not relevant for Windows servers).
  

No comments:

Post a Comment