BPM 10g-12c Migration: Handling Excel Files as Input by Mark Foster

January 22, 2015 Leave a comment

clip_image002Introduction

With the introduction of BPM 12c comes the long-awaited migration tool to migrate BPM 10g projects to BPM 12c.

The A-Team have been heavily involved with the effort to create collateral around this tool – patterns, approaches, samples, tutorials, labs etc.

One of the common patterns in BPM 10g is using an Excel spreadsheet as input to a process which led me to investigate how this could be replicated in 12c. What follows is a step-by-step guide to achieving an example of this. Note that this blog will not deliver an enterprise production solution but will at least provide a working example which can be built upon as required.

Approach

Handling files in SOA Suite 11g & 12c is standard functionality with the file and ftp adapters… so we’ll use the file adapter for this example.

Handling CSV files is also straightforward, they can be specified as input in the file adapter wizard… so we can use a CSV file as input to the process.

Apache POI is a standard open source approach to converting Excel to a.n.other file format…. so we can use this to convert the Excel to CSV.

The file adapter and FTP adapter in 12c (and 11g) provide a feature known as “pipelines and valves” for pre-processing (and post-processing) of files prior to delivery to the composite…. so we can use this as the point of conversion for our file.

Given we now know the approach we can begin to build the example….

The Example Project

Examine the Input Spreadsheet / CSV File

We’ll be using a simple excel spreadsheet of orders….

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

Filed under BPM Tagged with , , , , , , ,

ACM Implementation Best Practices at Fusion Middleware Partner Community Forum 2015

January 22, 2015 Leave a comment

The Fusion Middleware Partner Community Forum takes place March 3rd & 4th in Budapest Hungary. During this annual conference You as an Oracle Partner can get the latest updates on the Fusion Middleware 12c solutions. “The Cloud Platform for Digital Business” will be the theme of the 20th conference. Keynotes will be delivered from Amit Zavery, Andrew Sutherland and SOA, BPM and Mobile product management including live demos. On the second day you can choose between three tracks: SOA, BPM or WebLogic and Mobile. As part of the BPM track Danilo Schmiedel and Andrejus Baranovskis will present:

ACM Implementation Best Practices

With Oracle BPM Suite the modeling, simulation, implementation and execution of business processes in a multi-user environment is straightforward. But how about unstructured, ad-hoc processes which are too complex and too flexible to put them into a rigid BPMN model? Think about a claim notification after a car accident – it is very difficult to model each potential option of it and a lot of effort and time is necessary to bring all varieties into the process. Think about the user interface – it has to be very dynamic in order to make optimal business decisions. If you have similar challenges this session is made for you! The speakers will provide an excellent view on implementing knowledge-intensive processes from multiple ADF & BPM projects around globe.

Danilo Schmiedel

clip_image002[4]

OPITZ CONSULTING GmbH

Solution Architect

Oracle ACE Director

Blog

Twitter

LinkedIn

Andrejus Baranovskis

clip_image002

Red Samurai Consulting

Technical Expert

Oracle ACE Director

Oracle Blog

Twitter

LinkedIn

 

For details please visit our Fusion Middleware Partner Community Forum registration page 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

Filed under Community Tagged with , , , , , , , , , ,

Critical Patch Update Advisory includes SOA Suite & BPM Suite – January 2015

January 21, 2015 1 Comment

Oracle Critical Patch Update Advisory – January 2015

A Critical Patch Update (CPU) is a collection of patches for multiple security vulnerabilities. Critical Patch Update patches are usually cumulative, but each advisory describes only the security fixes added since the previous Critical Patch Update advisory. Thus, prior Critical Patch Update advisories should be reviewed for information regarding earlier published security fixes. Please refer to: Critical Patch Updates and Security Alerts for information about Oracle Security Advisories.

Affected Products and Versions include the following Fusion Middleware solutions:

