OSB Patching by Jon Petter

 

We have some customers which only use OSB – and not SOA Suite. When you want to patch – should you look only at WLS and OSB-patches? The answer is no.

One such reason is documented on MOS: Should the SOA Bundle Patches for 11g and 12c be applied to OSB (Doc ID 2102449.1). It states: In 12c, since OSB services can use JCA technology adapters, there is value in applying the SOA Bundle Patches where fixes to these adapters are included.

The other reason is because JDeveloper has common features in the two products. For example SOA patch 22226040: java.lang.NullPointer for XQuery File ver 1.0 in JDEV 12.2.1 OSB Proj – is one you would like to use for OSB on 12.2.1. The problem is shown in our blog post: OSB Patch. If the patch does not work – remember to do the cleanup-steps mentioned at the end of the blog.

My advise is to create a predefined Patch Search in MOD so you can monitor existing patches. Here are some of my searches.

clip_image002

One good thing you can see is the last time you searched. For example for OSB – then WLS, SOA and OSB are relevant. My advise is to order patches so you see the latest updates first, and that you at least should add the recommended patches. Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Patching JDeveloper 12.1.3 for OSB and SOA by Jon Petter Hjulstad Keeping your JDeveloper SOA/OSB Quickstart environment up to date

clip_image002

 

Oracle released new patches some weeks ago, and to keep your JDeveloper updated for SOA Suite and Oracle Service Bus there are three products you should patch:

  • Oracle SOA Suite
  • Oracle Service Bus
  • Weblogic

When you search My Oracle Support (MOS) for patches – you can see which ones are the recommended ones. There are also notes in MOS which are updated regularly:

  • OSB 11g and 12c: Bundle Patch Reference (Doc ID 1499170.1)
  • SOA 11g and 12c: Bundle Patch Reference (Doc ID 1485949.1)
  • Master Note on WebLogic Server Patch Set Updates (PSUs) (Doc ID 1470197.1)

In the environment I used for this example. Patch 19707784: SOA Bundle Patch 12.1.3.0.1 was applied before. This will be detected by OPatch, and that patch will be rolled back.

The patching is simplified in the 12c-version, because now there is only one OPatch-folder to care about (in version 11 there were one per product). You can read more about it here: Oracle Documentation link

For each patch there is a README.txt, whick you should read. It contains Pre-Installation Instructions, Install and Post-Instructions. For the SOA-patch, you should look through the steps for the Post-steps

I use Windows environment in this example, so I set the environment variables first (run as Administrator): Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Why does DB-adapter return duplicate rows? by Jon Petter Hjulstad

 

clip_image002Here are some DB adapter tips regarding duplicate rows.

The DB Adapter has some nice features, but sometimes you can get fooled. One of my colleagues experiences this one day. The query returned the same row – just repeated many times.

The reason for this is because the primary key was not defined correctly.

The good thing is that the documentation describes this – and more: Oracle documentation

For tables where primary key is defined – this should not be a problem, but in cases where it is not defined or you are querying a view – you would need to specify a primary key yourself. A couple of relevant notes here:

  • If you do not provide a valid primary key, then the unique constraint is not guaranteed, and this could result in possible loss of messages at runtime. That is, rows with duplicate primary key values are likely to be lost.
  • You should ensure that you primary key is less than 100 bytes.
  • Oracle recommends that you use varchar instead of char for primary key columns

Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

Book review: Oracle BPM Suite 12c Modeling Patterns by Jon Petter Hjulstad

 

clip_image002This is a book review on the book “Oracle BPM Suite 12c Modeling Patterns” written by Vivek Acharya – on PACKT. For more information visit this link.

This is the first book on Oracle BPM 12c and is a good resource for those who want to get more familiar with how different patterns can be modeled in Oracle BPM.

It is not a book for beginners – or those that want to know more about BPM – this is more for those of us that are already convinced.

Book Details:

ISBN 139781849689021

Paperback  454 pages

This is a book that is more on the advanced side – and BPMN modeling is not always easy. This book gives some examples on how you can solve different process scenarios. Therefore the author limits the scope – and I think that is a good choice:

  • This book is designed to provide information on BPMN Modeling Patterns only
  • This book does not contain all the information available on the subject.
  • The primary focus is to showcase BPM patterns which are generic and can be read by anyone allied with any BPM offering.

Read the complete article here. For additional BPM books please visit our wiki here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

EBS 12c Adapter calling PL/SQL by Jon Petter Hjulstad

clip_image002I have used the EBS Adapter on version 12 – and encountered some problems. The EBS Adapter is for example packaged into Mobile Suite with OSB and is perfect for example mobile-enabling you EBS. Here is some more info: Youtube  or datasheet. The problem I encountered was during call to a PL/SQL API in EBS Adapter. It looked like this:

What should be expected here is that it call a wrapper package that is generated in the APPS schema, but it calls the original package. Here is a link to the documentation

and the WSDL anticipates that the boolean is now an int, but it calls the wrong package. This can also be verified by logging SQL by using this tip. So to fix this you must update the file myAppsReference_apps.jca manually: Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

What’s new in Oracle Event Processing 12c? by Jon Petter Hjulstad

Oracle Event Processing is not the most frequently used tool in the Oracle SOA Suite, but more and more people now know about it. With some of the new features in BAM 12c many people will probably use it, without knowing that it is actually OEP behind there. OEP has allways been open and easy to adapt to your needs, but with this version it will be easier to show value fast. My personal favorite in this version is the REST adapter.
For those of you interested in OEP – the following document describes What’s New in OEP 12c. This is the type of document that I think is really useful for us when a new release is available. The SOA whitepaper on 12c is also excellent. Here is some of the improvements:

  • Quick start installation – like you now know from SOA/BPM
  • JDeveloper instead of Eclipse – better integrated with EDN
  • Better Coherence integration – support for compound keys and indexes
  • Improved CQL Engine – for instance sub-queries
  • Improved Spatial capabilities – for instance geo-fencing 3D volumes, such as buildings, mountains
  • Quick Development and testing
  • New event node adapters – QuickFix, REST Adapter, Distribution Adapter for out-of-process OEP application integration, CSV Adapter

Combination of Fast Data and Big Data is very interesting (and well supported in OEP), and that in combination with embedded OEP on small devices is something I think we will se a lot of in the coming years. Read the complete article here.

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2] Facebook clip_image002[8][4][2][2][2] Wiki

BPM 11g PS6 brings us closer to the power of BPM! Jon Petter Hjulstad, e-vita as

imageBPM PS6 brings us closer to the power of BPM! One of the focus areas in this release is making it simpler for business people to draw the process, design input forms, test the process out in Process Player, to do simulations – all in a web interface. All this will give IT a better base for further refinement – the result will be fewer iterations before the process is ready to deploy. The other thing I am looking forward to is OEP PS6 – The NoSQL-integration will be very useful! Jon Petter Hjulstad, e-vita as

clip_image001Blog clip_image002Twitter clip_image003LinkedIn

Read all first impressions from our BPM experts here & Download BPM PS6 here

Which partner to choose for your BPM Implementation?

You are looking for an partner who has successfully implemented BPM Suite 11g? Who has trained and certified experts? Make sure you choose an “Oracle Unified BPM Suite 11g Specialized Partner”! Oracle BPM Suite 11g Specialized partners who implemented BPM Suite 11g successfully and trained and certified their consultants. You can find your local Specialized partner at http://www.solutions.oracle.com/

SOA & BPM Partner Community

For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.

Blog Twitter LinkedIn image[7][2][2][2][2][2][2][2] Facebook clip_image002[8][4][2][2][2][2][2][2][2] Wiki Mix Forum