OBIEE 11.1.1.6.8 Patch set available

Patch 11.1.1.6.8, the next patch set for OBIEE 11g, is now available from support.oracle.com.   As with all recent patches for OBIEE 11g, it comprises of seven patch zip files. It is a cumulative update for 11.1.1.6.0 and can be applied on top of any of the existing patches for 11.1.1.6.0 up to 11.1.1.6.7.

It is available for Windows, Linux and all the usual flavours of Unix.

The seven files comprising the patch are as follows. The instructions for installing them using opatch are detailed in the readme file in the first patch zip file.

This patch set fixes a large number of bugs, each of which are detailed in the readme’s for each patch file. Note if you wish to patch a version of 11.1.1.6 prior to 11.1.1.6.2BP1 and you use BI Mobile you will need to download the new BI Mobile App for your ipad.

Patch No.	Name	Approx Size
16094198	Patch 11.1.1.6.8 (1 of 7) Oracle Business Intelligence Installer (Patch)	1.4MB
16094192	Patch 11.1.1.6.8 (2 of 7) Oracle Real Time Decisions (Patch)	260MB
16080520	Patch 11.1.1.6.8 (3 of 7) Oracle Business Intelligence Publisher (Patch)	1.6GB
16094205	Patch 11.1.1.6.8 (4 of 7) Oracle Business Intelligence ADF Components (Patch)	51MB
16094211	Patch 11.1.1.6.8 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x (Patch)	1GB
16067995	Patch 11.1.1.6.8 (6 of 7) Oracle Business Intelligence (Patch)	262MB
16097082	Patch 11.1.1.6.8 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer (Patch)	380MB

Note that patches 16094211 and 16067995 are specific to each platform (there are different file for different operating systems) whereas the rest are generic - the same file applies to all operating systems.

The link to Oracle’s OBIEE 11g: Required and Recommended Patches and Patch Sets document is:

https://support.oracle.com/epmos/faces/ui/km/DocumentDisplay.jspx?_afrLoop=1167289098134514&id=1488475.1&_afrWindowMode=0&_adf.ctrl-state=xfsoozokf_294

The link to Oracle’s OBIEE 11g 11.1.1.6.8 is Available For BI Enterprise and Exalytics notification is:

https://support.oracle.com/epmos/faces/SearchDocDisplay?_afrLoop=1201924796998333&_afrWindowMode=0&_adf.ctrl-state=1127q186hi_133

The full list of bugs fixed by this release is:

11824623: NLS:FR:DOUBLE PERCENT SIGN AND WRONG DATA IN PIVOT TABLE ON FRENCH LOCALE

13065019: USAGE TRACKING ISSUE AFTER APPLYING PATCH 12925206- QUERY NOT INSERTED IN LOG

13802667: COMMA DELIMITED CSV FORMAT FOR AGENTS/IBOTS

13949566: MASTER DETAIL VIEW INTERACTION CONTEXT IS LOST

14262536: OBIEE SSL DOES NOT WORK FOR ACTIONABLE INTELLIGENCE/ACTION LINK

14496280: OBIEE 11.1.1.5.0 CREATING HUGE CORE DUMP FILES

14509257: UNWANTED EXPANDATION OF BACKGROUND OF GAUGE CHART/BULB

14532515: SINGLE ACTION LINK POPUP ISSUE

14597361: OBIEE 11.1.1.6.2: UNABLE TO DELETE HEADER FROM NEWLY ADDED COMPOUND LAYOUT

14781767: QA: PROMPTS: RUNTIME PROMPTS IS NOT WORKING IN FIREFOX 16

14832439: BLOCKING ANALYSES BASED ON CRITERIA NOT WORKING ON RESULTS TAB

14832723: BLOCKING ANALYSES IS BROKEN AFTER SAVNG AND REOPENING THE ANALYSIS

15856175: NO METADATA AUTOSAVE IN NQSMODIFYMETADATA AND NQSIMPORTMETADATA PROCEDURES

15879674: WHEN A VALUE WITH THE '&' SIGN IS CHOSEN, SCORECARD WATCHLIST RESULTS ARE NOT BE