Oracle Fusion Middleware, version(s) 10.1.3.5, 11.1.1.7, 11.1.2.1, 11.1.2.2, 12.1.2, 12.1.3
Oracle Access Manager, version(s) 11.1.1.5, 11.1.1.7, 11.1.2.1, 11.1.2.2
Oracle Adaptive Access Manager, version(s) 11.1.1.5, 11.1.1.7, 11.1.2.1, 11.1.2.2
Oracle BI Publisher, version(s) 10.1.3.4.2, 11.1.1.7
Oracle Business Intelligence Enterprise Edition, version(s) 10.1.3.4.2, 11.1.1.7
Oracle Containers for J2EE, version(s) 10.1.3.5
Oracle Directory Server Enterprise Edition, version(s) 7.0, 11.1.1.7
Oracle Exalogic Infrastructure, version(s) 2.0.6.2.0 (for all X2-2, X3-2, X4-2)
Oracle Forms, version(s) 11.1.1.7, 11.1.2.1, 11.1.2.2
Oracle GlassFish Server, version(s) 3.0.1, 3.1.2
Oracle HTTP Server, version(s) 10.1.3.5.0, 11.1.1.7.0, 12.1.2.0, 12.1.3.0
Oracle OpenSSO, version(s) 8.0 Update 2 Patch 5
Oracle Real-Time Decision Server, version(s) 11.1.1.7, RTD Platform 3.0.x
Oracle Reports Developer, version(s) 11.1.1.7, 11.1.2.2
Oracle SOA Suite, version(s) 11.1.1.7, 12.1.3.0
Oracle Waveset, version(s) 8.1.1
Oracle WebCenter Content, version(s) 11.1.1.8.0
Oracle WebLogic Portal, version(s) 10.0.1.0, 10.2.1.0, 10.3.6.0
Oracle WebLogic Server, version(s) 10.0.2.0, 10.3.6.0, 12.1.1.0, 12.1.2.0, 12.1.3.0

For more information please visit the OTN here.

Note: Patch 20333237  is currently only limited available, please contact myself if you need to get access.

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

Filed under BPM, SOA Tagged with , , , , , , ,

Comprehensive Event Processing & Stream Explorer at Fusion Middleware Partner Community Forum 2015

January 21, 2015 Leave a comment

The Fusion Middleware Partner Community Forum takes place March 3rd & 4th in Budapest Hungary. During this annual conference You as an Oracle Partner can get the latest updates on the Fusion Middleware 12c solutions. “The Cloud Platform for Digital Business” will be the theme of the 20th conference. Keynotes will be delivered from Amit Zavery, Andrew Sutherland and SOA, BPM and Mobile product management including live demos. On the second day you can choose between three tracks: SOA, BPM or WebLogic and Mobile. As part of the SOA track Marcel Amende will present:

Comprehensive Event Processing & Stream Explorer

Oracle Event Processing (OEP) is a key component in modern and comprehensive data processing. The presentation will explain usage scenarios of OEP in the context of Fast Data, Big Data, Analytics and Embedded. An introduction to the brand new Stream Explorer, a business friendly user interface for OEP, will be a major topic. Two demonstrations, will roundup the presentations: The first will demonstrate the processing of sensor data in a full round-trip, the second demo concentrates on embedded event processing in a logistics scenario.

Marcel Amende

clip_image002[9]

Oracle Germany

Senior Leitender Systemberater

Blog: http://a-men-de.blogspot.co.uk/

Twitter: https://twitter.com/a_men_de

LinkedIn: de.linkedin.com/pub/marcel-amende/1/abb/890

 

For details please visit our Fusion Middleware Partner Community Forum registration page 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

Filed under Community Tagged with , , , , , , , , ,

IoT and the Modern Value Chain by Gaurav Palta and John Murphy

January 21, 2015 Leave a comment

By implementing modern best practices and architecting a digital, IoT-driven supply chain, organizations will be able to realize a number of benefits.

