Applying OBIEE 11g Patch 11.1.1.6.5

November 1st, 2012 Jasdeep Singh No comments

Oracle recently released a new patch set for OBIEE 11g – 11.1.1.6.5. The patch set can be downloaded from Oracle Support. This patch set is available for 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 and 11.1.1.6.4. This new patch set comprises of following patches:

  • Patch 14696072 (1 of 7) Oracle Business Intelligence Installer. (generic)
  • Patch 14733356 (2 of 7) Oracle Real Time Decisions. (generic)
  • Patch 14678543 (3 of 7) Oracle Business Intelligence Publisher. (generic)
  • Patch 14733390 (4 of 7) Oracle Business Intelligence ADF Components. (generic)
  • Patch 14733413 (5 of 7) Enterprise Performance Management Components Installed from BI Installer 11.1.1.6.x. (port specific)
  • Patch 14665284 (6 of 7) Oracle Business Intelligence. (port specific)
  • Patch 14733370 (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer (generic)

The instructions to apply the above patches are identical, and are contained in the readme file for patch 14696072.

Here are the steps to apply the patches to a Windows 64 bit install of OBIEE:

Step 1:Back up the OBIEE install and shutdown all OBIEE processes including weblogic.

Step 2: Download the zipped patch files from Oracle Support.

Download patch files

Download patch files

Step 3: Unzip the files and put them in your {OBIEE_HOME}/Oracle_BI1 folder. Example: C:\OBIEE11g\Oracle_BI1

Unzip the files and put them in your {OBIEE_HOME}/Oracle_BI1 folder

Unzip the files and put them in your {OBIEE_HOME}/Oracle_BI1 folder

Step 4: Clear the files that are associated with the Oracle BI EE Catalog Manager binary cache. Go to {ORACLE_HOME}\Oracle_BI1\bifoundation\web\catalogmanager\configuration\ and remove the following files if they exist:

  • org.eclipse.osgi
  • org.eclipse.equinox.app

Step 5: Open a Command window and before applying the patches. Ensure you are in the {ORACLE_HOME}\Oracle_BI1 folder:

Set environment variables

Set environment variables

set ORACLE_HOME=C:\obiee11g\Oracle_BI1
set PATH=%ORACLE_HOME%\bin;%PATH%
set JAVA_HOME=%ORACLE_HOME%\jdk
set PATH=%JAVA_HOME%\bin;%PATH%
set PATH=%ORACLE_HOME%\OPatch;%PATH%

Step 6: Apply the sever patches in the following order:

C:\obiee11g\Oracle_BI1>cd 14696072

C:\obiee11g\Oracle_BI1\14696072>opatch apply
OPatch succeeded.

C:\obiee11g\Oracle_BI1\14696072>cd ../14733356

C:\obiee11g\Oracle_BI1\14733356>opatch apply
OPatch succeeded.

C:\obiee11g\Oracle_BI1\14733356>cd ../14678543

C:\obiee11g\Oracle_BI1\14678543>opatch apply
OPatch succeeded.

C:\obiee11g\Oracle_BI1\14678543>cd ../14733390

C:\obiee11g\Oracle_BI1\14733390>opatch apply
OPatch succeeded.

C:\obiee11g\Oracle_BI1\14733390>cd ../14733413

C:\obiee11g\Oracle_BI1\14733413>opatch apply
OPatch completed with warnings.

C:\obiee11g\Oracle_BI1\14733413>cd ../14665284

C:\obiee11g\Oracle_BI1\14665284>opatch apply
OPatch completed with warnings.

C:\obiee11g\Oracle_BI1\14665284>cd ../14733370

C:\obiee11g\Oracle_BI1\14733370>opatch apply
OPatch succeeded.

Step 7: Check the patches have been applied. Confirm that all the Oracle BI 11.1.1.6.5 patches shown above appear in the list of applied patches (along with any other patches that have previously been applied to the BI System).

C:\obiee11g\Oracle_BI1>opatch lsinventory

Step 8: Copy the BIPublisherDesktop32.exe and BIPublisherDesktop64.exe files from the ORACLE_BI_HOME/clients/bipublisher/repository/Tools directory to the MW_HOME/user_projects/domains/bifoundation_domain/config/bipublisher/repository/Tools directory.

Step 9: Start up OBIEE services and validate the patch has been applied.

Validate the patch has been applied

Validate the patch has been applied

OBIEE 11g 11.1.1.6.2 BP1 – Sample Application VM Image for VirtualBox Released

August 3rd, 2012 Jasdeep Singh Comments off

The latest OBIEE 11g Sample App VM Image for VirtualBox has been released by Oracle.

Download image files from: http://www.oracle.com/technetwork/middleware/bi-foundation/obiee-samples-167534.html

You will also require a zip file manager such as 7zip to extract and merge the zipped image files.

Download all files (including the checksum file) into a single directory.

Download the zipped files from Oracle

Download the zipped files including the Checksums file (no displayed in the image)

Unzip the OVF file using any windows unzip utility. For the image files use a zip file manager such as 7zip to extract and merge files. When all files have been unzipped/merged, you should have the VirturalBox image’s .ovf (key) file with the image disks (*.vmdk) files.

Unzipped and Merged VM Image files

Unzipped and Merged VM Image files

Use VirutalBox Manage “Import” feature to add the Sample Application machine. Start the machine and you should have access to a linux system that hosts the OBIEE application.

OBIEE SampleApp Scripts

OBIEE SampleApp Scripts

Run the start scripts and log into OBIEE.

OBIEE 11.1.1.6.2 Sample App

OBIEE 11.1.1.6.2 Sample App

For more detailed instructions on setup and start up, refer to the VB Image Deployment Guide.


OBIEE 11g Unable to save user preferences error

May 21st, 2012 Jasdeep Singh Comments off

We recently came across an error when the user was trying to save their preferences in OBIEE 11g “My Account” setup. We are using OBIEE 11.1.1.5.0.

User Preference Error

User Preference Error

The error message read:

Exception occurred when saving user preferences to the catalog access denied for user to path /users/{USER_NAME}/_prefs/userprefsxmlstore

After running some searches on the Oracle forums, we came across a solution where we had to delete the User folder from OBIEE catalog. OBIEE will recreate the folder when the user logs in again with new folder privileges for the user.

Step 1: Delete the User folder from OBIEE Catalog Manager.

Delete User folder from OBIEE Catalog Manager

Delete User folder from OBIEE Catalog Manager

Step 2: Restart OBIEE presentation services.

Step 3: Login and update User Preferences.

New Patch available for upgrade to OBIEE 11.1.1.6.1

April 30th, 2012 Jasdeep Singh No comments

A new patch for OBIEE is available now. The patch is for Oracle Business Intelligence Enterprise Edition 11.1.1.6.0.

The patch is available at Oracle Support:  13742915

Bug fixes in this patch listed on the Oracle Site include:

13567594:SDE_FUSION_NATURALACCOUNTDIMENSION MAPPING FAILS IN RUP2 ETL
13355378:PROGRESS BAR HANGS FOR THE 'ADMINTOOL/COMMAND' UTILITY (PATCH COMMAND)
13360114:RPDPATCH DECISION FILE NEEDS TO FLAG DELETES THAT CONFLICT
13596792:PATCHRPD UNABLE TO HANDLE DELETED COMPLEX JOIN
13583718:SERVER CRASH DURING INTERNAL FULL OUTER STITCH JOIN ON COLUMNS WITH NUMERIC TYPE
13583449:SETTING WINDOW SIZE AND START RECORD RESULTS IN NO RECORDS (EXISTING PRODUCT)
13578840:FUSIONBI BI SERVER INITBLOCKS WITH UNIONS DONT BYPASS DIRECT DB ACCESS
13560202:EXTRACTPROJECT.EXE CRASHES DURING THE PATCHING PROCESS
13393226:INDEXCOL NOT TAKING MINUS CALCULATION (WORKS IN 10G BUT NOT IN 11G)
13568567:PROJECT EXTRACT FAILS TO EXTRACT CERTAIN PROJECTS DURING PATCHING
13596457:PATCHRPD IS NOT CORRECTLY UPDATING PROJECTS WHEN SUBSET PATCHING IS BEING USED
13581658:BIAPPS RUP2 FORCE WEBCAT UPGRADE
13628171:CONSISTENCY CHECK DOESN'T FIX MISSING LTS FOLDERS
13526632:DTE ESSBASE CANNOT CONNECT TO BI
13636501:MATS TESTWEBCATALOG DUMMYCATALOG.DIF
13568305:OBJECT PROPERTY DIALOG AND UDML CODE SHOW DIFFERENT NAMES IN COMPARE
13383217:QDR ISCUSTOMGROUPUNIQUEID DOES UNNECESSARY STRING CONCATENATION
13582384:RUP2 HCM CREDENTIALACCESSPERMISSION IN BI STARTUP LOGS AFTER PATCHING
13640792:CONSISTENCY CHECK DOESN'T FIX UNKNOWN LOGICAL COLUMN TYPE
13640427:RUP2-AIX BI CONVERSION FROM XML TO RPD FAILS WITH PASSWORDS DIFFERENT
13625435:RUP2-ST-CDRM FORMMATING AND ACTION LINK ISSUE AFTER PS5 UPGRADE
13458667:hidden option not available for date columns in table layout
13477267:pm rename view not working in current build.
13401386:auto preview are not prevented except pivot view
13586650:qa psbh1  crash display selection steps view exception condition dble col qdr
13616593:auto preview are not prevented for graph
13517767:positional calc can cause xmlwriter empty document error
13564003:SAVING AN IBOT(AGENT) GIVES ORACLE BI SCHEDULER ERROR [NQSERROR 76016]
13110980:THE SECTION PROPERTIES OF PIVOT TABLE IS NOT EFFECTIVE OR NOT CORRECT
13563800:INCLUCDE SELECTED MEMBER NOT WORKING FOR LEAVES OF IN VALUE HIERARCHY
13592629:CANNOT RECREATE THE SAME CURRENT RPD FROM BISERVERXMLEXEC.EXE
13634568:WIN64  WEBCAT APPLY PATCH FAILED  CATMAN INVALID CHARACTERS IN PATH
13502703:ATTR SELECTIONS ON HIERARCHY COLS SHOULD ALLOW PROMPTING ON COMPARE COL.
13553428:DELIVER TO CORP OID LDAP USERS FAILED WITH IMPERSONATOR DOES'NT EXIST
13627864:BACKPORT OF BUG 13597266 TO 11.1.1.6.1
13566162:otbi cascading b/w two prompt sets is not happening in ps5rc2(11.1.1.6.0)
13626098:RUP2-ST-CDRM  DRILL DOWN REPORT NOT RETURNING OUTPUT
13692889:RPD VALIDATION SCRIPT NEEDS TO BE INSTALLED INTO THE ORACLE HOME
13573564:audit  wrong subject area when webcat is large
13375536:audit  catman report not displaying columns
13573558:audit  case sensitive check against rpd
13578848:audit  unable to report on sql in non-analysis
13642995:BISERVERXMLEXEC CRASHES WHILE REGENERATING PS1 RPD
13561559:RUP2-ST2-CDRM  SECTION FORMATTING IS SKIPPED WHEN APPLY PROMPT OR CLICK REFRESH
13574731:QM CRMQA_RRF - DASHBOARD CONTENT
12978196:column selector does not pass values from summary report to detailed report
13680310:ERROR DISPLAYING VIEW WITH NESTED AND SAVED CALC ITEMS
13707164:npe in catalogtaghandler.removejunkfromxml
13332593:PATCHING FAILED WITH ERROR DURING THE XML EXECUTION
13623096:AFTER APPLYING PATCH:13428026, THE SEGMENTATION FAULT IS HAPPENED
13403816:after applied mlr 13110245 still having the hierarchical prompt issue
13535937:NEGATIVE VALUE IN CACHE MANAGER
13710970:BISERVERXMLEXEC CRASHES DUE TO BROKEN NQSTRING'S C_STR() METHOD
12992697:PAGE BREAK WITH COLUMN BREAK DOES NOT WORK WHEN USE PRINTABLE HTML
13249783:AFTER APPLY PATCH 129725592 OBIEE 11G THROWS BAD XML INSTANCE
13098323:AN ARITHMETIC OPERATION IS BEING CARRIED OUT ON A NON-NUMERIC TYPE
13043745:PIVOT TABLES LAYOUT COLLAPSES WHEN HIDDEN ROW AND TOTALS BEFORE IS USED
13719583:38028 CONSISTENCY CHECK ERROR SHOULD BE MADE WARNING
13350175:ADDING FILTER TO DIFFERENT LEVELS OF A HIERARCHY GETS IGNORED IN MDX
13083074:PROMPTS CREATING UNSPECIFIED ERROR WHEN SELECTING MULTIPLE CONSTRAINED CRITERIA
13546009:SELECT PIVOT TABLE IN VIEW SELECTOR CAUSES COLUMN TO BE EXCLUDED WHEN DRILLING
13733427:ADD AND UPDATE VERSION STRING TO DIFF FILE
13071711:CIRCULAR JOIN ERROR WHEN RUNNING ANALYSIS USING UPGRADED REPOSITORY
13649502:rup2-st1cdrm  drill down report not returning output - staying busy
13522060:RPD SESSION VARIABLE UNABLE TO IDENTIFY THE DYNAMIC SCHEMA NAMES FOR OLAP
13626491:REPORTS ARE FAILING AFTER APPLYING PATCH13470147 WARNINGS IN CONSISTENCY CHECK
10647655:COLUMN DATA FORMAT IS IGNORED ON WRITEBACK
13724814:ADD ABILITY TO RETRIEVE QUERY METADATA ON ISSUE RAW SQL SCREEN
13405110:opening report crashes bi presentation services
13393602:rsum not calculating correctly when there are excluded columns
13567100:case when used in measure in pivot is not working as in 10g
12612904:total picks value in first row and gives not a number when averaging null
13647309:obiee grand total functionality incorrect and inconsistent with olap cubes
13400140:multi-step promt missing the dashboard prompt which limit values by is set
13523548:error out when using multiple double columns in saved filters
13444157:error when use is in top operator in filter with presentation variable
13533404:SECTIONS HEADERS ARE CAUSING DASHBOARD SPACING ISSUES
13501903:PATCH FOR BUG 11837656 DOES NOT FIX THE ISSUE WITH DOUBLE QUOTES
13724995:CONSISTENCY CHECK CRASHES ON PS1 RPD
13418590:export to excel still not working properly after patch 12394949 (linux 64)
13682411:CALC ITEM NOT DISPLAYED IN A PIVOT TABLE AFTER PATCH 13544352
13562847:PG/PROMPTS DROPDOWN LISTS ONLY GROUP MEMBERS AFTER PICK GRP FROM DROPDOWN
13739082:ASSERTION ERROR IF VALUE HIER WITH CALC ITEM MOVE TO PAGE/PROMPTS EDGE
12981896:mapviewer hover tooltips show wrong values

BI Publisher Graph Axis Label Formatting

April 10th, 2012 Jasdeep Singh Comments off

Last week, I started blogging about advanced Graph formatting in BI Publisher RTF templates. This week, I’ll share some more formatting features – how to format axis labels. In a report, we are using a combination graph. This graph displays volumes (whole number/integer) and percentages. The default chart generated by template wizard does not display “%” symbol for the percentage. Also, the volumes are scaled to thousands (“K”). We’d like to turn the scale off and display the whole number and format the percentages to display “%” in the axis label.

Default Graph

Default Graph

As discussed in the previous blog, the element that we use to control formatting is: ViewFormat.

As per graph.dtd, the attributes for ViewFormat are:

<!-- ViewFormat specifies number formatting-->
<!ELEMENT ViewFormat EMPTY >
<!-- ViewFormat attributes
numberType: format numbers as currency or percent?
thousandSeparator: character for separating thousands
decimalSeparator: character for separating whole number from decimal
currencySymbol: currency symbol; numberType must be NUMTYPE_CURRENCY
leadingZero: display leading zeros?
decimalDigit: number of decimal digits to display
posNumFmt: format for positive numbers
negNumFmt: format for negative numbers
posCurFmt: format for positive currency
negCurFmt: format for negative currency
scaleFactor: how much to scale (abbreviate) numbers
scaleDownThousands: character(s) to use when numbers represent thousands
scaleDownMillions: character(s) to use when numbers represent millions
scaleDownBillions: character(s) to use when numbers represent billions
scaleDownTrillions: character(s) to use when numbers represent trillions
scaleDownQuadrillions: character(s) to use when numbers represent
quadrillions
javaDateFormat: Java date format
oracleDateFormat: Oracle date format

Now to fix our graph, we will go into the “Advanced” tab of the chart wizard and apply the following code:

Formatting Code

Formatting Code

<Y1Axis>
<ViewFormat numberType="NUMTYPE_GENERAL" numberTypeUsed="true" decimalDigit="0" decimalSeparatorUsed="true" decimalDigitUsed="true" scaleFactor="SCALEFACTOR_NONE" scaleFactorUsed="true" />
</Y1Axis>
<Y2Axis>
<ViewFormat numberType="NUMTYPE_PERCENT" numberTypeUsed="true" decimalDigit="0" decimalSeparatorUsed="true" decimalDigitUsed="true" />
</Y2Axis>

The scale factor is removed using scaleFactor=”SCALEFACTOR_NONE” scaleFactorUsed=”true” and we apply the percentage using numberType=”NUMTYPE_PERCENT”.

Values for Scale Factor are:
SCALEFACTOR_THOUSANDS
SCALEFACTOR_MILLIONS
SCALEFACTOR_BILLIONS
SCALEFACTOR_TRILLIONS
SCALEFACTOR_QUADRILLIONS

Values for Number Type are:
NUMTYPE_GENERAL
NUMTYPE_CURRENCY
NUMTYPE_PERCENT

After formatting changes, our chart axis labels looks like this:

Formatted Graph

Formatted Graph

BI Publisher Graph Data Label – Decimals

April 3rd, 2012 Jasdeep Singh Comments off

We are using BI Publisher RTF templates to create reports that contain Graphs. We recently ran into an issue where we tried displaying data labels on a Bar Chart… We turned on the Data Label property in Chart Wizard and set MarkettextDigit to “0″. Even though MarkertextDigit was set to “0″, when we rendered the graph, it displayed decimals in the graph’s data labels.

Data Label properties in Chart Wizard

Data Label properties in Chart Wizard

After some investigation, we found out that to turn of the Decimals, we have to perform an extra step. We had to go into the “Advanced” tab of the Chart Wizard and modify the graph code.

Add decimalSeparatorUsed

Add decimalSeparatorUsed

<Y1ViewFormat><ViewFormat decimalDigit="0" decimalDigitUsed="true" decimalSeparatorUsed="true"/></Y1ViewFormat>

Adding the decimalSeparatorUsed=”true” clause with decimalDigit=”0″ got rid of the decimals in graph data labels.

Note: Setting the MarkertextDigit to any number greater than 0 works. It displays the correct number of decimals in the graph’s data labels. We only had to modify the graph code to hide the decimals.

New Features for Oracle BI Publisher with OBIEE 11g (11.1.1.6.0)

February 21st, 2012 Jasdeep Singh Comments off

As per Oracle documentation, the news features for the latest BI Publisher release include:

  • Changes in the report creation process, a new and better process flow for designing reports.
  • New option to display parameters as check boxes and radio buttons.
  • Parameters can now be displayed in a vertical region or on a separate full page. Report users can also show or hide parameters.
  • Search option is now available in parameter menus.
  • Report developers can now hide the “Apply” button in parameter region. If the button is removed, selecting a new parameter value will rerun the report.
  • HTML formatting is now supported in reports. Some HTML features such as Nest lists, inserted tables and images are still not supported.
  • New output types PDF/A and PDF/X. These are advanced variations of PDF standard.

For more details refer to the oracle documentation at: http://www.oracle.com/technetwork/middleware/bi-publisher/documentation/index.html

OBIEE 11.1.1.6.0 is now Available for Download on eDelivery

February 21st, 2012 Jasdeep Singh Comments off

We are excited about the new OBIEE 11g release of 11.1.1.6.0.

The Software download is now available on edelivery.oracle.com: https://edelivery.oracle.com/EPD/Download/get_form?egroup_aru_number=12854069

More on new features to follow soon….

Firefox 10 not supported by OBIEE 11g 11.1.1.5

February 12th, 2012 Jasdeep Singh Comments off

I recently upgraded my Firefox browser and to my surprise I couldn’t log into OBIEE. I was hit by this error:

Firefox OBIEE Error.

Firefox OBIEE Error.

The upgraded firefox version is 10.0.1:

Firefox Upgrade 10.0.1

Firefox Upgrade 10.0.1

I’ve had no issue using BI Publisher. It seems like the upgrade only impacts Analytics.

Oracle Support states, “If you need a fix now, please contact Oracle Support who can request a one-off patch suitable for your environment.” Firefox 10 is scheduled to be supported in the next release and 11.1.1.5 patch bundle.

I found a patch on the Oracle Support site but this patch is only for Windows 32 Bit Platform. Patch 12877995.

BI Publisher 11g 11.1.1.5 February 2012 Update Available

February 8th, 2012 Jasdeep Singh Comments off

A new patch for BI Publisher is available now.

Search for: Patch 13683731: UPDATE FOR BI PUBLISHER ENTERPRISE 11.1.1.5.0 FEBRUARY 2012

The bug fixes listed on the Oracle Site include:

9102877 – QA: QUERY BUILDER GENERATES INCORRECT SQL FOR MANY DBS
10071370 – IF ‘USE SECURE FTP’ IS CHECKD ON ADMIN PAGE, ITS SERVER IS NOT LISTD WHEN SCHED
10402890 – SETTINGS FROM “DELIVERY CONFIGURATION” PAGE NOT BEING HONORED WHEN REPORTS RUN
11678983 – QA:LDAP CONFIG ASSUMES THAT ADMIN IS DEFINED UNDER USERS (DISTING NAME FOR USERS
11725468 – ER: RTE HTML SUPPORT IN DATA XML
11828672 – QA: INCORRECT INACTIVE WARNING MESSAGE
11835845 – 11G SQL DATA SET CREATION ORA-01756 ERROR BECAUSE COLON IS READ AS BIND VARIABLE
11850902 – SHARE REPORT LINK “NO PARAMETERS” AND “DOCUMENT ONLY” RENDER INCORRECTLY
11855658 – SEARCH PARAMETER THROWING ERROR IN XML VIEW UI
11870449 – BI PUBLISHER XDOXSLT:SDIV() FUNCTION RESULTS NOT CORRECT
12312539 – QA: REPORT VIEWER SCREEN FREEZES FOR A FLEX REPORT WHEN SESSION EXPIRES
12376386 – REMOVETEMPLATEFORREPORT API DOESN’T REMOVE TEMPLATE
12405904 – CANNOT DEPLOY BIP WHEN DEPLOYMENT PATH INCLUDES SPACE CHARACTERS
12406034 – CANNOT USE JAVA DB – DERBY – FOR SCHEDULER DATABASE
12538753 – OUTPUT FILE INCONSISTENCY USING EMAIL WHEN FORMAT IS EXCEL2007 IN BIP SCHEDULER
12570248 – PROJECTS : -GENERATE REV/INV PROCESS ERRORING OUT
12588342 – DELETEOBJECT RANDOM FAILURE
12595931 – WHEN PRINTING CHARTS TO PDF, NUMBERS BECOME ARABIC NUMBERS
12615821 – MISSING MEMBERS ON THE XML GENERATED BY BIP
12634030 – RE-PACKAGING MLR#11893189 TO XDOPARSER11G.JAR
12646493 – ORA-22902 CURSOR EXPRESSION NOT ALLOWED
12666066 – ER: EXCEL 2007 SUPPORT IN REST API
12705244 – JOINED MDX DATA SETS DO NOT PRODUCE CORRECT DATA – DATA MISSING
12726163 – NUMBER OF SESSIONS INCREASES AFTER RUNNING SCHEDULED JOBS
12737670 – GROUP BY FOR MDX DATA SET MISSING IN 11.1.1.5 – WAS PRESENT IN 11.1.1.3
12741858 – BI ASNWERS ANALYSIS IMPLEMENTING CASE WHEN STATEMENTS CAN NOT BE CONSUMED IN BIP
12750192 – ER: GENERATE NATIVE COMBINATION DUAL Y GRAPH IN PPTX OUTPUT FROM RTF AND XPT
12766932 – VERTICAL DUAL Y COMBO CHART MISSING SETTINGS TO ASSIGN VALUES TO AXIS
12775400 – DBFW:GENERATING IN XLXS OUTPUT IS THROWING AN ERROR
12822514 – SQL WITH CLAUSE – DATASET DOESN’T WORK (AND DIAGNOSTIC ISN’T HELPFUL)
12828845 – ISSUE WITH XDO_USER_NAME PARAMETER ON BIP 11.1.1.5.0
12835431 – INTRANSIT VALUATION REPORT QUERY GIVING ERROR IN EDITOR
12847306 – BI PUBLISHER DATA SET – WON’T SAVE
12872831 – EXCEL TEMPLATES GENERATING INCORRECT RESULTS FROM NESTED GROUPS
12879801 – ALLOW SAVING DATA MODEL WITH SPECIAL CHARACTER
12945367 – NOT ABLE TO EDIT DATA MODEL WHEN LINKS EXIT AMONG DATA SETS
12945475 – IE: NOT ABLE TO EDIT DATA MODEL WITH MANY DATA SET AND LINKS
12956901 – IN SQL SERVER CLOB IN DATA MODEL UI MARKED AS STRING DATA TYPE
12956915 – INCORRECT DATA WHEN PROCESSING OF CLOB COLUMNS FOR SQLSERVER
12956934 – DATA MODEL SHOULD RESPECT CASE SENSITIVITY FOR COLUMN AND TABLE NAMES
12972559 – XML DATA FILE TRUNCATED
12972852 – DYNAMIC IMAGES BROKEN FOR FO/PDF
12989467 – NEED TO CONVERT DOCUMENT FORMAT “EXCEL” TO “EXCEL2000″
13005659 – PSR:PERF:BIP:POOR PERF ACCESSING CATALOG FOLDER IN BIP 11G WITH SECURITY ENABLED
13007341 – DISPLAY ISSUES IN PARAMETER TAB OF OBI PUBLISHER 11G
13095050 – STRESS: OUTOFMEMORY ERRORS WITH VIEW REPORT STRESS
13100021 – BI PUBLISHER: QUERY BUILDER RESULTS RETURN COLUMN TYPE (APPEARS) INSTEAD VALUE
13100220 – HOW TO USE 11.1.1.5 WITH THE IDENTITY ASSERTER
13250009 – FOR METADATA LOGICAL SQL BIND WITH DUMMY VALUES INSTEAD OF NULL
13321449 – RESOURCELIMITEXCEPTION DURING ANY OPS THAT USE JNDI DATA SOURCE
13346737 – MULTIPLE VALUES IN A DASHBOARD PROMPT DOESN’T WORK WITH BI PUBLISHER INTEGRATED
13351305 – QUERY BUILDER DOES NOT BUILD CORRECT SYNTAX FOR SQL SERVER
13391941 – FROM BI 11G QUERY BUILDER:THE COLUMNS THAT HAVE SPACES ARE NOT DISPLAYED AT ALL
13393658 – PRINTER DELIVERY [0] STATUS: FAILED PRINTING FROM WEB SERVICE CALL FROM EXTERNAL
13421264 – ADDING PARAMETER TO SQL BI SERVER DATA SET CORRUPTS DATA MODEL
13459907 – NONSTRESS:FA:PRC PS5 BASED FAINTEG: PDF GEN FAILS, XDOEXCEPTION
13481659 – CAN’T SAVE ON BI DEV ENV RC2
13501838 – ORA-00923 ISSUE WHEN CREATING A BI PUBLISHER DATASET
13521951 – BIP UPGRADE FROM 10G TO 11.1.1.5.0 IS NOT SUCCESSFULL FOR TIAA-CREF
13562801 – XML TAG DISPLAY SHOULD DEFAULT TO ‘FOLLOW THE DATA STRUCTURE’
13529494 – BI REPORT NOT GENERATED WHEN HTML CONTAINS INVALID ATTRIBUTES
13568043 – BIP QUERY FAILING VALIDATION DUE TO ‘COALESCE’ KEYWORD
13592901 – THE REPORT IS THROWING AN SQL ERROR THAT REFERENCES CHECKING FOR NULL VALUES
13611515 – CAN’T SEE PERMISSIONS FOR JAPANESE FOLDER, REPORTS.
13684789 – UNABLE TO SELECT COMPANY PROMPT. PROMPT VALUES ARE HIDDEN BELOW THE PDF