Zmrss Reader » OracleERP

« Expand/Collapse

OracleERP (100 unread)

February 05, 2012
13:27
Review of Oracle Service Bus 11g Development Cookbook (Packt Publishing) by Edwin Biemond, Guido Schmutz, Eric Elzinga et. al.
» ‎ AMIS Technology blog

Recently I gained access to an electronic copy of the just released Oracle Service Bus 11g Development Cookbook, written by five authors – all experts on OSB and three personal acquaintances of mine. I was very interested in learning about the final result after hearing many intermediate comments during the writing process as well as [...]
5:06
Sending an email with attachment from Oracle BPEL
» ‎ AMIS Technology blog

In my previous post I described how to create a PDF file/report in Oracle BPEL (Create a JasperReport from Oracle BPEL). Now I will describe how to sent this PDF file as attachment in an email. After invoking the createBookService the outcome is used to construct the email message. In particular the filename and the [...]
4:59
Create a JasperReport from Oracle BPEL
» ‎ AMIS Technology blog

In my previous post I described how to create a Report (CDBooklet) with JasperReport in Java. Follow this link to take a look at the post ‘Using Java to create a report with the JasperReport java API’ For this new post I created a webservice wrapper around this reporting functionality and deployed it to a Weblogic [...]
February 03, 2012
22:47
Intercepting user customization – such as column reordering in tables – in ADF 11g change persistence
» ‎ AMIS Technology blog

The requirement I was facing was simple: act on column reordering through user drag and drop in a rich table. More specifically: invoke a method in a managed bean whenever the user changes the position (or side or visibility) of a column. At first it seemed trivial – just use an AttributeChangeListener. When that turned out [...]

February 01, 2012
9:33
Get thee to University!
» ‎ Oracle BI Publisher Blog

Friends of BIP, STR Software have put together a great web based resource 'BIP University'

Focused on the E Business Suite flavor and their own integrations with BIP under EBS R12; its a great resource and well worth a few clicks and a read. Check it out here - http://www.bipuniversity.com/
January 28, 2012
10:42
Oracle Policy Automation and BI Publisher
» ‎ Oracle BI Publisher Blog

Yep, found another integration with BIP. I get asked about Oracle Policy Automation quite a lot; I do not profess to know much; enough to be dangerous I guess. However, I was not aware that they had been working with BIP to help automate the generation of documents from the system.

For the uninitiated, here's the blurb care of :

Oracle Policy Modeling is a Windows desktop application for transforming legislation and policy documents into executable business rules. Rules are written in Word and Excel documents using phrases in languages such as English, Chinese and French. These rule documents can be shared amongst business and information technology stakeholders, and commentary can be added into the documents without affecting the structure of the rules themselves. Other features of Oracle Policy Modeling include integrated test case execution and debugging capabilities, and the definition of interviews for interactive rule-based assessments. Interview screen order and branching logic can be defined using visual flow diagrams.

In other words, a cool piece of technology, but tell us Tim how is it used? Well, it has been publicly deployed within several government web-sites. Australia's Department of Immigration uses it for visitors to check their eligibility for visas. The UK uses it for their Employment Status Indicator assessment tool, the UK governments online portal for businesses also uses OPA for over 60 interactive tools while the United States uses the software for guidance on tax law. The last one might be pertinent for me this weekend as W-2s have arrived and I have a night of misery trying to get a refund.

How does BIP fit in? Pictures are worth a thousands words and Fiona from the development team down under has recorded a great YouTube session explaining the integration and how to take advantage of it. I know I'm becoming more American cos I found it a little hard to place her accent at first, not to be rude Fiona but was it Brit, Aussie or maybe New Zealand? I plumped for Aussie, 10 points to me ... phew!

Direct link to the OPA YouTube channel - some other great vids on use cases and features.

You can find the OPA Homepage here lots of info on the tool and its possible applications.

January 24, 2012
1:29
Jouw toekomst als Oracle professional – AMIS informatieavond over jouw ontwikkelingspad
» ‎ AMIS Technology blog

Als je dit leest en je bent Oracle professional – ontwikkelaar of administrator – is de kans groot dat je jouw carriere bent gestart in de jaren ‘90, in het tijdperk van Oracle7, Oracle Forms en Client/Server applicaties – net voor de opkomst van Java, internet, mobiel en SOA. Misschien ligt je start daar nog [...]
January 23, 2012
4:59
Masterclass Oracle 11g voor Database Ontwikkelaars – haal meer uit SQL en PL/SQL in 11g
» ‎ AMIS Technology blog

Aanstaande vrijdag 27 januari verzorgt Oracle ACE Director Alex Nuijten bij AMIS Services in Nieuwegein een Masterclass voor Oracle Database Developers: iedereen die met enige regelmaat SQL en/of PL/SQL toepast in zijn of haar werk. In deze Masterclass leidt Alex de deelnemers rond in Oracle Database 11g Release 1 en 2 met als voornaamste doelstelling [...]
January 22, 2012
0:01
Using the Oracle WebLogic Technology Adapters with custom Java – Message Driven Bean (MDB) triggered by File Adapter (part of the story)
» ‎ AMIS Technology blog

Oracle’s product portfolio contains the Technology Adapters. A set of JCA Connectors that provide a bridge between various technologies – such as JMS, AQ, Database (SQL and PL/SQL), FTP and File System – on the one hand and the world of JEE on the other. The SOA Suite 11g and Oracle Service Bus leverage these [...]
January 21, 2012
2:08
Developing and deploying Java Embedding activity in BPEL 2.0 in SOA Suite 11g calling a custom Java Class that has dependencies on 3rd party libraries
» ‎ AMIS Technology blog

Java Embedded activity can call a custom Java class that relies on 3rd party Java libraries. This means that a lot of existing functionality from the Java open source community is at the disposal of the BPEL developer. This article shows a simple example of developing and deploying a BPEL process that uses Java Embedded [...]
January 19, 2012
23:19
Create simple Java application to post JSON message to CometD Bayeux Channel using Apache HttpClient and Maven style NetBeans project
» ‎ AMIS Technology blog