Today’s modern consumers expect faster and more flexible fulfillment options that provide full visibility into product information, availability, and lead times. With billions of networked devices—from cell phones and laptops to equipment sensors and wearable technology—the opportunities for significant innovation are vast. But so are the possibilities for exposure to risk and inefficiencies. The business battleground is moving, and the value chain is at the forefront of success or failure.

clip_image001

Now, fast forward to 2020, there are 25-plus billion Internet of Things (IoT) devices and a “networked” economy approaching US$2 trillion. According to Bryan Tantzen, senior director of IoT at Cisco, “We have now crossed the chasm and people are waking up to the value at stake. Supply chain managers in particular are leveraging IoT to create a real-time supply chain where line operators take digital orders and integrate them immediately into production runs.”

To take advantage of the increasing deluge of data, commonly referred to as big data, businesses are replacing traditional methods with modern best practices. These practices are more focused on customers, enable faster and more responsive supply networks, inspire more profitable product innovation, and facilitate a more collaborative environment of empowered supply chain professionals.

By implementing modern best practices and architecting a digital, IoT-driven supply chain, organizations will be able to realize a number of benefits:

The business battleground is moving, and the value chain is at the forefront of success or
failure.

Increase focus on customers

As consumer-level information is captured by machine-to-machine communications, businesses can immediately analyze the data in multiple ways to create faster, more reliable, and more accurate forecasts so inventory and production levels are optimized. For example, in the not-so-distant future, sensors will be added to consumable items such as a gallon of milk. Milk producers will go beyond the shelves at retail outlets and into the homes of consumers to determine, in the short term, levels of consumption and, in the long term, patterns of consumption for individuals so they can better manage their supply chains and predict future demand and supply their retailers more efficiently. This level of detail was never before available. 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

Filed under SOA Tagged with , , , , , ,

BPM Suite 12c Launch Webcast available on-demand

January 21, 2015 Leave a comment

clip_image002

Business processes are at the heart of what makes or breaks a business—and what differentiates it from the competition. Oracle’s Business Process Management Suite that deliver operational efficiency, business visibility, excellent customer experience, and agility give the enterprise an edge over the competition.
To continue your journey with Oracle and learn more about how Oracle can help you deliver on Intelligent Process Management and build Mobile Enterprise Applications please leverage these additional Oracle resources as a thank you:

· Download Presentation

Join the On-Demand Webcast 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

Filed under BPM Tagged with , , , , , ,

WS-BPEL 2.0 Beginner’s Guide by Matjaz B. Juric & Denis Weerasiri

January 20, 2015 Leave a comment

clip_image002
Design and develop WS-BPEL executable business processes using Oracle SOA Suite 12c

About This Book

  • Develop BPEL and SOA composite solutions with Oracle SOA Suite 12c and JDeveloper 12c
  • Understand Human interaction in BPEL and learn how to add human tasks to a BPEL processes
  • Automate business processes with WS-BPEL 2.0
  • Implement and develop compensation and compensation handlers in BPEL processes

Who This Book Is For

If you are a software architect, a designer, a software developer, an SOA and BPM architect, a project manager, or a business process analyst who is responsible for the design and development of business processes, composite applications, and BPM/SOA solutions, then this book is for you. You should have a clear grasp of general SOA concepts including business processes and web services, but no prior knowledge of the BPEL language is required.

Authors

Matjaz B. Juric

Matjaz B. Juric holds a PhD in Computer and Information Science. He is a full-time professor at the University of Ljubljana and the Head of the Cloud Computing and SOA Competency Centre (www.soa.si). Matjaz is an Oracle ACE Director, a Java Champion, and an IBM Champion. He has more than 20 years of work experience. He has authored/coauthored Do More with SOA Integration, WS-BPEL 2.0 for SOA Composite Applications, Oracle Fusion Middleware Patterns, Business Process Driven SOA using BPMN and BPEL, Business Process Execution Language for Web Services (English and French editions), BPEL Cookbook: Best Practices for SOA-based integration and composite applications development(awarded the best SOA book in 2007 by SOA World Journal), SOA Approach to Integration, all by Packt Publishing.

