Monday Dec 21, 2015

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

Sunday Feb 15, 2015

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

Friday Feb 13, 2015

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

Monday Sep 22, 2014

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

Tuesday Apr 16, 2013

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

About





Search

Archives
« April 2016
SunMonTueWedThuFriSat
     
1
30
       
Today