The objective discussed in this article is to post messages to a CometD Bayeux Channel with a standalone Java Class – without dependencies on CometD. For example to control from Java the Slideshow introduced in the synchronized Slideshow demo application created using CometD (see previous articles Push based synchronized Slideshow demo application implemented using CometD [...]
2:11
Publishing to CometD Bayeux Channel from inside the Oracle Database – PL/SQL based push to CometD Web Client
» ‎ AMIS Technology blog

In recent articles, I have introduced CometD as framework for Server to Client and Client to Client Push: Running CometD 2 examples – locally on Tomcat using Maven and NetBeans http://technology.amis.nl/blog/14709/running-cometd-2-examples-locally-on-tomcat-using-maven-and-netbeans, CometD 2 Java Client Sample – open project in NetBeans based on Maven pom file, modify sources and run Java Based Comet Client (http://technology.amis.nl/blog/14720/cometd-2-java-client-sample-open-project-in-netbeans-based-on-maven-pom-file-modify-sources-and-run-java-based-comet-client) [...]
January 18, 2012
0:43
Sharing session state between JEE web application through WebLogic session descriptor of sharing-enabled
» ‎ AMIS Technology blog

Session state in Java Web application is associated with a single (user) browser session on the one hand and typically with a specific web application on the other (server side) hand. Session state is created and maintained in the context of a usually a single web application. However… We ran into a situation where our web [...]
January 17, 2012
0:52
Using custom functions in EL expressions in JSF 1.x
» ‎ AMIS Technology blog

EL expressions are one of the main driving forces for JavaServer Faces. Most dynamic characteristics of pages and widgets are governed by EL expressions. In JSF 1.x, there are some limitations for EL expressions that can at times be a little frustrating. One of the limitations is the fact that no custom functions or operators [...]
January 16, 2012
0:39
Retrieve song lyrics in Java using Screenscraping with JSoup
» ‎ AMIS Technology blog

Last year I wrote about JSoup, a Java library that helps with screenscraping: Screenscraping from Java using jsoup – effective data gathering from websites (http://technology.amis.nl/blog/13121/screenscraping-from-java-using-jsoup-effective-data-gathering-from-websites). Last month I had another opportunity for using JSoup, this time to gather song lyrics for the songs on a CD. The context in this case was the internal SOA [...]
January 15, 2012
5:05
Using Java to create a report with the JasperReport java API
» ‎ AMIS Technology blog

In this blog I will describe how to create a Report with JasperReport in Java. For this purpose I have used the Communitie edition of iReport. This edition contains besides JasperReport also iReport. iReport is a report designer for JasperReport. You can download it from http://jasperforge.org/projects/ireport After installation I started iReport to design a report. I [...]
2:10
Stand-alone Java Client for jWebSocket Server – communicating from Java Client to Web Clients and vice versa over WebSockets
» ‎ AMIS Technology blog

In a previous article, I have discussed the open source jWebSocket Server and a simple installation and configuration (http://technology.amis.nl/blog/14940/first-steps-with-jwebsocket-open-source-java-framework-for-websockets-installation-and-running-samples). Subsequently, I have shown the implementation of a web client for a synchronized Slideshow application, where WebSocket communication is used to perform Client 2 Client push (http://technology.amis.nl/blog/14949/push-based-synchronized-slideshow-web-application-implemented-using-websockets-and-jwebsocket-server-the-open-source-java-websocket-server). In a third article I have explained how jWebSocket [...]
January 14, 2012
2:32
Implementing a Java Server Side component for jWebSocket Server for WebSocket interaction with Web Clients
» ‎ AMIS Technology blog

In a previous post – http://technology.amis.nl/blog/14949/push-based-synchronized-slideshow-web-application-implemented-using-websockets-and-jwebsocket-server-the-open-source-java-websocket-server – I discussed the implementation of the synchronized slideshow application using Web (HTML/JavaScript) clients and jWebSocket as websocket server. In an earlier article, I described the same for the Kaazing WebSocket server – http://technology.amis.nl/blog/14777/push-based-synchronized-slideshow-web-application-implemented-using-websockets-and-kaazing-websocket-gateway – and both stories are (fortunately) fairly similar. In the Kaazing article I also described [...]
January 13, 2012
0:41
Push-based synchronized slideshow web application – implemented using WebSockets and jWebSocket server – the open source Java WebSocket server
» ‎ AMIS Technology blog

In a recent article, I have introduced jWebSocket – an open source Java based server for WebSocket communication: http://technology.amis.nl/blog/14940/first-steps-with-jwebsocket-open-source-java-framework-for-websockets-installation-and-running-samples. In this article, I have described how to download and install the jWebSocket server and how to get going with running some of the distributed samples. In another recent article, I looked at the implementation of a [...]
January 12, 2012
4:03
First steps with jWebSocket – open source Java framework for WebSockets – installation and running samples
» ‎ AMIS Technology blog

This month, In have been delving into Push architectures for the Web, looking into WebSockets among several other things. WebSockets, a fairly new standard (!) evolved along with HTML 5, specifies a communication protocol that provides an alternative to classic HTTP communication. WebSocket based interaction has lower overhead and – more importantly – is bi-directional [...]
January 11, 2012
0:26
First steps with Java Embedding in Oracle SOA Suite 11g BPEL 2.0 – useful API calls
» ‎ AMIS Technology blog

While preparing for the next session in our internal SOA for Java Professionals training program on BPEL, I revisited the BPEL activity Java Embedding that allows us to enrich a BPEL process with custom, Java based functionality. I tried to determine how best to explain, present and demonstrate this activity to my colleagues. This article [...]
January 10, 2012
1:32
Introduction of BPEL 2.0 forEach activity – valuable loop and standard based successor to FlowN
» ‎ AMIS Technology blog

BPEL 2.0 introduced the forEach activity – similar to for [-loop] found in many programming languages. Oracle SOA Suite 11g adopted BPEL 2.0, first in run time (PS2) and later in Design Time (JDeveloper) as well (PS3 an beyond). For BPEL processes created using BPEL 2.0, forEach is a looping mechanism – similar to repeatUntil [...]

January 09, 2012

Permalink for 'Oracle_BI_Publisher_Blog/2012/01/09/BI_Publisher_January_patch_for_11.1.1.5.0'

13:55

BI Publisher January patch for 11.1.1.5.0

» ‎ Oracle BI Publisher Blog

The BI Publisher January patch for 11.1.1.5.0 is now available on Metalink; look for patch 13554951. Thanks to Shinji and team, this is one of the easiest posts of the year so far :0) Contents of the readme below, enjoy!

One-off patch for Oracle Business Intelligence Publisher 11.1.1.5.0 READ ME File ==================================================
This patch contains fixes of following bugs for Oracle Business Intelligence Publisher 11.1.1.5.0.

 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
 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
 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
 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
 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
 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
 13529494 - BI REPORT NOT GENERATED WHEN HTML CONTAINS INVALID ATTRIBUTES

----------------------------- INSTALLATION FOR ENTERPRISE -----------------------------
1. Login to BI Domain Weblogic Administration Console.
2. Find the location of the "bipublisher" application.
3. Stop the bipublisher application.
4. Open a terminal and go to the directory.
5. Back up the existing xmlpserver.ear to xmlpserver.ear.org.
6. Copy new xmlpserver.ear from this patch.
7. In Admin Console, select "Lock & Edit".
8. Select the application "bipublisher" and "Update".
9. Leave all options same and proceed to Finish.
10. Select "Activate Changes".
11. Start the bipublisher application.

------------------------- MDX Query Limitation -------------------------
Joins of two MDX queries on a dimension that uses a MDX function in the Select Clause that requires the stipulation of the same dimension, such as Intersect, MemberRange, Union are not supported. Example)

SELECT
  NON EMPTY Hierarchize([Product].Generations(3).Members) ON Axis(0),
  Hierarchize(Union([Market].Generations(3).Members, [Market].Generations(4).Members, ALL)) ON Axis(1)
FROM Demo.Basic

It should be written using a With Set member:

with set [UnionMarket] as '{Union([Market].Generations(3).Members, [Market].Generations(4).Members, ALL)}'
SELECT
  NON EMPTY Hierarchize([Product].Generations(3).Members) ON Axis(0),
  Hierarchize(([UnionMarket]) ON Axis(1)
FROM Demo.Basic

This MDX set is recreated for the Join clause to:

with set [UnionMarket] as '{Union([Market].Generations(3).Members, [Market].Generations(4).Members, ALL)}'
SELECT
  NON EMPTY Hierarchize([Product].Generations(3).Members) ON Axis(0),
  Hierarchize(Filter([UnionMarket], [Market].CurrentMember.Member_Name = "Boston")) ON Axis(1)
FROM Demo.Basic

----------------------------------------- Query Builder limitation with Microsoft SQL Server -----------------------------------------
Query Builder doesn't support a cross join that does not have a WHERE clause and produces the Cartesian product of the tables involved in the join. The size of a Cartesian product result set of such join is the number of rows in the first table multiplied by the number of rows in the second table. A cross join has a very limited use in everyday data retrieval.

----------------------------- HTML text support in XML -----------------------------
This patch supports HTML embedded in XML. The following new layout command is added to retain HTML format from data in the final output. <?html2fo: xpath?> Example: html code in xml data: user should input the html code to xml data file as CDATA. sample, html code is embedded in field RTECODE.

<?xml version="1.0" encoding="UTF-8"?>
<RTECODE>
<![CDATA[
<font style="font-style: italic; font-weight: bold;" size="3"><a
href="http://www.oracle.com">oracle</a></font> <br/>
<font size="6"><a href="www.oracle.com">www.oracle.com</a></font><br/><br/>
]]>
</RTECODE>

Sample usage in rtf template (assume the data.xml is as above).

<?html2fo:RTECODE?>

Supported html formats: Paragraph Font style ( bold, italic, plain, underline, subscript, superscript and strikes-through) Font size Font family Background color Foreground color Paragraph alignment (center, left, right and justify) Paragraph indent URL link List Bullet List Number List Non-Supported formats: Nested List (List with Indent) Some HTML tags/attributes which manually inserted like Table, Image, etc... in stead of HTML editor Sample Report: XML: html_test.xml RTF tempalte: html_test.rtf

2:58
Push based synchronized Slideshow demo application implemented using CometD and jQuery running on Tomcat
» ‎ AMIS Technology blog

In a string of recent articles, I have discussed downloading, installing and running demos for a number of different tools, frameworks and libraries that support push-style (web) applications in one way or another. I have looked into ‘classic’ comet with Grizzly, Atmosphere and CometD as well as ADF Active Data Service and WebLogic Pub/Sub (Bayeux) [...]
January 07, 2012
23:36
Get going with Kaazing WebSocket Gateway – HTML5 Edition – installing locally and running demos
» ‎ AMIS Technology blog

My last few articles on this blog site have all dealt with push architecture and technology in some way. This is an area that I have been investigating into quite bit recently. Part of these investigations had to be of course Kaazing, a specialized commercial offering, specifcally around WebSockets and its application in new HTML [...]
January 06, 2012
21:32
Push-based synchronized slideshow web application – implemented using WebSockets and Kaazing WebSocket Gateway
» ‎ AMIS Technology blog

In the last few articles, I have discussed downloading, installing and running demos for a number of different tools, frameworks and libraries that support push-style (web) applications in one way or another. I have looked into ‘classic’ comet with Grizzly, Atmosphere and CometD as well as ADF Active Data Service and WebLogic Pub/Sub (Bayeux) Channels. [...]
1:11
NetBeans 7.1 – JavaFX 2.0 support, refactoring enhancements and great Maven 3 integration
» ‎ AMIS Technology blog

NetBeans 7.1 has just been released. It is interesting how NetBeans continues to evolve – after many doubts were raised with regard to its future after the Oracle-Sun acquisition. Oracle maintains two IDEs – each with its own objectives. JDeveloper to support Fusion Middleware development, NetBeans to propel the Java platform and its associates (Groovy/Grails, [...]
January 05, 2012
2:36
Getting Atmosphere – framework for Comet style communication – up and a first sample running on Tomcat
» ‎ AMIS Technology blog

Over the past weeks, I have been dabbling in Comet style, push-based, asynchronous communication enabling frameworks and libraries – including CometD, Atmosphere, Kaazing, jWebSocket, Grizzly and others. This short article will describe how I went about setting up Atmosphere on my local environment to the point that I could successfully run at least one of [...]
1:15
Business Validation in Oracle SOA Suite 11g using Schematron
» ‎ AMIS Technology blog

In a previous post I’ve explained the Schematron standard, how it works and how to use it. In the Oracle SOA Suite you can ‘Validate Semantic’ on the input (request) of a routing rule in a Mediator component by selecting a Schematron file. This is the Schemtron xml file in which you define your validation [...]
January 04, 2012
1:37
CometD 2 Java Client Sample – open project in NetBeans based on Maven pom file, modify sources and run Java Based Comet Client
» ‎ AMIS Technology blog

On the heels of previous articles that described setting up NetBeans (http://technology.amis.nl/blog/14661/first-experiences-and-getting-started-with-glassfish-3-1-and-netbeans-7-x-its-a-breeze), Tomcat 7 (http://technology.amis.nl/blog/14688/installing-tomcat-7-and-configuring-as-server-in-netbeans) and the CometD 2 environment (http://technology.amis.nl/blog/14709/running-cometd-2-examples-locally-on-tomcat-using-maven-and-netbeans), this article describes how I opened the Java Client Examples from the CometD project in NetBeans (creating a NetBeans project based on the Maven pom.xml included in the CometD distribution), made a few changes [...]
January 02, 2012
23:57
Running CometD 2 examples – locally on Tomcat using Maven and NetBeans
» ‎ AMIS Technology blog

Push technologies is an area of interest to me. I have been looking into frameworks, servers and libraries such as Atmosphere, ADF ADS, CometD 2, Kaazing, jWebSockets, Grizzly and others. In my experience, even though there is a lot of information to be found through Google, it is not simple to quickly gain a good [...]
January 01, 2012
22:15
Installing Tomcat 7 and Configuring as Server in NetBeans
» ‎ AMIS Technology blog

Tomcat 7 is a Servlet Container – a fairly light weight container, very convenient for development and testing. While not a full application server, Tomcat implements the functionality described in the Java Enterprise Edition Web profile specifications. Most notably, it supports version 3.0 of the Servlet API (application programming interface) and version 2.2 of JavaServer [...]
10:35
Preparing your environment for modern open source Java libraries and frameworks using Git and Maven, throwing in Tomcat as a bonus
» ‎ AMIS Technology blog

In my investigations into jWebWSockets, Kaazing, Atmosphere, CometD 2 and other frameworks I came to understand that in order to get these frameworks installed, integrate them into my custom applications or run the samples to go with these products, it would be convenient if not essential to have an environment with Maven and Git operational [...]
December 31, 2011
4:33
First experiences and getting started with GlassFish 3.1 and NetBeans 7.x – it’s a breeze
» ‎ AMIS Technology blog

Several years back, AMIS selected GlassFish as its preferred Open Source J(2)EE Application Server, over for example JBoss. Some of the criteria at the time were: speed of implementation of new functionality and integration of JEE (being the reference implementatoin), ease of administration, enterprise quality, small yet rapidly growing market share (the band wagon to [...]

December 27, 2011
9:05
Online Wireframes – a new Cloud service for Dashboard prototyping
» ‎ AppsBI : Applications Business Intelligence
Whether you build dashboards using OBIEE, Cognos or SAP Business Objects, it is always a pain to build quick dashboard prototypes to demonstrate users and build project momentum.

Project Momentum is very important in predicting the outcome of your new project proposal.
- How soon can you show your new client
- What can you demonstrate
- What is your process
- How unique and innovative are you
Before the client approaches you for a quote and a POC they have definitely done some internal research and probably installed the basic setup. So why waste time in demonstrating the same packaged OBIEE stuff which your client has already done it by visiting various blogs and updates on the web.

What is so unique that you can demonstrate?
- Build some innovative dashboard design patterns
This is something that will catch your client’s attention among heaps of other consultant companies.

But producing them is time consuming with the toolset itself.

So why not just build some cool wireframes and prototypes and send your unique approach to your potential client?

This is so easy. Just login to https://www.wireframes.org and build your dashboard prototype, add some cool visualization, comments and demonstrate how different your dashboard can be.

For e.g OBIEE is fully web based and using jquery and various plugins it is possible to completely blow the minds of everyone when you demonstrate something so cool done in OBIEE which no one has ever dared to do it till now.

ShareThis

December 23, 2011
13:40
Siebel Tips and Tricks
» ‎ Oracle BI Publisher Blog

Good tidings for the season to all of you. Its been erratic I know but we have stumbled along this year ...

I have been working with Eric, a Siebel sales consultant whiz on the BIP integration. He shared some really useful tips with a Siebel-BIP customer yesterday which I thought were well worth sharing.

Date Formatting

Firstly, some help with formatting dates when you are using a Siebel integration objects to generate the data. Siebel IOs do not generate the XSD date format that BIP needs to let you format dates to your hearts content. Attached are a couple files that provide some examples on how to manipulate dates to get the desired formats. Some are easy to get working and some need a little effort.

MSWord Plugin Testing

Siebel development have shipped some Siebel-BIP functions that are deployed to the server. However, to be able to test them locally on your desktop you need to get the java libraries into your classpath prior to starting MSWord. Here is the code Eric uses for starting Word with the Siebel classes in a batch file. It assumes that the jar files are available locally on the client machine at C:\811DQSSIA\Client\CLASSES. This will make the classes used by some Siebel report templates available to test directly in Word. I have two versions, one for Word 2003 and one for Word 2007.

Word 2003:

echo %1

set _JAVA_OPTIONS=-Xbootclasspath/a:C:\811DQSSIA\Client\CLASSES\SiebelXMLP.jar;C:\811DQSSIA\Client\CLASSES\XMLP.jar;C:\811DQSSIA\Client\CLASSES\Siebel.jar;C:\811DQSSIA\Client\CLASSES\XSLFunctions.jar;C:\811DQSSIA\Client\CLASSES\SiebelCustomXMLP.jar;C:\811DQSSIA\Client\CLASSES\SiebelCustomXMLP_SIA.jar;

"C:\Program Files\Microsoft Office\Office12\Winword.exe" %1

Word 2007:

echo %1

set _JAVA_OPTIONS=-Xbootclasspath/a:C:\811DQSSIA\Client\CLASSES\SiebelXMLP.jar;C:\811DQSSIA\Client\CLASSES\XMLP.jar;C:\811DQSSIA\Client\CLASSES\Siebel.jar;C:\811DQSSIA\Client\CLASSES\XSLFunctions.jar;C:\811DQSSIA\Client\CLASSES\SiebelCustomXMLP.jar;C:\811DQSSIA\Client\CLASSES\SiebelCustomXMLP_SIA.jar;

"C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft Office\Microsoft Office Word 2007.lnk" %1

Happy Holidays!

6:07
Difficulties with a more complex Business Rule Engine in Oracle SOA Suite
» ‎ AMIS Technology blog

In my previous post I’ve shown how to create a composite in the Oracle SOA Suite with a simple decision table in a Business Rule Engine component. For that post I had used quite a simple data model resulting in a small xml/xsd tree. For our project I wanted to repeat the exercise with the [...]
December 20, 2011
8:10
Using the Oracle XMLDB Repository to Automatically Shred Windows Office Documents (Part 1)
» ‎ AMIS Technology blog

People who have attended the UKOUG presentation this year where Mark Drake, Sr. Product Manager XML Technologies / XMLDB, Oracle HQ, and I demonstrated the first principles of the XDB Repository, might have been impressed with its (GEO/KML Spatial, Image EXIF info) capabilities combined with Google Earth. This post will zoom in on how to [...]
December 13, 2011
5:44
Cookbook creating Business Rule Engine with a simple Decision Table in Oracle SOA Suite
» ‎ AMIS Technology blog

For educational purposes I’ve created a cookbook in powerpoint format on how to create a simple decision table in Oracle SOA Suite with a Business Rule engine. To share this I’ve uploaded it to slideshare and post it here in the Amis blog as well. Cookbook Oracle SOA Business Rules View more presentations from Emiel Paasschens. Additional remark: xml-, [...]
1:33
Factorial in Oracle SQL – using both new Recursive Subquery and classic Connect By approach
» ‎ AMIS Technology blog

I regularly teach a masterclass on Oracle SQL. One of the topics I explore in depth is the use of the CONNECT BY query style to perform not just hierarchical queries but also networking or even generic recursive SQL. In Oracle Database 11g, the recursive subquery was formally introduced, the SQL Standard’s approach to this [...]
December 12, 2011
23:47
Weird ADF 11g requirement addressed with left outer join and modern SQL join syntax
» ‎ AMIS Technology blog

The functional requirement was a little unusual. The page should either show all master-records or – depending on the value of a parameter – it should show exactly one master-record joined with exactly one detail-record. The use case was valid – that was exactly the functionality that was required. In terms of EMP and DEPT -I [...]
4:18
UKOUG 2011 – Drag, Drop and other Stuff. Using your Database as a File Server
» ‎ AMIS Technology blog

Last Thuesday, Mark Drake, Senior Product Manager and I, delivered a good presentation during UKOUG in Birmingham about how to use your database, via XMLDB functionality, as a file server. The presentation demonstrated as well how you could extent the “standaard” file server (aka your database) functionality with features like, WebDAV driven ACL Security and [...]
December 11, 2011
23:35
Absolutely Typical – The whole story on Types and how they power PL/SQL Interoperability (UKOUG, 2011)
» ‎ AMIS Technology blog

This presentation will hopefully convince database developers that types in the Oracle Database are worth their salt – and more. With the recent improvements in 11gR2, the pieces are available to complete the puzzle of structured and modern programming with a touch of OO and more importantly to create a decoupled, reusable API that exposes [...]
8:10
WebLogic 12c questions and answers
» ‎ AMIS Technology blog

I collected some Q&A for you during the WebLogic 12c launch so here they are
3:52
Looking back at UKOUG 2011
» ‎ AMIS Technology blog

Now that the UKOUG annual conference in Birmingham is over, it’s time to write my thoughts down. As this was the second time that I attended the UKOUG conference, I already knew that it is a big conference. Lots of great speakers and a very good agenda. On the agenda were very interesting session, sometimes [...]
December 10, 2011
23:28
The Future of Forms is ….. Forms (and some friends) (UKOUG, 2011 – with Grant Ronald)
» ‎ AMIS Technology blog

Slides for the presentation I did with Grant Ronald during UKOUG 2011, last week in Birmingham. The abstract for this presentation: “Many organizations run enterprise Oracle Forms applications created in the 90s. They now wonder about the future of their application.This session tells how modernization of the application landscape could take place, [...]

December 07, 2011
9:16
Excel 2007 Warnings!
» ‎ Oracle BI Publisher Blog

As many of you have found out, everything is not as it seems with the Excel output that gets generated from an RTF template. It has non-Excel like limitations and the files are quite big. Those of you using Excel 2007 will have noticed another niggle. When you open an 'Excel' output you get a warning along the lines of:

The file you are trying to open, '*.XLS', is in a different format than specified by the file extension. Verify that the file is not corrupted and is from a trusted source before opening the file. Do you want to open the file now?

This is down to BIP actually generating HTML and setting the mime type and extension to get Excel to open it. This is the cause of the limitations and the cause of the warnings. The limitations can be addressed by using an Excel template more on those in the user docs and elsewhere in this blog. Addressing the warning is going to require a modification to your users' registries.

Huge thanks to Abhishek Gupta for digging up a note from Oracle Support on it and thanks to whoever wrote the original. The note number is 1077728.1. I have uploaded Abhishek's snippet form the note here.

Update: Leslie has reminded me; for she is my Jimney Cricket to my Pinocchio, constantly prodding my conscious :0)
As an additional option in 11.1.1.5 Excel 2007 is a new output type from RTF that generates .xlsx.
Excel 2007 is a new output type available for reports. When selected, BI Publisher generates the output in Excel XML format (.xlsx). If you have Excel 2007 or later installed, this option provides the best preservation of layout and formatting.

As noted in the comments, the Excel templates generate binary xls output not xlsx format and therefore have xls limitations in their abilities.
December 06, 2011

Permalink for 'Oracle_BI_Publisher_Blog/2011/12/06/11.1.1.5_December_2011_Update_Available'

20:44

11.1.1.5 December 2011 Update Available

» ‎ Oracle BI Publisher Blog

Latest and greatest from the boys and girls at the coal face for December. Bug fixes and some interesting enhancements that I hope to dig into to here soon.

Search for patch 13366758: UPDATE FOR BI PUBLISHER ENTERPRISE 11.1.1.5.0 DECEMBER 2011 on Oracle Support. Make sure you check out the readme for patch installation instructions.

 9102877 - QA: QUERY BUILDER GENERATES INCORRECT SQL FOR MANY DBS
 10402890 - SETTINGS FROM "DELIVERY CONFIGURATION" PAGE NOT BEING HONORED WHEN REPORTS RUN
 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
 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
 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
 13421264 - ADDING PARAMETER TO SQL BI SERVER DATA SET CORRUPTS DATA MODEL

Enjoy!

December 02, 2011
5:11
WebLogic 12c released!
» ‎ AMIS Technology blog

At December the 1st, 2011, Oracle announced it’s new major release, the 12c release. As Oracle added the i (internet) at its 8 release, the g(gridcomputing) at its 10 release, now the focus will be on the c(cloudcomputing). Many new features come out of the fact that Oracle has made its key application server ready for [...]

December 01, 2011
14:18
Dynamic Content using Sub Templates
» ‎ Oracle BI Publisher Blog
I have written about sub templates in the past on a few occasions; the principle behind them is pretty simple. If you have common report components that can be shared across reports; be they blocks of text like standard contract clauses or maybe some common calculation or function, drop them into a sub template and share the love. Develop once, use everywhere!
A colleague was recently tasked with conditionally bringing into a report output, paragraphs of static text based on some user preferences. That’s an ideal candidate for a sub template approach; drop all of the paragraphs in to an RTF subtemplate and then just conditionally pull them in based on some boolean expressions.
You might, quite naturally think about conditionally importing a series of sub templates rather than defining one, with all the content. However, XSL does not allow the conditional import of sub templates so you must take the single template approach. You can of course, import multiple sub templates if you have a lot of content to bring in but in most cases I would expect a single sub template will suffice.

BIP does need to know what those paragraphs need to be for each user whether that’s as a set of parameter values or a data element in the incoming data set. For this example I have used both approaches and they work all flavors of BIP. Implementation of the sub template onto the servers is going to be a little different but the main principle is the same. I have mercilessly ripped out a nice graphic from Leslie’s (doc writer extraordinaire) documentation.

This is for the 11g version that supports loading sub templates into the report catalog as objects. They can then be referenced in your main template using the import statement:

<?import:xdoxsl:///subtemplatefolder/subtemplatename.xsb?>

The subtemplate folder is going to be from the /SharedFolders or /My Folders root. For instance, I have a sub template ‘paragraphs’ loaded into a ‘test’ folder under Shared Folders. The import statement in my main template is ‘<?import:xdoxsl:///Test/ParaSubTemplate.xsb?>’

Update from Leslie

For those of you testing using your own My Folder area. The syn tax is

<?import:xdoxsl:///~username/path to subtemplate.xsb?> where username is your user name. For example: <?import:xdoxsl:///~tdexter/Subtemplates/Template1.xsb?>

Recommend you move them into the shared folder area in production.

For 10g you will either need to drop them into an accessible directory and use the file URI or mount them into the web server directory structure and access them via an http URI. I normally mount them in a directory under the ‘xmlpserver’ directory e.g J2EE_HOME\applications\xmlpserver\xmlpserver\subtemplates, a template is then accessible via the URI ‘http://server:port/subtemplates/template.rtf’

Make sure you set the Allow External References property to true for the report so that the sub template can be accessed.

The actual content of the sub template is pretty straight forward. It’s a series of paragraphs bounded by the ‘template’ command e.g.
```
<?template:para1?>
…
…
<?end template?>
<?template:para2?>
…
…
<?end template?>
<?template:para3?>
…
…
<?end template?>
```
Now we have the dynamic content defined it’s a case of conditionally bringing it into the main template. For this example I have demonstrated two approaches; both rely on the required paragraph information to be in the main dataset:
1. Using parameters to allow the user to select the appropriate paragraphs to be brought in. This means creating the parameters and ensuring that you have set the property on the data model to include the parameter values in the XML result set.

Once that’s done its just a simple case of using id statements to check if a given paragraph should be included:
```
<?if:.//PARA1='1'?><?call:para1?><?end if?>
```
This assumes my parameter is called PARA1 and that a ‘1’ means include it, it could easily be a ‘Y’ or ‘True’ value, you are just testing for it.

2. Including a value in the data to define what paragraphs should be included. If you have stored what paragraphs should be included for a given entity i.e. customer, supplier, employee, etc. Then you can extract those values into the data set and test for them. For this demo I have a 5 character set of ‘1’s and ‘0’s to represent the paragraphs that need to be included e.g. 10110. I just use a substring command to find out if a particular paragraph needs to be included.
```
<?if:substring(.//PARAS,1,1)='1'?><?call:para1?><?end if?>
```
Where PARAS is the element holding the ‘1’s and ‘0’s string to be parsed.
You can of course use some other means of marking whether a paragraph needs to be included or not. It’s just a case of parsing out the values with a substring or similar command.
You should be able to generate dynamic content such as this:

Notice that I have rendered the code so that I can see that the paragraphs are coming in i.e 10001 means we get paragraphs 1 and 5. I have built out demo files for the second method, available here.

2:29
ADF 11g – close popup with taskflow inside or complete taskflow inside popup
» ‎ AMIS Technology blog

Sometimes apparently complex things turn out to be very simple to achieve using ADF. And occasionally it is the other way round: things that seem to simple that you never gave it a second thought are in actual fact not so straightforward after all. One example of this is the situation when a taskflow is embedded [...]
1:29
Programmatic Navigation in WebCenter Portal application – do processAction from Java
» ‎ AMIS Technology blog

Working on a WebCenter 11g Portal application, I recently ran into a challenge: when the user clicks a link in a task flow, the result of that action should be that the user is navigated to another page with a another taskflow that should display content based on context defined through the specific link that [...]
0:40
Implementing Web Services backed by a Database PL/SQL API using the Oracle Service Bus
» ‎ AMIS Technology blog

This article accompanies an article on the Architecture section of Oracle Technology Network (OTN): Implementing the Enterprise Service Bus Pattern to Expose Database Backed Services. It provides a detailed description of the implementation of the ESB architecture design pattern – the same that is introduced in the article on OTN – using Oracle Service Bus. [...]
November 29, 2011
22:44
Respond to end of download in ADF 11g – using poll, clientListener and fileDownloadActionListener
» ‎ AMIS Technology blog

The situation: in an ADF Faces 11g page, we have a popup with two buttons: one to start a download and one to cancel the popup. When the users presses the download button, a fileDownloadActionListener is activated, the corresponding server side method is invoked to start producing the content to be downloaded and eventually the [...]
2:53
APEX: Make a report row clickable
» ‎ AMIS Technology blog

When you create a “Report with Form”, there will be an icon in the report which allows you to navigate to the form page. Only when the user clicks the icon this navigation will take place. For the current project, this was not what they wanted. They wanted to click on the row instead of [...]
November 28, 2011
13:19
SOA Suite 11g: set the Composite Instance title with a Mediator component
» ‎ AMIS Technology blog

In this blog I will describe how to set the composite title with a Mediator component. I will also describe where this approach matches and where it differs from setting the title with a BPM or BPEL component. Lets first start with an overall important match: you need the setCompositeInstanceTitle function. This function sets the [...]
13:13
SOA Suite 11g: set the Composite Instance title with a BPEL component
» ‎ AMIS Technology blog

In this blog I will describe how to set the composite title with a BPEL component. I will also describe where this approach matches and where it differs from setting the title with a BPM or Mediator component. Lets first start with an overall important match: you need the setCompositeInstanceTitle function. This function sets the [...]
13:07
SOA Suite 11g: set the Composite Instance title with a BPM component
» ‎ AMIS Technology blog

In this blog I will describe how to set the composite title with a BPM component. I will also describe where this approach matches and where it differs from setting the title with a BPEL or Mediator component. Lets first start with an overall important match: you need the setCompositeInstanceTitle function. This function sets the [...]
4:54
Synchronize ViewObject Queryies by dynamically linking bind parameters
» ‎ AMIS Technology blog

The functional requirement for my ADF application was fairly simple: the values used for the bind parameters in one ViewObject should be reflected for a second ViewObject. In more functional terms the requirement was the following: when we filter the master records – Employees – by begin year and end year (to only show employees [...]
November 21, 2011
6:43
UKOUG 2011: Using your Database as a Fileserver
» ‎ AMIS Technology blog

UKOUG 2011 is nearby and one of the coolest things in Oracle 11g and onwards is, IMHO, a functionality called XDB Repository Events. Most of you probably know that based on XMLDB functionality in the database, the database also can be used in a File server kind of way by enabling the XDB Repository HTTP/FTP [...]

November 18, 2011
15:13
UPDATE FOR BI PUBLISHER ENTERPRISE 10.1.3.4.2 NOVEMBER 2011
» ‎ Oracle BI Publisher Blog

It's Friday, that means its patch release time. Why do we do this to ourselves, 'we'll release on Friday!' It might 11.59 on Friday but by golly we'll have released on Friday. I can remember a release of BIP years ago that for some reason we went for 12/31 as a release date ... were we mad? I seem to remember we made it but talk about ridiculous pressure!

The latest 10g rollup is out in the wild and available from Oracle support. A bug fixing rollup but worth getting to and know that support will want you to get to it and re-test before going forward on an SR. One simple but very useful fix or enhancement:
[Cause of the bug]
@ ==================
@ Customer reports that despite the clock being shown, end users are clicking
@ on the View button repeatedly as the initial generation is taking some time.
@ If the button were to be grayed out then  this would prevent the users
@ requesting the report more than  once.  Repeated requests are causing a
@ system overload and as this is their Production  instance this is extremely
@ important to the customer.
@ .
@ [The Fix]
@ =========
@ Added the logic to disable the button after the user clicks on the "view"
@ button and re-enable it when the report is loaded.

I told a group of customers once that they have a headache and we have a non-steroidal anti-inflammatory drug, alright, I actually said 'aspirin'. This little gem of a fix helps relieve another little headache that our aspirin was causing. The patch number for all this BIP pain killing is 13399232, enjoy!

5:52
Oracle WebLogic 12c has been announced
» ‎ AMIS Technology blog

Yesterday I received the announcement of the new Oracle WebLogic 12c, on the 1st of December 2012. You can register for a webcast on https://event.on24.com/eventRegistration/EventLobbyServlet?target=registration.jsp&eventid=375727&sourcepage=register So, what’s there to be expected. Personally I think WebLogic has been made Exalogic ready, according to Mike Lehmann, Director of Product Management for Oracle WebLogic. Some of the few features I expect: More [...]
November 17, 2011
16:10
Timeouts in Oracle SOA Suite 11g
» ‎ AMIS Technology blog

Some time ago… at a Oracle SOA 11g project, we had to call an external webservice which took 1 to 5 minutes to respond. The composite calling this webservice was called by another composite from a BPEL process. As you might guess, we got an timeout resulting in faulted instances. Increasing the timeout time wasn’t as [...]
November 14, 2011
4:51
Publishing the Product Details WebService based on an Excel based Product Catalog using the SOA Suite 11g File Adapter with Synchronous File Read
» ‎ AMIS Technology blog

On the one hand: the organization wants to publish a real Web Service, SOAP enabled and all. On the other: the data to be provided by this Web Service is maintained in Excel files and undergoes regular changes by people who are well versed in Excel but absolutely blank when it comes to Web Services. This [...]
November 13, 2011
2:18
Book Review: Oracle WebCenter 11g PS3 Administration Cookbook by Yannick Ongena
» ‎ AMIS Technology blog

A few months back, in August, I received an electronic copy of the book: “Oracle WebCenter 11g PS3 Administration Cookbook” by Yannick Ongena (Packt Publishing, 2011). I promised you then you write a review on it and now I finally deliver on that promise. Main conclusion: if you want to get started with WebCenter 11g, this [...]
November 10, 2011
11:24
Review: The Method-R Profiler
» ‎ AMIS Technology blog

I was lucky enough to get my hands on the Method-R Profiler and had a test drive with it. So first of all what is it? As you might expect a profiler, a profiler for Oracle performance problems. The tool makes use of Oracle’s trace facilities. If you have a performance problem with the database [...]
5:56
Manage Agility through Manage-ability – Introducing Design Time at Run Time in Oracle Fusion Middleware
» ‎ AMIS Technology blog

Below is my presentation from the OGH DBA, SOA & BPM Day on November 8th. My talk was about achieving instant agility with application, through the ability to manipulate behavior and look & feel of applications at run time. And also to provide various flavors – parallel versions – of the application through customization. Oracle Fusion [...]
0:08
Some WebLogic Administration Essentialsbook reviews
» ‎ AMIS Technology blog

Some people were asked to review my book, here are some links: Edwin Biemond http://www.amazon.com/Oracle-Weblogic-Server-11gR1-Administration/dp/1849683026/ref=sr_1_5?ie=UTF8&qid=1320912495&sr=8-5 Jurgen Kress https://weblogiccommunity.wordpress.com/2011/11/09/oracle-weblogic-server-11gr1-ps2-administration-essentials-book-and-ebook Markus Eisele http://blog.eisele.net/2011/11/review-oracle-weblogic-server-11gr1-ps2.html Frank Muntz http://t.co/ukq1SUx6
November 03, 2011
0:18
Upcoming Seminar: DBA & SOA/BPM with latest OOW updates (8/11/2011)
» ‎ AMIS Technology blog

After the first successful DBA and SOA / BPM day OGH organizes this year a combined DBA – SOA / BPM day on Tuesday 8th of November 2011. The organization(with board member Jaime Conejo from AMIS) has chosen the theme of this edition to be ‘Manageabillity’, plus the latest information available from the Oracle OpenWorld. The subjects [...]
November 02, 2011
6:57
Solving connection problems using virtualBox:”SOA&BPM Development VM”
» ‎ AMIS Technology blog

A few weeks ago I had to work with a virtual box by oracle with a pre installed Database (xe) and weblogic to do some BPM Studio work. After the default installation I expected to just start the Virtual machine, start the weblogic server and enjoying the advantages of having everything installed properly… Not exactly because [...]
October 27, 2011
13:15
ADF: The best way to indicate for records in a table the existence of details – or: the importance of up-to-date SQL knowledge
» ‎ AMIS Technology blog

An interesting discussion arose in one of the projects I am involved in. The functional requirement at stake: show records in a table. In one of the columns, show an indicator (checkbox for example) that signals whether or not that particular record has a specific type of details associated with it. You could say that [...]

9:58
Time for a Timeout
» ‎ Oracle BI Publisher Blog
Couple of inquiries this week around the default timeout for BIP 11g installs and being able to change it. Its not currently documented (Leslie is working on that :) and when you see what you need to do you might understand why. It's ugly, very ugly but in the interest of getting the information out there, here we go.

The BIP session timeout is controlled in a section in the web.xml file under the WEB-INF directory.

<session-config>
<session-timeout>30</session-timeout>
</session-config>

The weblogic server (WLS) has a couple of features that are one, a pain and two useful. The first is the inability to update the web application's web.xml and have the changes take effect when you restart WLS. So far in my web diggings, I have found that you have to completely delete the application from WLS, update the web.xml and then re-deploy it with your new settings. Here's the steps:
1. Locate the xmlpserver.war under the MW home and back it up somewhere.
2. Log into the WLS console >> Deployments
3. Delete the BIPublisher entry. BIP is now gone from the server
4. Back to the war file. Unpack it, preserving directories
5. Go into the WEB-INF directory and edit the web.xml file and increase the timeout value and save the file. The setting is in the session-config section:
  
  <session-config>
  <session-timeout>60</session-timeout>
  </session-config>
6. Zip the war back up preserving the directories
7. Back in the console UI goto Deployments and 'Install' the BIP war file. Just accept all the defaults.
8. You can now log into the BIP application and the new timeout will be applied
It's messy I know but it works. Now, some of you may have found the page in the WLS console application that allows you to set a session timeout. Naturally, you'd think this would work if you changed it (that's the other feature of WLS that is useful.) The web.xml setting however, takes precedence over the WLS setting.
I have not tried this yet but I have been told that, if you remove the session-config section from the web.xml file and then redeploy BIP, the WLS setting will be respected. It's gotta be a better way to manage sessions. Just remember that until the development team either provide a better way to do it or remove the default time out in the web.xml file you are going to have to maintain your timeout method if you patch or upgrade.
9:58
Time for a Timeout
» ‎ Oracle BI Publisher Blog
Couple of inquiries this week around the default timeout for BIP 11g installs and being able to change it. Its not currently documented (Leslie is working on that :) and when you see what you need to do you might understand why. It's ugly, very ugly but in the interest of getting the information out there, here we go.

The BIP session timeout is controlled in a section in the web.xml file under the WEB-INF directory.

<session-config>
<session-timeout>30</session-timeout>
</session-config>

The weblogic server (WLS) has a couple of features that are one, a pain and two useful. The first is the inability to update the web application's web.xml and have the changes take effect when you restart WLS. So far in my web diggings, I have found that you have to completely delete the application from WLS, update the web.xml and then re-deploy it with your new settings. Here's the steps:
1. Locate the xmlpserver.war under the MW home and back it up somewhere.
2. Log into the WLS console >> Deployments
3. Delete the BIPublisher entry. BIP is now gone from the server
4. Back to the war file. Unpack it, preserving directories
5. Go into the WEB-INF directory and edit the web.xml file and increase the timeout value and save the file. The setting is in the session-config section:
  
  <session-config>
  <session-timeout>60</session-timeout>
  </session-config>
6. Zip the war back up preserving the directories
7. Back in the console UI goto Deployments and 'Install' the BIP war file. Just accept all the defaults.
8. You can now log into the BIP application and the new timeout will be applied
It's messy I know but it works. Now, some of you may have found the page in the WLS console application that allows you to set a session timeout. Naturally, you'd think this would work if you changed it (that's the other feature of WLS that is useful.) The web.xml setting however, takes precedence over the WLS setting.
I have not tried this yet but I have been told that, if you remove the session-config section from the web.xml file and then redeploy BIP, the WLS setting will be respected. It's gotta be a better way to manage sessions. Just remember that until the development team either provide a better way to do it or remove the default time out in the web.xml file you are going to have to maintain your timeout method if you patch or upgrade.

4:04
Oracle Tuxedo… A renewed acquaintance
» ‎ AMIS Technology blog

Years ago, when I worked as an Application Support Analyst for a big triple-A Bank, I got acquainted with the BEA product stack. One of those products was BEA Tuxedo, at that time at the release of 6. I worked at a settlements project, and Tuxedo was used for as distributed transaction processing, to process settlements [...]

October 26, 2011

Permalink for 'Oracle_BI_Publisher_Blog/2011/10/26/Tricky_Grouping_'

14:46

Tricky Grouping

» ‎ Oracle BI Publisher Blog

A week off trying to catch up with all the stuff that builds up was not enough but it was pretty fruitful. You clear the decks the week before you leave, you even answer a few mails in the first few days of vacation, until your manager slaps your wrists. But there is always a pile of work waiting when you get back. It was not too bad this time; I at least deleted the crap mail during the week via my phone.

How the heck did we survive without smart phones? I took a trip to north Denver last week to pick up a part for our bear ravaged pop up camper. I think he wanted a cold beer from the fridge just wish he'd used the front door rather than slicing the camper open. That gaping hole is meant to be covered!
I guess I could have checked a map before we left but my phone got us through the mess of roads up there. An 80 mile round trip for a $10 louvered cover! Still, we found a great Indian place for lunch, delicious curry!

Today's tidbit (titbit for my British brethren) is a bit tough to describe. It comes from Charlotte in New Zealand. On the surface it looks simple and it is when you know how :0) But there's a wrinkle in to smooth out.
Here's the data:

<DATA_DS>
 <G_1>
  <SERIALNUMBER>HSS0000156</SERIALNUMBER>
  <LOCATION>1 The Street Anytown USA</LOCATION>
   <ATTRIBDESC>Lettable Date</ATTRIBDESC>
  <ATTRIBVALUE>15/JUN/11</ATTRIBVALUE>
  </G_1>
 <G_1>
  <SERIALNUMBER>HSS0000156</SERIALNUMBER>
  <LOCATION>1 The Street Anytown USA</LOCATION>
   <ATTRIBDESC>Status Reason</ATTRIBDESC>
  <ATTRIBVALUE>Planned Major Repair/Upgrade</ATTRIBVALUE>
  </G_1>
 <G_1>
  <SERIALNUMBER>HSS0000276</SERIALNUMBER>
  <LOCATION>11 The Street Anytown USA</LOCATION>
   <ATTRIBDESC>Lettable Date</ATTRIBDESC>
  <ATTRIBVALUE>18/MAY/11</ATTRIBVALUE>
  </G_1>
 <G_1>
  <SERIALNUMBER>HSS0000276</SERIALNUMBER>
  <LOCATION>11 The Street Anytown USA</LOCATION>
   <ATTRIBDESC>Status Reason</ATTRIBDESC>
  <ATTRIBVALUE>Planned Major Repair/Upgrade</ATTRIBVALUE>
  </G_1>
 <G_1>
  <SERIALNUMBER>HSS0001046</SERIALNUMBER>
  <LOCATION>21 The Street Anytown USA</LOCATION>
   <ATTRIBDESC>Lettable Date</ATTRIBDESC>
  <ATTRIBVALUE>21/JUN/11</ATTRIBVALUE>
  </G_1>
 <G_1>

Heres the desired output:

Serialnumber	Status Reason	Date
HSS0000156	Planned Major Repair/Upgrade	15/JUN/11
HSS0000276	Planned Major Repair/Upgrade	18/MAY/11
HSS0001046	Planned Major Repair/Upgrade	21/JUN/11
HSS0001303	Planned Major Repair/Upgrade	19/MAY/11
HSS0001403	Planned Major Repair/Upgrade	14/JUN/11

Hok-Min, Zen Master of the RTF template, jumped on this for me and nailed it first time. On first look you think, ah this is just a simple re-group left, using some xpath to repeat the ATTRIBVALUE element twice in the table based on the ATTRIBDESC. Along the lines of:

<?ATTRIBVALUE[../ATTRIBDESC='Planned Major Repair/Upgrade']?> and <?ATTRIBVALUE[../ATTRIBDESC='Lettable Date']?>

But you oh so very easily end up with this:

Serialnumber	Status Reason	Date
HSS0000156		15/JUN/11
Planned Major Repair/Upgrade
HSS0000276		18/MAY/11
Planned Major Repair/Upgrade
HSS0001046		21/JUN/11
Planned Major Repair/Upgrade
HSS0001303		19/MAY/11
Planned Major Repair/Upgrade
HSS0001403		14/JUN/11
Planned Major Repair/Upgrade

and start scratching your head? With the 10.1.3.4.1 and 11g template builders there is a nice Group Left feature that removes the need for nasty nested tables but for this slightly corner case, it drops you into a world of misery. You need to take a step back from what the wizard has given you.

Yes, you need to group by serial number but you do not need to loop over the remaining data (current-group().) Rather, you just need to drop into that current-group() and bring the values you need up to the level of the serial number group. So you just need to modify your XPATHs thus:

<?current-group()/ATTRIBVALUE[../ATTRIBDESC='Status Reason']?>

i.e. provide a complete path to the element you want within the serial number re-group level. Neat!

Template and sample data available here.

14:46

Tricky Grouping

» ‎ Oracle BI Publisher Blog

<DATA_DS>
 <G_1>
  <SERIALNUMBER>HSS0000156</SERIALNUMBER>
  <LOCATION>1 The Street Anytown USA</LOCATION>
   <ATTRIBDESC>Lettable Date</ATTRIBDESC>
  <ATTRIBVALUE>15/JUN/11</ATTRIBVALUE>
  </G_1>
 <G_1>
  <SERIALNUMBER>HSS0000156</SERIALNUMBER>
  <LOCATION>1 The Street Anytown USA</LOCATION>
   <ATTRIBDESC>Status Reason</ATTRIBDESC>
  <ATTRIBVALUE>Planned Major Repair/Upgrade</ATTRIBVALUE>
  </G_1>
 <G_1>
  <SERIALNUMBER>HSS0000276</SERIALNUMBER>
  <LOCATION>11 The Street Anytown USA</LOCATION>
   <ATTRIBDESC>Lettable Date</ATTRIBDESC>
  <ATTRIBVALUE>18/MAY/11</ATTRIBVALUE>
  </G_1>
 <G_1>
  <SERIALNUMBER>HSS0000276</SERIALNUMBER>
  <LOCATION>11 The Street Anytown USA</LOCATION>
   <ATTRIBDESC>Status Reason</ATTRIBDESC>
  <ATTRIBVALUE>Planned Major Repair/Upgrade</ATTRIBVALUE>
  </G_1>
 <G_1>
  <SERIALNUMBER>HSS0001046</SERIALNUMBER>
  <LOCATION>21 The Street Anytown USA</LOCATION>
   <ATTRIBDESC>Lettable Date</ATTRIBDESC>
  <ATTRIBVALUE>21/JUN/11</ATTRIBVALUE>
  </G_1>
 <G_1>

Heres the desired output:

Serialnumber	Status Reason	Date
HSS0000156	Planned Major Repair/Upgrade	15/JUN/11
HSS0000276	Planned Major Repair/Upgrade	18/MAY/11
HSS0001046	Planned Major Repair/Upgrade	21/JUN/11
HSS0001303	Planned Major Repair/Upgrade	19/MAY/11
HSS0001403	Planned Major Repair/Upgrade	14/JUN/11

<?ATTRIBVALUE[../ATTRIBDESC='Planned Major Repair/Upgrade']?> and <?ATTRIBVALUE[../ATTRIBDESC='Lettable Date']?>

But you oh so very easily end up with this:

Serialnumber	Status Reason	Date
HSS0000156		15/JUN/11
Planned Major Repair/Upgrade
HSS0000276		18/MAY/11
Planned Major Repair/Upgrade
HSS0001046		21/JUN/11
Planned Major Repair/Upgrade
HSS0001303		19/MAY/11
Planned Major Repair/Upgrade
HSS0001403		14/JUN/11
Planned Major Repair/Upgrade

<?current-group()/ATTRIBVALUE[../ATTRIBDESC='Status Reason']?>

i.e. provide a complete path to the element you want within the serial number re-group level. Neat!

Template and sample data available here.

October 24, 2011
7:26
How to install feature pack 4 for the BPM suite
» ‎ AMIS Technology blog

For the BPM people (and other interested people): Oracle has released feature pack 4 of the oracle BPM suite. It contains lots of nice new features, but i found it difficult to install using the accompanying release notes. Luckily Niall Commiskey thought the same, found out how it should be done, and was kind enough [...]
6:52
ADF table filtering on MySQL is failing
» ‎ AMIS Technology blog

Table filtering, aka Query by example, is a great feature of ADF tables. This feature provides filterboxes on top of a column(es). and filters the data based on the values in the filterbox: This works like a charm on an Oracle database, but when you use MySQL the filtering doesn’t work and actually doesn’t retrieve any data [...]
3:49
SOA Suite File Adapter Pre and Post processing using Valves and Pipelines
» ‎ AMIS Technology blog

A quick note on the notion of valves and pipelines that can be configured in File (and FTP) Adapter Services and References (inbound and outbound) to perform file pre- and post processing on the files before they enter the composite application proper as XML or after they have left the composite application, turned from XML [...]

October 23, 2011
7:42
Personal Wireframe application that runs in the browser
» ‎ AppsBI : Applications Business Intelligence
Personal Wireframe application that runs in the browser
?MockupTiger Personal Edition? is an excellent way of doing wireframes in the browser without the heavy baggage of server or database.

Our Enterprise edition comes with complete user management system and uses MySQL database to maintain all the information. It also needs a webserver to operate.

MockupTiger Personal Edition is an extremely innovative way of delivering the same experience without the need of a webserver and a database system.

How is that possible?

Here is what we did
- Modern browsers such as Chrome come with their own database system and one such system is called as “localstorage“
- We singled out all the needed database objects that are needed to create projects and mockups
- We redesigned the system using only localstorage
- We kept the User Interface as it is.
- So now the entire MockupTiger application is bundled into a single HTML file. No need of a webserver or database system.
What are the benefits?
- Tiny footprint
- Just visit the URL and keep using it.
- Disconnected from internet? No problem. The application does not need it anymore. It is all within your browser.
- Every mockup or wireframe that you can build using Enterprise Edition is possible in the personal Edition
- Export to JSON and PNG
- Just onetime payment
Get MockupTiger license Mockuptiger Personal Edition

ShareThis
7:17
Wireframe software – new update Groups, full screen presentation
» ‎ AppsBI : Applications Business Intelligence

Wireframe software – new update Groups, full screen presentation Enterprise Class Group and project management features are now available with a single click to the Dashboard.
Download MockupTiger Wireframes. It is the best time saving application you will download for prototyping

Mockuptiger allows you to create any number of groups. Each member of your team can create their own groups. Groups is like the “Circles” feature in Google plus.
Groups can represent full company, it can represent individual small teams, it can represent individual clients of a web design agency or a small department of a big company
. It is a simple and very powerful concept. This power is available when you use Mockuptiger to build your wireframes and prototypes.

Groups is a very powerful and simple concept. If you are a web agency then every client and members working for them is part of a small group. ?ClientA group? and ?ClientB group?.

If you are a big organization then each small team can be a group ?Web design group?, ?Software Development Group? and so on.

A group is like an umbrella, you can add users to the group and users can share their projects to the group. So now every member of the group can see all the projects in the group. Project access is tightly controlled through the dashboard.

Each user can create groups
Each user can add members to its own groups
Each user in the group can share their own projects to the group
Each user who shares their project can control the Editor and viewership of their own content
Every user in the group can atleast view each and every project in the group
Not every user can edit the projects and pages in the group

You can now share your documents to public by simply providing the link.
Clickable wireframes allows for unique presentation ways of mockups to your clients

http://www.mockuptiger.com/wireframe/mockups/mt.php?pa=dashboard_sample_4e5bbfcf3d57f

See, how easy it is!

But wait, sharing the URL does not mean you lose control over it. You need to make the document public through the dashboard. And yes, once public you can always revoke the public access.

Read more about Group and project management for wireframe and prototyping

ShareThis

October 22, 2011
15:58
Some explorations around Java Stored Procedures in the Oracle Database
» ‎ AMIS Technology blog

While working on the challenge to publish a message to a JMS Queue in a remote WebLogic Server from within the Oracle Database – using a Java Stored Procedure – I came across a few things that I would like to record for future reference. Note that unfortunately I have not [yet?] succeeded in making [...]
October 19, 2011
6:48
ADF Faces: Handle task in background process and show real time progress indicator for asynchronous job using Server Push in ADF
» ‎ AMIS Technology blog

Recently I received an email from Peru. An ADF developer from Peru was facing a challenge with ADF. In short: ‘the upload of a (large) file should be followed by a potentially long running job. Ideally, the browser would not freeze while the uploaded file is processed and on top of that it would be [...]
2:13
Oracle Open World 2011 en JavaOne 2011 – een terugblik door AMIS-team
» ‎ AMIS Technology blog

Hier vind je twee uitgebreide artikelen met een verslag van Oracle Open World 2011 en van JavaOne 2011. Ook vind je in deze blog-post de slides van de ‘Report from Oracle Open World 2011′ sessie die op 17 oktober plaatshad bij AMIS in Nieuwegein. Je vindt ook nog enkele additionele resources en referenties. Artikelen Ons team heeft exclusief [...]
October 18, 2011
14:00
ADF 11g : Query Component with ‘dynamic’ view criteria
» ‎ AMIS Technology blog

In my current project use a lot of re usable taskflows. In one particular situation I needed exactly the same taskflow to be re-used with one tiny small difference: The displayed query component needed to have different fields compared to page in the base taskflow. Now there are lots of possible solutions (two query components [...]
8:16
Increase the timeout of Oracle BPM Worklist app
» ‎ AMIS Technology blog

The Oracle BPM Worklist app is a part of the Oracle SOA Suite. Working with the Worklist app is very annoying, because the default timeout is very short (seconds!). So after getting a cup of coffee or reading a mail you have to login again. Solving this problem seems quite easy by increasing the session timeout [...]
0:19
The year of the ADF developer @ Oracle Open World
» ‎ AMIS Technology blog

Open World made it clear: 2011 is the year of the ADF developer. Not only were there a lot of sessions about ADF, but also because ADF screens could be found in many sessions like the ones on the new Enterprise Manager 12c and on Oracle Fusion Applications. Not only were the number of sessions [...]
October 17, 2011
3:09
AMIS @ Heliview BPM Event 26 October 2011
» ‎ AMIS Technology blog

Many organizations are working to ensure consistency between internal processes to optimize efficiency and effectiveness smoothly. For many, the benefits of BPM are well known, but few know how to begin now. On October 26, 2011 AMIS Services will give a business presentation about BPM at the conference organized by BPM Heliview in Figi in Zeist. This year the event is particularly interesting. Because besides the phenomenon BPM there is a lot of attention for both the business approach as for the technology. AMIS will show how BPM works! Gain direct insight into current processes, modifying existing processes without IT! We [...]
October 14, 2011
9:51
Rman 11gR2 changes tag labeling of the inc backup in incrementally updated backups
» ‎ AMIS Technology blog

In (rman) incrementally updated backups, only incremental backups are done after the first full backup to the Fast Recovery Area. From 11gR2 on the incremental backup pieces will get the same tag as the datafile copies, and that’s actually different behaviour from pre- 11gR2 versions of the database. I stumbled on this different behaviour when a backup [...]
7:30
How to switch datafiles to FRA and back again
» ‎ AMIS Technology blog

If you, like me, like to use (rman) incrementally updated backups, a copy of all datafiles will be present in the Fast Recovery Area. That becomes quite handy if you are in sudden need of extra disk space for your database, and the FRA still has ample space left. By switching one or more datafiles [...]

October 13, 2011
10:22
Open World Presentations
» ‎ Oracle BI Publisher Blog

The dust has finally settled at the Moscone Center.

I hope everyone had a wonderful time at Open World.

For those of you who would like copies of the presentations we made, as promised, they are now available on the Publisher OTN page. Here are direct links:

Create All Your Reports More Easily and Quickly with Oracle Business Intelligence Publisher (14982)

Oracle Business Intelligence Publisher: The Reporting Platform for Oracle Applications (12426)

Become a Reporting Superstar with Oracle Business Intelligence Publisher Best Practices (16762)

Oracle Business Intelligence Publisher: Anatomy of an RTF Template (15010)

Still to come: Hands On Lab exercises and an updated RTF Template that goes along with Anatomy of a Template.
10:22
Open World Presentations
» ‎ Oracle BI Publisher Blog

The dust has finally settled at the Moscone Center.

I hope everyone had a wonderful time at Open World.

For those of you who would like copies of the presentations we made, as promised, they are now available on the Publisher OTN page. Here are direct links:

Create All Your Reports More Easily and Quickly with Oracle Business Intelligence Publisher (14982)

Oracle Business Intelligence Publisher: The Reporting Platform for Oracle Applications (12426)

Become a Reporting Superstar with Oracle Business Intelligence Publisher Best Practices (16762)

Oracle Business Intelligence Publisher: Anatomy of an RTF Template (15010)

Still to come: Hands On Lab exercises and an updated RTF Template that goes along with Anatomy of a Template.

October 12, 2011
23:00
2 dagen seminar door Steven Feuerstein: Best of Oracle PL/SQL (8 en 9 december)
» ‎ AMIS Technology blog

In dit tweedaagse seminar neemt Steven Feuerstein je mee ver voorbij de basismogelijkheden van PL/SQL. Steven zal tijdens dit seminar de best practices behandelen die hij op tientallen plekken in de wereld heeft verzameld en die hij ook mede door zijn nauwe samenwerking met het PL/SQL product team van Oracle kan verifiëren en aanscherpen. Hij [...]

Permalink for 'Oracle_BI_Publisher_Blog/2011/10/12/BIP_and_Mapviewer_Mash_Up_IV'

10:10

BIP and Mapviewer Mash Up IV

» ‎ Oracle BI Publisher Blog

Dang folks, we're on part four already, things start to get really groovy now.
If you're jumping in at part four, here are the previous episodes:

The current approach to get the maps into the output using encoded concatenated URL strings works but if you need to make changes to the map request call it gets fiddly and annoying quite quickly and if you need to drop another map into another output you'll need to embed the code into the second RTF template. What if we could simplify all of this and create a 'map request broker' that sat between the template and the map server? Even better if that broker could handle any map request and support as many layout templates that I want. I have just the solution built and ready to roll.

Of course all three components might be running on the same physical server inside the same weblogic domain. Its a pretty simple concept and it makes life so much easier when embedding a map into an output. The servlet is called from the RTF template using a URL that is constructed on the fly; we can also pass parameters on the URL to influence the map. For my example those parameters include the mapviewer server and port (to make the template portable) the map title, what needs to be mapped and the map request file to be used. The servlet receives the request grabs the parameters off the URL. It then reads the map request files and substitutes the appropriate variable values and then makes the call to mapviewer requesting a map. Once it receives the map it streams the image back to the template for rendering by BI Publisher. No messy encoded URL's minimal concatenation in the template to create the servlet URL and I have fine control over the map request. Best of all any template can call the same servlet, we just need the base map request on the server.

The Breakdown

There are three components to consider, what's in the RTF template the servlet code and the map request. Lets look at the map request first.

<?xml version="1.0" encoding="UTF-8"?>
<map_request title="param1" 
 basemap="world_map" 
 datasource = "obiee_navteq_sample" 
 width="640" 
 height="480" 
 bgcolor="#a6cae0" 
 antialiase="false" 
 format="param2">
 <center size="45">
  <geoFeature>
   <geometricProperty typeName="center">
    <Point srsName="SDO:8307">
     <coordinates>-96, 34</coordinates>
    </Point>
   </geometricProperty>
  </geoFeature>
 </center>
 <legend bgstyle="fill:#ffffff;stroke:#ff0000" 
         profile="MEDIUM" 
         position="SOUTH_WEST">
         <column>
          <entry text="Number of Renal Disease Cases:"/>
          <entry style="V.POPULATION_COUNTY" tab="1"/>
         </column>
 </legend>
 <themes>
  <theme name="theme1" min_scale="5.0E7" max_scale="0.0">
   <jdbc_query 
    datasource="obiee_navteq_sample" 
    jdbc_srid="8307" 
    spatial_column="geometry" 
    render_style="OBIEE_NAVTEQ:V.POPULATION_COUNTY">
    SELECT geometry, param3 
    from obiee_state 
    where iso_country_code='USA'</jdbc_query>
  </theme>
 </themes>
</map_request>

Its just a well formed XML file. This has loads going on and to find out more you're going to have to hit the books - the mapviewer documentation is here - check out the XML API section for some samples. I was playing with it last night and found that the 'size' attribute under the 'center' element controls the zoom level ... go figure. But combining that with the 'coordinates' value under geoFeature and some nifty LOVs in your BIP report and folks can move around a map and zoom in and out. More on that later.

Testing your map requests is simple enough inside the mapviewer web console http://server:port/mapviewer >> Requests. Just copy, paste and submit.

The other features of note are my parameters highlighted in blue. Before I pass this request on to the mapviewer server I do a search and replace on the 3 parameters. You'll see that in the servlet code. Remember, this XML is not hard coded into the servlet, its a separate XML file in a 'resource' directory that is read by the servlet. Taking this approach I can re-use the servlet for multiple map requests.

Next, the servlet code, ready for my awesome java skills? Read on ...

package oracle.bipmapper;

//Read-write libs
import java.io.BufferedInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
//Handle the URL call
import java.net.HttpURLConnection;
import java.net.URL;
import java.net.URLEncoder;
//Servlet libs
import javax.servlet.*;
import javax.servlet.http.*;


public class bipmap extends HttpServlet {
    private String CONTENT_TYPE = "";

    public void init(ServletConfig config) throws ServletException {
        super.init(config);
    }

    public void doGet(HttpServletRequest request,
                      HttpServletResponse response) throws ServletException,
                                                           IOException {

        doPost(request, response);
    }

    public void doPost(HttpServletRequest request,
                       HttpServletResponse response) throws ServletException,
                                                            IOException {

        ((1)) - Fetch the URL params. Check that we have values, if not, assign defaults.
        String measure1 =
            (request.getParameter("a1").toString() == "") ? "sqkm" :
            request.getParameter("a1");
        String server =
            (request.getParameter("serv").toString() == "") ? "75.101.156.237" :
            request.getParameter("serv");
        String port =
            (request.getParameter("port").toString() == "") ? "9704" :
            request.getParameter("port");
        String title =
            (request.getParameter("title").toString() == "") ? "Default Title" :
            request.getParameter("title");
        String format =
            (request.getParameter("format").toString() == "") ? "PNG_STREAM" :
            request.getParameter("format");
        String filename =
            (request.getParameter("file").toString() == "") ? "mapreq.xml" :
            request.getParameter("file") + ".xml";

        // Needed objects for the mapviewer call
        HttpURLConnection huc = null;
        URL mapAddress = null;
        ((2)) Set the content format based on the format parameter value
        // The else value is just text, thats for the SVG support
        if (format == "PNG_STREAM") {
            CONTENT_TYPE = "image/png";
        } else if (format == "JPG_STREAM") {
            CONTENT_TYPE = "image/jpg";
        } else {
            CONTENT_TYPE = "text/javascript";
        }

        response.setContentType(CONTENT_TYPE);

        ((3)) //Find the request file
        ServletContext context = request.getSession().getServletContext();
        String separator = System.getProperty("file.separator");
        final String TMPDIR =
            context.getAttribute("javax.servlet.context.tempdir").toString();
        // With WLS the tempdir drops you into the _WL_user/APP_NAME/RANDOM_DIR/public
        // we need the 'war' directory to find the resource directory
        String reqFile =
            TMPDIR.substring(0, TMPDIR.lastIndexOf(separator)) + "/war/resource/" +
            filename;

        ((4))// Construct the start of the URL map request
        String mapURL =
            "http://" + server + ":" + port + "/mapviewer/omserver?xml_request=";
        ((5)) // Load the XML request file
        String xmlReq = getMapReq(reqFile);
        ((6)) // Look for a replace the parameters in the XML request.
        xmlReq = xmlReq.replace("param1", title);
        xmlReq = xmlReq.replace("param2", format);
        xmlReq = xmlReq.replace("param3", measure1);

        InputStream is = null;

        ((7)) // Fetch the output stream from the mapviewer request
        try {
            mapAddress = new URL(mapURL + URLEncoder.encode(xmlReq));
            huc = (HttpURLConnection)mapAddress.openConnection();
            huc.setDoOutput(true);
            huc.setDoInput(true);
            huc.setUseCaches(false);
            huc.setRequestMethod("POST"); //Use HTTP POST method.
            is = huc.getInputStream();
            // Write the image stream back to the caller ie BIP in the template layer
            OutputStream out = response.getOutputStream();
            byte[] buf = new byte[1024];
            int len = 0;
            while ((len = is.read(buf)) >= 0) {
                out.write(buf, 0, len);
            }
            is.close();
            out.close();
        } catch (Exception e) {
            e.printStackTrace(System.err);
            System.exit(1);
        }
    }


    private static String getMapReq(String fname) throws java.io.IOException {
        ((5.5)) // Fetch the XML request file and load it into a string object
        byte[] buffer = new byte[(int)new File(fname).length()];
        BufferedInputStream f = null;
        try {
            f = new BufferedInputStream(new FileInputStream(fname));
            f.read(buffer);
        } finally {
            if (f != null)
                try {
                    f.close();
                } catch (IOException ignored) {
                }
        }
        return new String(buffer);
    }
}

I have highlighted the important bits:

(1) Standard stuff here, pulling the parameters off the URL and assigning them to string variables. For the un-initiated each entry is an inline if statement.

(2) Im checking the requested output so that I can set the appropriate content type. In my example Im supporting PNG, JPG and SVG. The SVG is handled in the else condition. More on that in another post.

(3) Here I fetch the request XML file. Its in a 'resource' directory in the deployment. This was a bit of a pain, I expected the 'javax.servlet.context.tempdir' to return he root of the web application but in weblogic you end up in a 'public' directory under the root. My resource directory is actually under the 'war' directory under the root so this piece of code:

ServletContext context = request.getSession().getServletContext();
String separator = System.getProperty("file.separator");
final String TMPDIR = context.getAttribute("javax.servlet.context.tempdir").toString();
String reqFile =
            TMPDIR.substring(0, TMPDIR.lastIndexOf(separator)) + "/war/resource/" +
            filename;

does some substringing and concatentation to build a path to the correct directory. Im sure there is an easier way but it works for now. Note the user of the 'separator' string so that the servlet can be deployed to windblows, unix or linux. I had a devil of a time catching that one. I developed on Linux but it would not run on windblows until I grabbed the appropriate separator ... grrr!

(4) Starting to construct the URL request for the XML map request

(5) Fetching the map request XML from the file in the resource directory

(5.5) This is the function to read the map request file and load it int a string variable

(6) A simple replace for each of the parameters created in the map request. We could have gotten fancier here with an XML parser but its not a huge string and there are three replacements to do. Its not a slow process.

(7) Now we construct the full http request for the map. Note the encoding of the xml request string, thats a must. Once we get the result we just have the servlet write it back to the response object for BIP to render.

Nothing earth shattering, could it be better, sure, if you fail to pass enough parameters you get an ugly null pointer exception which could be handled better but just make sure you pass enough parameters :0)

Finally the RTF template, its a case of declaring parameters for the report parameters and then building the URL request to the servlet. You can see the fields in the graphic on the right. The only ones of note are:

The file parameter, allows you to point to any deployed request file
The mURL that constructs the URL. Its just a big long concat with the name|value pairs for the servlet parameters.

Then just use the external-graphic place holder as we have before to reference the mURL parameter. The curly braces {} get BIP to pre-process the value before processing the graphic.

Finally ...

Thats it, put the three pieces together et voila, you have a mapping solution that's more manageable and configurable. You can of course increase the number of parameterized values in the xml map request.

I have bundled up the JDeveloper (11.1.1.5) project as it is ... its only really got the servlet and XML request in it. You can just copy and paste into your own project - get the project here. I have also zipped the 11g BIP report with the RTF template (Mapviewer4.rtf) get that here. For 10g'ers just unzip the xdoz file to get at the RTF template.

So, we can now get maps into our BIP outputs, the quality is pretty good but it could be better. Having spent some time digging around in the mapviewer docs I spotted that they support SVG outputs ... more on that next time.

10:10

BIP and Mapviewer Mash Up IV

» ‎ Oracle BI Publisher Blog

Dang folks, we're on part four already, things start to get really groovy now.
If you're jumping in at part four, here are the previous episodes:

The Breakdown

There are three components to consider, what's in the RTF template the servlet code and the map request. Lets look at the map request first.

<?xml version="1.0" encoding="UTF-8"?>
<map_request title="param1" 
 basemap="world_map" 
 datasource = "obiee_navteq_sample" 
 width="640" 
 height="480" 
 bgcolor="#a6cae0" 
 antialiase="false" 
 format="param2">
 <center size="45">
  <geoFeature>
   <geometricProperty typeName="center">
    <Point srsName="SDO:8307">
     <coordinates>-96, 34</coordinates>
    </Point>
   </geometricProperty>
  </geoFeature>
 </center>
 <legend bgstyle="fill:#ffffff;stroke:#ff0000" 
         profile="MEDIUM" 
         position="SOUTH_WEST">
         <column>
          <entry text="Number of Renal Disease Cases:"/>
          <entry style="V.POPULATION_COUNTY" tab="1"/>
         </column>
 </legend>
 <themes>
  <theme name="theme1" min_scale="5.0E7" max_scale="0.0">
   <jdbc_query 
    datasource="obiee_navteq_sample" 
    jdbc_srid="8307" 
    spatial_column="geometry" 
    render_style="OBIEE_NAVTEQ:V.POPULATION_COUNTY">
    SELECT geometry, param3 
    from obiee_state 
    where iso_country_code='USA'</jdbc_query>
  </theme>
 </themes>
</map_request>

Testing your map requests is simple enough inside the mapviewer web console http://server:port/mapviewer >> Requests. Just copy, paste and submit.

Next, the servlet code, ready for my awesome java skills? Read on ...

package oracle.bipmapper;

//Read-write libs
import java.io.BufferedInputStream;
import java.io.File;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.OutputStream;
//Handle the URL call
import java.net.HttpURLConnection;
import java.net.URL;
import java.net.URLEncoder;
//Servlet libs
import javax.servlet.*;
import javax.servlet.http.*;


public class bipmap extends HttpServlet {
    private String CONTENT_TYPE = "";

    public void init(ServletConfig config) throws ServletException {
        super.init(config);
    }

    public void doGet(HttpServletRequest request,
                      HttpServletResponse response) throws ServletException,
                                                           IOException {

        doPost(request, response);
    }

    public void doPost(HttpServletRequest request,
                       HttpServletResponse response) throws ServletException,
                                                            IOException {

        ((1)) - Fetch the URL params. Check that we have values, if not, assign defaults.
        String measure1 =
            (request.getParameter("a1").toString() == "") ? "sqkm" :
            request.getParameter("a1");
        String server =
            (request.getParameter("serv").toString() == "") ? "75.101.156.237" :
            request.getParameter("serv");
        String port =
            (request.getParameter("port").toString() == "") ? "9704" :
            request.getParameter("port");
        String title =
            (request.getParameter("title").toString() == "") ? "Default Title" :
            request.getParameter("title");
        String format =
            (request.getParameter("format").toString() == "") ? "PNG_STREAM" :
            request.getParameter("format");
        String filename =
            (request.getParameter("file").toString() == "") ? "mapreq.xml" :
            request.getParameter("file") + ".xml";

        // Needed objects for the mapviewer call
        HttpURLConnection huc = null;
        URL mapAddress = null;
        ((2)) Set the content format based on the format parameter value
        // The else value is just text, thats for the SVG support
        if (format == "PNG_STREAM") {
            CONTENT_TYPE = "image/png";
        } else if (format == "JPG_STREAM") {
            CONTENT_TYPE = "image/jpg";
        } else {
            CONTENT_TYPE = "text/javascript";
        }

        response.setContentType(CONTENT_TYPE);

        ((3)) //Find the request file
        ServletContext context = request.getSession().getServletContext();
        String separator = System.getProperty("file.separator");
        final String TMPDIR =
            context.getAttribute("javax.servlet.context.tempdir").toString();
        // With WLS the tempdir drops you into the _WL_user/APP_NAME/RANDOM_DIR/public
        // we need the 'war' directory to find the resource directory
        String reqFile =
            TMPDIR.substring(0, TMPDIR.lastIndexOf(separator)) + "/war/resource/" +
            filename;

        ((4))// Construct the start of the URL map request
        String mapURL =
            "http://" + server + ":" + port + "/mapviewer/omserver?xml_request=";
        ((5)) // Load the XML request file
        String xmlReq = getMapReq(reqFile);
        ((6)) // Look for a replace the parameters in the XML request.
        xmlReq = xmlReq.replace("param1", title);
        xmlReq = xmlReq.replace("param2", format);
        xmlReq = xmlReq.replace("param3", measure1);

        InputStream is = null;

        ((7)) // Fetch the output stream from the mapviewer request
        try {
            mapAddress = new URL(mapURL + URLEncoder.encode(xmlReq));
            huc = (HttpURLConnection)mapAddress.openConnection();
            huc.setDoOutput(true);
            huc.setDoInput(true);
            huc.setUseCaches(false);
            huc.setRequestMethod("POST"); //Use HTTP POST method.
            is = huc.getInputStream();
            // Write the image stream back to the caller ie BIP in the template layer
            OutputStream out = response.getOutputStream();
            byte[] buf = new byte[1024];
            int len = 0;
            while ((len = is.read(buf)) >= 0) {
                out.write(buf, 0, len);
            }
            is.close();
            out.close();
        } catch (Exception e) {
            e.printStackTrace(System.err);
            System.exit(1);
        }
    }


    private static String getMapReq(String fname) throws java.io.IOException {
        ((5.5)) // Fetch the XML request file and load it into a string object
        byte[] buffer = new byte[(int)new File(fname).length()];
        BufferedInputStream f = null;
        try {
            f = new BufferedInputStream(new FileInputStream(fname));
            f.read(buffer);
        } finally {
            if (f != null)
                try {
                    f.close();
                } catch (IOException ignored) {
                }
        }
        return new String(buffer);
    }
}

I have highlighted the important bits:

(1) Standard stuff here, pulling the parameters off the URL and assigning them to string variables. For the un-initiated each entry is an inline if statement.

ServletContext context = request.getSession().getServletContext();
String separator = System.getProperty("file.separator");
final String TMPDIR = context.getAttribute("javax.servlet.context.tempdir").toString();
String reqFile =
            TMPDIR.substring(0, TMPDIR.lastIndexOf(separator)) + "/war/resource/" +
            filename;

(4) Starting to construct the URL request for the XML map request

(5) Fetching the map request XML from the file in the resource directory

(5.5) This is the function to read the map request file and load it int a string variable

The file parameter, allows you to point to any deployed request file
The mURL that constructs the URL. Its just a big long concat with the name|value pairs for the servlet parameters.

Then just use the external-graphic place holder as we have before to reference the mURL parameter. The curly braces {} get BIP to pre-process the value before processing the graphic.

Finally ...

October 09, 2011
23:41
BIP and Mapviewer Mash Up III
» ‎ Oracle BI Publisher Blog
This is the third installment of the BIP and Mapviewer Mashup, for the previous entries:

BIP and Mapviewer Mash Up I

BIP and Mapviewer Mash Up II

BIP and Mapviewer Mash Up III

Its been a hectic couple of weeks which has included all things mapviewer and integration. I have finally got my piece de resistance in mapping integration working but more on that next time. Its very cool in a geeky BIP, kinda way; my wife was completely fascinated when I told her all about it over dinner last night. Either that, or she has become very adept at nodding and saying 'that's nice honeycakes' at appropriate times. I hope the former but suspect the latter :0(

The next part of this mashup series, I said we would parameterize the map call. That's actually pretty easy to do, just a bit more effort with the parameters and the concat functions.

1. Set up your parameters in the data model. These do not have to be tied to the query. We support 'template ' only parameters. they just all have to be defined in the datamodel. Note the name you give to the parameter(s)

2. In your RTF template you need to declare 'interest' in the parameters. Its the same as the CURRENT_SERVER_URL format.
```
<?param@begin:name;defaultvalue?>
```
3. In the fields where you are building the encoded request string you can use the concat function to drop the parameter values into the string. In this case we are changing th map title with a parameter called 'title'
```
 <xsl:param xdofo:ctx="begin" name="pMapRq">concat
("%3Cmap_request%20title%3D%22",$title,
"%20basemap%3D%22world_map%22%20datasource%20%3D%20%22
obiee_navteq_sample%22%20width%3D%22640%22%20height
%3D%22480%22%20bgcolor%3D%22%23a6cae0%22%20antialiase
%3D%22false%22%20format%3D%22JPG_STREAM%22%3E")
     </xsl:param>
```
Its not tough but boy is it a bit of a nightmare to manage and keep track of everything in that encoded URL.

As I mentioned in my last post its a good idea to maintain the parts of the URL as un-encoded text in the template surrounded by an 'if:1=2' if statement to keep it hidden at runtime.

Next post, we get to a much more robust, easier to manage and as I mentioned cooler solution ... enter the mapping servlet. It acts as a map request broker between the BIP template and the mapviewer server. The RTF template is not full of encoded URLs but just a simple URL call to the servlet that will call the mapviewer server and stream the image back to BIP for rendering. I have built in a couple of tricks but more on that next time.
23:41
BIP and Mapviewer Mash Up III
» ‎ Oracle BI Publisher Blog
This is the third installment of the BIP and Mapviewer Mashup, for the previous entries:

BIP and Mapviewer Mash Up I

BIP and Mapviewer Mash Up II

BIP and Mapviewer Mash Up III

Its been a hectic couple of weeks which has included all things mapviewer and integration. I have finally got my piece de resistance in mapping integration working but more on that next time. Its very cool in a geeky BIP, kinda way; my wife was completely fascinated when I told her all about it over dinner last night. Either that, or she has become very adept at nodding and saying 'that's nice honeycakes' at appropriate times. I hope the former but suspect the latter :0(

The next part of this mashup series, I said we would parameterize the map call. That's actually pretty easy to do, just a bit more effort with the parameters and the concat functions.

1. Set up your parameters in the data model. These do not have to be tied to the query. We support 'template ' only parameters. they just all have to be defined in the datamodel. Note the name you give to the parameter(s)

2. In your RTF template you need to declare 'interest' in the parameters. Its the same as the CURRENT_SERVER_URL format.
```
<?param@begin:name;defaultvalue?>
```
3. In the fields where you are building the encoded request string you can use the concat function to drop the parameter values into the string. In this case we are changing th map title with a parameter called 'title'
```
 <xsl:param xdofo:ctx="begin" name="pMapRq">concat
("%3Cmap_request%20title%3D%22",$title,
"%20basemap%3D%22world_map%22%20datasource%20%3D%20%22
obiee_navteq_sample%22%20width%3D%22640%22%20height
%3D%22480%22%20bgcolor%3D%22%23a6cae0%22%20antialiase
%3D%22false%22%20format%3D%22JPG_STREAM%22%3E")
     </xsl:param>
```
Its not tough but boy is it a bit of a nightmare to manage and keep track of everything in that encoded URL.

As I mentioned in my last post its a good idea to maintain the parts of the URL as un-encoded text in the template surrounded by an 'if:1=2' if statement to keep it hidden at runtime.

Next post, we get to a much more robust, easier to manage and as I mentioned cooler solution ... enter the mapping servlet. It acts as a map request broker between the BIP template and the mapviewer server. The RTF template is not full of encoded URLs but just a simple URL call to the servlet that will call the mapviewer server and stream the image back to BIP for rendering. I have built in a couple of tricks but more on that next time.

7:51
OGh bijeenkomst 4 oktober
» ‎ AMIS Technology blog

Afgelopen dinsdag 4 oktober waren Andre van Winssen en ik de aangewezen personen om een presentatie bij de OGh te verzorgen. Andre vertelde in ongeveer een uur het een en ander over Application Contexts en het gebruik van DBMS Crypto. Een deel uit de masterclass die hij bij AMIS verzorgt. Ik hield mijn presentatie over [...]
October 07, 2011
6:28
SOA Suite 11g – Event Delivery Network – How to correlate one event into multiple instances of the same composite (BPEL or BPM)?
» ‎ AMIS Technology blog

The use case is very straightforward: we have a SOA & BPM Composite Application for the Order process. Whenever a customer places an order, a new instance of this process kicks off. At any one time we will potentially have multiple instances for orders from the same customer. These instances are uniquely identified by the [...]
6:03
(Slides for) Instant Agility in Oracle Fusion Middleware through Design Time @ Run Time (Oracle Open World 2011)
» ‎ AMIS Technology blog

Agility is about ability to adapt. Enterprises need to quickly respond to changing circumstances and requirements. Agility is a state of mind (“embrace change”) that must be supported by process and technology. This session will demonstrate how Fusion Middleware provides a substantial dose of instant agility through its design time @ run time facilities. Application [...]

← Oracle ReadBlog →

Zmrss Reader » OracleERP

Feeds

OracleERP (100 unread)