OBIEE 11.1.1.6.10 is available (and bug fixed)

Please note, since OBIEE 11.1.6.11 is available (see here) you should consider it instead of 11.1.1.6.10.



The patch 11.1.1.6.10 is available from Oracle support site (support.oracle.com). The first part of the patch is Patch 16504136. 

It's the most updated / latest version (actually patch bundle) of OBIEE, installed on top of the basic 11.1.1.6.0 version.

It can be installed on OBIEE 11.1.1.6.0, 11.1.1.6.1, 11.1.1.6.2, 11.1.1.6.2 BP1, 11.1.1.6.4,11.1.1.6.5, 11.1.1.6.6, 11.1.1.6.7, 11.1.1.6.8 and  11.1.1.6.9 .

As usual, the real patch has 7+1 parts. The installation steps for the first 7 are similar. I recommend reading the first readme – patch 16504136 readme file. 

Since 11.1.1.7 is available, I suspect we will not see many more 11.1.1.6.X patches.

The Oracle Business Intelligence 11.1.1.6.10 patchset comprises a number of patches:

Patch	Abstract
16504136	Patch 11.1.1.6.10 (1 of 7) Oracle Business Intelligence Installer
16504143	Patch 11.1.1.6.10 (2 of 7) Oracle Real Time Decisions
16504148	Patch 11.1.1.6.10 (3 of 7) Oracle Business Intelligence Publisher
16504154	Patch 11.1.1.6.10 (4 of 7) Oracle Business Intelligence ADF Components
16504156	Patch 11.1.1.6.10 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x PLEASE note, this is platform specific patch (Windows 32, 64, Linux X86, X86-64, IBM AIX Power 64, Solaris SPARC 64, Solaris X86-64, HP-UX Itanium)
16427939	Patch 11.1.1.6.10 (6 of 7) Oracle Business Intelligence PLEASE note, this is platform specific patch (Windows32,  64, Linux X86-64, IBM AIX Power 64, Solaris SPARC 64, Solaris X86-64, HP-UX Itanium)
16287884	Patch 11.1.1.6.10 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer

Additionally there is the patch number 8, it is named JDeveloper Patch, but it is for OBIEE as well. It's the same patch you used if you installed 11.1.1.6.2 BP1 or later. So if you already installed it, I see no reason to do it again.

Patch 13952743 - JDeveloper patch -   - RUP3 MLR4.3  CUMULATIVE: BASED ON JDEVADF_11.1.1.6.2_GENERIC_120329.1447.6268.1 (last release 11.1.1.6.2)

The installation steps are same as 11.1.1.6.2 BP1 as we described here.

Please note, that readme tell you to do the following backups:

• The ORACLE_HOME\bifoundation\server directory
  
• The ORACLE_INSTANCE\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository
  
• The ORACLE_BI_HOME\bifoundation\jee\mapviewer.ear\web.war\WEB_INF\conf\mapViewerConfig.xml, if you have modified it. This last bullet is relevant to those who configured the OBIEE Maps (described, in Hebrew here).

HP Itanium users, please note: HP Itanium platform must first download and apply patch 14016752 from My Oracle Support.

 I'm not aware of any new features in 11.1.1.6.10.

Bugs Fixed By This Patch

Publisher:

13825454: ORACLE DB SECURITY DONOT HANDLE USR ACCT STATUS EXPIRED(GRACE) FOR AUTHORIZATION
15886696: PARAMETERS WITHOUT DEFAULT VALUES ALLOW MANUAL ENTRY OF DATA USING IE7
16036921: MDX QUERIES FAIL TO LOAD WHEN SAVING, OR IF SAVED, GENERATE NO DATA
16183449: TRIGGER DOES NOT ACCEPT VARIABLE PARAMETER {$SYSDATE()-7$}
16191483: UNABLE TO SEE REPORTS AFTER UPLOAD ON ONE OF TWO NODES
16303357: 10G RTF TEMPLATE FAILS IN 11G WITH XPATH ERROR DUE TO INVALID DATA TYPE CASTING

OBIEE:

8198137: GENERATE METADATA DICTIONARY FAILS A COMPLETE EXPORT ON BIG RPD (OUT OF MEMORY)
12320264: MULISELECT PROMPT AND CLIENTSESSIONEXPIRYMINUTES SETTINGS THROW ERROR
13531449: COMMON HEADER SHOWS UP WHEN CLICKING ON DASHBOARD PAGE TAB IN PORTAL PAGES
13533513: OBIEE GRAPH LEGEND LABEL CONCATENATION ISSUE
13950601: QA: RC2: CONDITIONS LIST OF VALUES DO NOT WORK, NOTHING GETS RETURNED
14136472: JAVASCRIPT IN TEXT DASHBOARD OBJECT WORKS IN 11.1.1.5.0 DOES NOT WORK 11.1.1.6.0
14278050: UNABLE TO APPLY CONDITIONAL FORMAT FOR COLUMN HAVING CASE STMT IN GRAPH PIVOTED
14372406: DELETE AGGREGATES RESULTS IN A CHECKIN FAILURE
14521397: DURING CONSISTENCY CHECK ERROR IN SACLIENTRP.H OR SOSECURERPGATEWAY.CPP
14697631: PERFORMANCE ISSUE ON QUERY TO MICROSOFT SSAS
14759014: ERROR WHILE RUNNING REPORT WITH 6 UNION QUERIES
14834396: OPENING THE ADMINISTRATION > MANAGE PRIVILEGE VIEW IS SLOW
14848445: ENCOUNTERING "[NQSERROR: 37005] TRANSACTIONAL UPDATE FAILED." IN ONLINE MODE.
15911357: DISPLAY AS RUNNING SUM NOT SHOWING ZERO WHEN IT IS A NULL VALUE
15916915: CRASH IN DASHBOARDVIEWSUBMITCONDITIONFUNCTOR::GETCONDITIONCURSOR
15989894: OBIEE 11G: UNABLE TO ADD BIN IN COMBINED REQUESTS.
16021684: NO RESULTS DISPLAYED IN A MDX QUERY AGAINST ESSBASE WITH A FILTER
16068402: GRAPHS NOT SHOWN ON IE WHEN OBIEE IS BEHIND A REVERSE PROXY
16098352: MARKETING SEGMENTATION GENERATE PREVIEW THROWS NQSERROR 14065 ILLEGAL CROSS JOIN
16179354: ESSBASE REPORTS RETURN NO RESULTS- WORKED IN 11.1.1.6.4
16195852: OBIEE11GBI SERVER NOT STARTING AFTER SETTING OBIEE_IMPLICIT_CONVERT_TIMESTAMPADD
16227537: MDX GENERATED AGAINST SSAS CUBE WILL FORCE SSAS TO BECOME UNRESPONSIVE
16232096: AGGREGATES CREATION IGNORED AT LEVELS DEFINED ACROSS MULTIPLE HIERARCHIES
16250380: ADMIN TOOL CRASH WHEN WE TRY TO MERGE 2 REPOSITORIES
16309432: SOAP HTMLVIEWSERVICE FILTEREXPRESSIONS IS BROKEN
16387359: PRESENTATION SERVICES CRASHES WHILE NAVIGATING VIA ACTION LINKS
16401538: 10G->11.1.1.6.7 UPGRADE RPT CRASH SAWSERVER WHEN NO COLS IN COL/MEASURE SECTION
16432997: PROMPT DEFAULT TO SESSION VARIABLE NOT SETTING PRESENTATION VARIABLES INITIALLY

Known Bugs With This Patch

14228519: ADMINTOOL CLIENT MISSING ALL FILES UNDER EXTENDER DIRECTORY IN CLIENT INSTALLER
14244844: NAVIGATE TO URL ACTIONS BASED ON ENCODED URLS MAY RESULT IN DOUBLE ENCODING
14743304: FIX FOR BUG 14170374 REQUIRES ADDITIONAL CHANGE TO OPMN.XML
14771782: FIX FOR BUG 14070348 DOES NOT WORK IN CLUSTERED ENVIRONMENT
14772000: UNABLE TO SCROLL AS IE 8.0 PERFORMANCE POOR FOR MAX ROWS IN DASHBOARD
15854192: ERROR MESSAGE RETRIEVED WHEN TRYING TO CREATE AGENT WITH EMAILS AS RECIPIENTS
16531368: DOCUMENT THE ROW SPANNING ISSUE IN RELEASE 11.1.1.6.10
16687063: FIX FOR BUG 15911537 REQUIRES ADDITIONAL SETTING TO THE INSTANCECONFIG.XML FILE