OBIEE Patch 11.1.1.7.140114 - available

Oracle® Business Intelligence Enterprise Edition Release 11.1.1.7.140114

---

Patch Information

Oracle BI EE Suite Bundle Patch 11.1.1.7.140114 includes all the bug fixes released in Oracle BI EE Suite Bundle Patch 11.1.1.7.131017 and new bug fixes.

The Oracle BI EE Suite Bundle Patch 11.1.1.7.140114 under the top-level patch 17886497 consists of the following component patches:

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

 

Bugs Fixed by This Patch

Oracle BI EE Suite Bundle Patch 11.1.1.7.140114 includes all the bug fixes released in Oracle BI EE Suite Bundle Patch 11.1.1.7.131017 and the following new bug fixes:

Oracle Business Intelligence Publisher (BIP)

New bug fixes in this patch are :

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

Oracle Business Intelligence Server (BISERVER)

New bug fixes in this patch are:

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

Oracle Business Intelligence Presentation Services (BIPS)

New bug fixes in this patch are shown in the following list:

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

---