OBIEE 11.1.1.6.9 available

OBIEE 11.1.1.6.9 Bundle Patch was released on March 8th 2013. This patchset is available for all customers who are using Oracle Business Intelligence Enterprise Edition 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, and 11.1.1.6.8

There are no new features in this patchset, only bug fixes. Bundled Patch Details are as below:

(1 of 7) Oracle Business Intelligence Installer.  16287811

(2 of 7) Oracle Real Time Decisions.   16287778

(3 of 7) Oracle Business Intelligence Publisher.   16237960

(4 of 7) Oracle Business Intelligence ADF Components.   16287840

(5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x.   16287854

(6 of 7) Oracle Business Intelligence.   16227549

(7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer   16287884

Follow the link below to download:
https://blogs.oracle.com/proactivesupportEPM/entry/obiee_11_1_1_65


Bugs fixed by patches:
1. 16287811(BI Installer)-->

• 13404296 BI PROVISIONING FACADE MUST TRIM RPD IN INSTANCE FOR SELECTED FA OFFERINGS
• 13485655 T2P: ERROR MSG EXECUTING WLST SCRIPT APPEARS DURING BIINSTANCE PASTECONFIG
• 13504454 BLK: BIINSTANCE COPYCONFIG FAILURE: ESSBASE MAXL LOGIN IS FAILING 
• 13510938 NEED OFFICIAL WAY TO INVOKE _CONFIGURERPD
• 13560245 BIDOMAIN/CONFIG/JDBC NOT FOUND
• 13565722 BLK: BI T2P PASTECONFIG ERRORED OUT WITH UNABLE TO PARSE JMS_WEBLOGIC_JNDI_URL
• 13589944 BI T2P: PASTECONFIG INSTANCE IS FAILING WITH JAVA.LANG.UNSATISFIEDLINKERROR
• 13619973 INCLUDE ESSSERVER HOST NAME IN THE MOVEPLAN
• 13628293 EMPTY PROCUREMENT DASHBOARD IN RC4
• 13683204 STRESS:FA:CRM ERROR RESPONSE[NQSERROR: 43082] ILLEGAL OPERATION ATTEMPTED CLOSED

2. 16287778 (RTD)

• 13240778 QA: ACCESS: ERE: RGRN: ERROR ACCESSING LOV VIA KEY; CAN'T SELECT VIA KEY
• 13347251 QA: UNABLE TO SEE ERE IN "DYNAMIC" PAGE IN SAFARI, CHROME
• 13360752 UNABLE TO LOAD ALL EXTENSION COLUMNS FOR CUSTOMER IN RTD STUDIO
• 13408870 QA: SDCONFIG 3X VALUES COPIED TO 11G, BUT NOT USED THERE
• 13409526 QA: UPDATE DOC, COPYRTDDATA_README.TXT FOR STOP/START 11G
• 13472560 QA:ACCESS:HIGH CONTRAST SETTING APPEARS CLUTTERED, SOME ITEMS NOT VISIBLE
• 13506987 COPYRIGHT INFORMATION NEEDS TO BE EXTENDED TO 2012
• 13537093 BACKPORT BUG 13537093 TO 11.1.1.6.2
• 13539353 BACKPORT BUG 13539353 TO 11.1.1.6.2
• 13567294 REMOVED 1ST VALUE IN RULE BECOMES NAN

3. 16237960 (BIP)

• 10022187 ACC: SELECTED ITEM IN FOLDERS PANE GETS LOST AFTER USING UP/DOWN ARROW TOO MUCH
• 10046249 ACC: SCHEDULE PAGES HAVE "GRIDTABLE" TABLES THAT CAN'T BE NAVIGATED
• 11678983 QA:LDAP CONFIG ASSUME ADMIN IS DEFINED UNDER DISTINGUISHED NAME FOR USERS
• 11906714 QA: TIMEZONE NOT IN SYNC IN JOB MANAGER - JOB HIISTORY
• 12312461 NLS:MB DATA GARBLED IN JOB HISTORY USING SQL SERVER
• 12542914 ACC: REPORT VIEWER STRUCTURE HAS ERRORS - NO IFRAME AND NO LANG ATTRIBUTE
• 12645567 NLS:WRONG WEEK OF YEAR FOR ORACLE DATE FORMAT CONTAINING WW
• 12825409 INTERACTIVE VIEWER CONDITIONAL FORMATTING FAILS FOR NON DISPLAY COLUMN
• 12877824 WEBSERVICE API - GETSCHEDULEDREPORTSTATUS ALWAYS RETURNS JOB STATUS AS SCHEDULED
• 12912473 BI PUBLISHER 11G SHARE REPORT XMODE=3 AND XMODE=4 NOT WORKING FOR PDF OUTPUT

4. 16287840 (ADF components)

• 13365954 ERROR WHILE OVERWRITING AN ANALYSIS VIA BI COMPOSER
• 13520338 STRESS:FA:CRM:SPD HEAVY CONTENTION ON FACTORYMANAGER.CREATEMODELOBJECT
• 13597290 11.1.1.7.0 ESSBASE DATA CONTROL CODE IS PRINTING UNWANTED DEBUG MESSAGES
• 13733098 REPORTS AND ANALYTICS, CANNOT SAVE NEWLY CREATED REPORT
• 13789351 RUP2 ST3 (PS5 RC4) - NPE WHILE TESTING OL FLOW IN KOREAN LANGUAGE
• 13858848 BIADFCOMPS - ANALYSIS CREATED USING COMBINE UNION IS NOT EDITABLE IN BI COMPOSER
• 13958089 BI COMPOSER: CAN NOT SAVE ANALYSIS AFTER FAILOVER WLS MANAGE SERVER
• 13973674 MAIN: NAMECLASHEXCEPTION WHEN MULTIPLE INSTANCES OF ESSBASEDC ARE LOADED
• 14081217 STRESS:FA:CRM:SPD BIADAPTERDCSERVICE HOLDING LARGE IN HEAP CAUSING OOM
• 14183506 ALWAYS SAME NPE AND STACKTRACE NO MATTER THE PROBLEM IS 

5. 16287854  (EPM)

• 10623654 FA: NLS:PS1:DATE AND TIME NOT LOCALIZED IN FR SCHEDULED BATCHES DETAIL INFO.
• 11652873 FA: FR ANNOTATION VIEW PANE HAS PERMISSION ISSUES FOR ANNOTATION ON TEXT OB
• 11735177 REHOSTING TOOL IS NOT TRANSFERRING PROPER USERNAME IN PARTITION DEFINITION
• 11924085 UNABLE TO RUN AN ESSBASE CALC SCRIPT IN WEB ANALYSIS
• 12404364 ESSBASE READ ONLY ACCESS INSUFFICIENT PRIVILEGE WITH PROMPT
• 12530876 PERFORMANCE OF FR REPORT QUERYING ESSBASE W/LARGE NUMBER OF DYNAMIC CALCULATIONS
• 12601370 FUSION B17: SAVED QUERY DOES NOT REFRESH, BUT NEW QUERY WORKS ON THOSE MEMBERS
• 12722750 FA: FF 5.0 GIVES BLANK SCREEN FOR HTML BOOK PREVIEW
• 12723793 NEED DIFFERENT URL FOR SMARTVIEW INSTALLER IN FUSION MODE
• 12765822 DMS LOGS LOTS OF ERRORS WHEN ESSBASESERVER1 IS DOWN

 6. 16227549  (OBI - Main patch for most of us)

• 10137467 ENABLE "ZOOM TO DATA RANGE " IN OBIEE 11G
• 10165057 QA:THE EDGES OF MAP VIEW GOT TRUNCATED AFTER EXPORTED/PRINTED TO PDF/HTML
• 10167311 ADD TEST CASES FOR MDSXUDML GENERATOR AND PARSER
• 10199188 CHARTS X AXIS LABEL IS BLURRED AT 45/60 ANGLE
• 10391144 WEIRD BEHAVIOUR OF FILE OPEN DIALOG ON WINDOWS 7 COMPUTER
• 10409969 BH9:QA: TIMESTEN ODBC ERR INCOMPATIBLE FACT IF CONDITION STEP FEDERATED MEASUR
• 10419667 UT:USAGE TRACKING ERROR TEXT OF FAILED QUERY IS NOT LOGGED
• 10647655 COLUMN DATA FORMAT IS IGNORED ON WRITEBACK
• 11657725 QA:REG:MALFORMED URL ERROR WHEN PRINT KPI WATCHLIST TO PDF ON DASHBOARD PAGE
• 11810127 ADMINTOOL TESTS FAIL: EXTERNALIZATION

7. 16287884 (Client installers and Map viewer)

• 13794002 BISHIPHOME 11.1.1.6.2 CUMULATIVE PATCH 1
• 14054848 RUP4: BISHIPHOME CLIENT INSTALL 11.1.1.6.3 PATCH 1
• 14533251 REL6: BISHIPHOME CLIENT INSTALL 11.1.1.6.31 PATCH 2
• 14646289 REL6: BISHIPHOME CLIENT INSTALL 11.1.1.6.31 PATCH 3
• 14672002 REL6: BISHIPHOME CLIENT INSTALL 11.1.1.6.31 PATCH 4
• 14711062 REL6: BISHIPHOME CLIENT INSTALL 11.1.1.6.31 PATCH 5
• 14712346 11.1.1.6.5 CLIENT INSTALLER AND MAPVIEWER PATCH
• 14740701 REL6: BISHIPHOME CLIENT INSTALL 11.1.1.6.31 PATCH 6
• 15839347 11.1.1.6.6 CLIENT INSTALLER AND MAPVIEWER PATCH
• 15860153 REL6: BISHIPHOME CLIENT INSTALL 11.1.1.6.31 PATCH 7 

  I think Oracle keeping up with its release volume as one patch set per month. So we can expect 11.1.1.7 next month in April 2013, or is it going to be 11.1.1.6.9.1 ?

 

 

PDF dumps for OBIEE 11g Certification exam

I have compiled a list of PDFs that I used for preparing for certification exam. To download the same, follow the steps here:

1. Visit the Oracle documentation page:

http://www.oracle.com/technetwork/middleware/bi-enterprise-edition/documentation/index.html

2. Click view library - This will open up HTML documentation, which is not very convinient to read, especially for offline reading, so we look for pdf documents.

3. Click Installation Guide - Stop - Once you see table of contents, on the top right side, click on 'PDF' and save a copy. Thats it, you got it.

4. Hit back, and repeat above steps for following documents:

Enterprise Deploymentet Guide
UserGuide
RPDGuide
AdminGuide

These are the 5 documents that I feel are most important to prepare for certification. There are no other dump files for certification, good luck.


Revision: For those of you just starting out OBIEE, Oracle has a live demo environment, which could help you look at the tool before you even start. Follow the post below to view more details:

http://kumar-oraclebi.blogspot.com/2014/01/obiee-live-demo-from-oracle.html

Great news!!! I cleared OBIEE 11g certification

This past Friday, I cleared OBIEE 11g certification (scored 86%). I was relieved at last. Well, as expected exam was not straight forward, and requires practical experience and good knowledge base of concepts including data warehousing concepts.

Don't be surprised, as there are non scoring questions in the exam, which Oracle specifies before the exam begins. So you may feel you have answered minimum passing questions correctly, yet, overall score may be less. In terms of time allowed, I felt there was plenty of time to attempt all questions, in fact I was done with the exam in under 75 min (out of 120 mins) which includes reviewing questions I marked for later.

My advise to any applicant would be to study basic concepts thoroughly, and read all 11g documents (installation, configuration, RPD and users guide etc).. pretty much everything, unless of course you are lucky enough to be sponsored by your employer for instructor led training meant for certification.

In the results, Oracle specified topic, where you incorrectly answered, so that we can go and pick up those topics later.

Hope this helps.. Good luck.

Update: For anyone interested in the link to Oracle's certification page or to knowing more about complementary Oracle certifications can look at my following blog post about certification paths:

http://kumar-oraclebi.blogspot.com/2013/05/achieved-obiee-11g-foundation-suite.html



~~Arun