15886643: QA: CALC ITEM DISPLAY 0 OR NAN IN TABLE IF EDIT MEASURE FORMULA, EXCLUDED COL,

15891959: PRESENTATION SERVER CRASH

15899791: DRILLDOWN ADDS FILTER FOR THE EMPTY STRING ALTHOUGH THE VALUE IS NULL OR SPACES

15905237: CUSTOM COLUMN HEADING DOES NOT REFLECT IN THE FILTERS VIEW

15908937: OBIEE AUTHENTICATION PROCESS CHANGED AFTER UPGRADE FROM 11.1.1.6.0 TO 11.1.1.6.4

15917103: DISABLED LTS DURING AFTER UPGRADE FROM OBIEE 10 TO OBIEE 11 CANNOT BE ENABLED

15934601: NQSERROR22032 WHEN SORT ON COMBINED RESULTS BASED ON UNIONS,INTERSECT,MINUS

15934766: BIPS FAILS TO START WITH DNSUTILS::DNSNAMELOOKUPFAILED

15954886: GCMAP/GCWAP: ERROR IN CAMPAIGN LOADS AND LAUNCHES

15958318: 11.1.1.6.5 -EXPORT TO EXCEL/PDF DISPLAYING VIEW DISPLAY ERROR-LENGTH URL EXCEEDS

15961449: REQUEST VAR DEFAULT VALUE SET BY REPOSITORY VARIABLE DOES NOT WORK CORRECTLY

15963008: DIFFERENT RESULTS ARE SHOWN WHEN ACTION LINKS ARE USED WITH CONDITION

15966182: CSV FORMAT OF REPORT AND AGENT DELIVERED REPORT ARE NOT THE SAME OUTPUT

15998971: QA:PINNED KPI KEEPS SPINNING WHEN OPENING A KPI WATCHLIST

16059256: SAWSERVER MAY ALLOCATE VERY LARGE ALLOCATION WITH ODBC ERROR

16169478: ADMIN TOOL AND JOB MANAGER VERSION NOT UPDATED AFTER APPLYING 11.1.1.6.8 PATCHES

16219059: JOB MANAGER GETTING [NQSERROR: 86015] [NQSERROR: 77027] A FATAL ERROR OCCURRED

13553123: CREATE USER THROUGH SOAP FAILS WITH JAVAX.XML.WS.SOAP.SOAPFAULTEXCEPTION

13720037: BISERVER QUERY FAILS IF AMPERSAND IS USED IN COLUMN NAME

13921691: QUERY BUILDER UNABLE TO PARSE CERTAIN QUERIES, DISALLOWING EDIT OF SUCH QUERIES

14359228: AFTER UPGRADE TO 11.1.1.6.2BP1, BI PUBLISHER LOGIN PAGE SHOWS UP IN ENGLISH ONLY

14478219: AIX WITH IBM JVM: USERS SEE JAVA.LANG.NULLPOINTEREXCEPTION UNDER HIGH LOAD

14605689: IN AIX USING DATA SET OF REMOTE WEB SERVICE RETURNS NULL DATA

14680717: BI PUBLISHER 11.1.1.6:TIMES NEW ROMAN FONT DISPLAYS WRONG FONT IN RTF OUTPUT

15869175: QUERY BUILDER TRUNCATES THE SECOND RANGE OF BETWEEN CLAUSE IN WHERE CONDITION

There are a number of know issues 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

15854192: ERROR MESSAGE RETRIEVED WHEN TRYING TO CREATE AGENT WITH EMAILS AS RECIPIENTS

15854218: ODBC ERROR WHILE CREATING AN AGENT

15983904: 11.1.1.6.7 ADMIN TOOL CLIENT SHOWS INCORRECT VRSN IN THE CLIENT INSTALLER WINDOW

13873434 QA: IE:UNABLE TO RENAME COMPOUND LAYOUT

14158156: MEMORY SPIKE DURING THE COMPILATION PHASE FOR QUERIES WITH LARGE EXPRESSIONS

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

13974353: CONNECTION STRING USED TO ACCESS LEASING TABLE IS INCORRECT