Denis Weerasiri

Denis Weerasiri is a Computer Science and Engineering student, pursuing his PhD at the University of New South Wales. Before this, he worked as a senior software engineer for WSO2, an open source SOA company. He obtained his BSc Engineering degree with first class honors in the year 2010 from the Department of Computer Science and Engineering, University of Moratuwa, Sri Lanka. His research interests are distributed systems, cloud resource configuration management, and business process management.

What You Will Learn

  • Design and develop BPEL 2.0 executable business processes
  • Become familiar with BPEL 2.0 activities and the most important usage scenarios
  • Learn how to invoke and orchestrate services, manipulate data and use variables
  • Implement conditions and loops, and recognize fault-handling capabilities to avoid unexpected states
  • Understand message exchange patterns and learn about asynchronous communication channels and dynamic parallel invocations
  • Learn about human interactions, human tasks, events and event handling, and compensations

For additional SOA Books please visit our wiki & 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

Filed under SOA Tagged with , , , , , , ,

2 Minute Tech Tip: Tools for SOA Governance and API Management by Luis Weir

January 20, 2015 Leave a comment

clip_image002

Watch the video 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

Filed under SOA Tagged with , , , , , , ,

Smart Combo – Cloud Integration Webcast January 26th 2015

January 19, 2015 Leave a comment

clip_image002

Cloud Integration – Unified and Comprehensive Cloud and On-premise Integration Discover the Value for Partners

Simplify cloud integration with a unified and comprehensive solution to integrate disparate cloud and on-premise applications. Oracle cloud integration leverages Oracle Cloud services as well as components from Oracle’s SOA, BPM, and data integration technologies.

Speakers will be:
– Olivier Tordo, Channel Sales – Senior Director
– Richard Lefebvre, Director CRM Partner Programs EMEA
– Christian Patrascu, Director of Product Management – Oracle
– Yogesh Sontakke, Principal Product Manager

Details and registration: » 26 January – 2 PM CET (1 hour)

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

Filed under Cloud, SOA Tagged with , , , , , , ,

Cloud Adapter for Salesforce.com – Understanding What It Does & How You Benefit by ITC

January 19, 2015 1 Comment

Starting in the 1990’s it became standard operating procedure in all large and even mid-sized companies to use an ERP system  such as Oracle E-Business Suite to manage business processes like Order Management, Accounting System or Supply Chain Management, along with the complete sales and revenue cycle from quote-to-order and order-to-cash.

clip_image002However, as recently as only a half-decade ago, those same companies either ran CRM systems completely independently of those ERP solutions or they scarified high quality CRM functionally for a CRM alternative that was “good enough”  but integrated easily with Oracle.
However, this began to change at the beginning of the second decade of the 21st century, as companies began dropping their legacy systems and opting to move to SaaS-based CRM solutions such as SalesForce.com.  The attraction of solutions such as Salesforce.com is twofold: first, they offer best of breed functionality; second, the SaaS model makes them very attractive from a total cost of ownership perspective. 
However,  the downside that Oracle users face when they adopted a SaaS solution such as SalesForce.com was that it didn’t integrate with Oracle E-Business Suite. And this creates problems such as data silos, data scattering, data quality issues and other major inefficiencies related to business process execution. Maintaining your data also becomes a challenge, as data captured across your system must be duplicated to SalesForce.
To overcome these issues and take full advantage of Oracle EBS and SalesForce.com organizations need to achieve a seamless information flow between the two: they need to integrate them. This much has long been obvious. 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

Filed under Cloud, SOA Tagged with , , , , , , , ,

← Older posts

Newer posts →