Connect and consume data assets with OSB12c and WebCenter Sites 11g using the REST api

In one of the project I've worked on, I configured an automatic creation/update and delete of assets in WebCenter Sites 11g using its REST api via OSB.

The configuration is a bit tricky so I want to share the solution.

I am not giving the details step by step of how this can be implemented as I am sharing the code, btw I'll explain the main important concept.

What it is needed for this tip:

• JDeveloper 12.1.3 (SOA Quick start version)
• An account with read/write right permission in a WebCenter Sites server
• The AssetType created in Sites

OSB Services Implemented

The Pipeline in the project contains the below services:

XSLT Name	WCSites Component used	Relative URI	HTTP Operation
getTicket	Authorization	cas/v1/tickets	GET
getCourseIdByCode	Custom Asset Course	<SITE NAME>/types/<ASSET NAME>/search	GET
getSessionIdByCode	Custom Asset Session	<SITE NAME>/types/<ASSET NAME>/search	GET
getContentIdByName	Asset Generic	<SITE NAME>/types/<ASSET NAME>/search	GET
getParentIdById	Asset Generic	<SITE NAME>/types/<ASSET NAME>/assets	GET
createUpdateCourse	Asset Course	<SITE NAME>/types/<ASSET NAME>/assets	POST
createUpdateCourseParent	Asset Generic	<SITE NAME>/types/<ASSET NAME>/assets	POST
createUpdateSession	Custom Asset Session	<SITE NAME>/types/<ASSET NAME>/assets	POST
isCourseSessionReady	Asset Course	<SITE NAME>/types/<ASSET NAME>/assets	GET
isSessionDifferent	Custom Asset Session	<SITE NAME>/types/<ASSET NAME>/assets	GET
deleteSession	Custom Asset Session	<SITE NAME>/types/<ASSET NAME>/assets	DELETE

Below are some important point to highlight:

• To get an authentication token for WcSites 11 the endpoint http://HOST:PORT/cas/v1/tickets has to be called twice. First time with username and password in the body of a POST, while the second time with the ticket in the Url of the request. Please note that this "service" does not return XML, but HTML therefore this has to be parsed with OSB.
• All the http POST/DELETE methods on WcSites must be called with the parameter Multiticket in the url

<http:parameter name="multiticket" value="<ticket>">

</http:parameter>

• The Search method uses an url parameter as below. Please note the search against a specific parameters has to be enabled in Sites first:

<http:parameter name="field:name:equals" value="<CODE VALUE>">

</http:parameter>

Possible problems

• In case the REST api invocation fails with this:

"OSB-38000 BAD Gateway "

Then uncheck in the OSB Business Service the Chunked mode and redeploy it!

• In case the WebService invocation fails with this:

"MOVED TEMPORALLY"

Then the credential account is not configured correctly in OSB or the process can't see it. Review it!
Tip: By default, if an authorization failure occurs, the login page for Central Authentication Service (CAS) is displayed. If you want to receive a 500 error instead, add auth-redirect=false to the URL when making the request.

Please find the REST api documentation here!
The source code of the OSB pipeline created here! 

Oracle ServiceCloud Rightnow Integration, XSLT Transformations!

I've just roll out to a live environment, a SOA Integration project with Oracle Service Cloud Rightnow.

The customer needed to migrate from a in-house CRM to Oracle Service Cloud and with my company Infomentum we have helped them in taking this big step. Since that I have made lots of experience with OSC WebServices.

Here I just want to share the complex XSLT Transformation which we have implemented to communicate with the OSC WebServices, hopefully these can speed up any other SC integration projects.

There are 6 transformation in the ZIP package (we have implemented more):

XSLT Name	SC Object	Out of the box Object?	Operation Type
xsltContact2Update	CONTACT	Yes	UPDATE
xsltOrganisationToUpdate	ORGANIZATION	Yes	UPDATE
xsltProgrammeToUpdate	CO.PROGRAMME	No	UPDATE
xsltProgrammeTypeToUpdate	CO.PROGRAMMETYPE	No	UPDATE
xsltCourseToUpdate2	CO.COURSE	No	UPDATE
xsltSessionToUpdate	CO.SESSION	No	UPDATE

In the XSLTs you'll find all the details about the TARGET columns (Oracle Service Cloud ones).

Here are some important concepts I want to highlight:

• SC Columns in the XSLT are sometimes out of the box column, in some other cases they are custom ones. In the XSLT the latter will be identified with the tag GenericFields.

             <rng_v1_2:GenericFields dataType="OBJECT" name="C">

                <rng_v1_2:DataValue>

                  <rng_v1_2:ObjectValue xsi:type="rng_v1_2:GenericObject">

                    <rng_v1_2:ObjectType>

                      <rng_v1_2:TypeName>ContactCustomFieldsc</rng_v1_2:TypeName>

                    </rng_v1_2:ObjectType>

                    <rng_v1_2:GenericFields dataType="BOOLEAN" name="yp_surveydeclined_mail_bol">

                        <rng_v1_2:DataValue>

                          <rng_v1_2:BooleanValue>

                            <xsl:value-of select="/ns0:contact/ns0:isMailOptionSur"/>

                          </rng_v1_2:BooleanValue>

                        </rng_v1_2:DataValue>

                    </rng_v1_2:GenericFields>

                  </rng_v1_2:ObjectValue>

                </rng_v1_2:DataValue>

              </rng_v1_2:GenericFields>

• Custom fields can be in the subPackage C or CO (you'll find this package in the attribute NAME of the GenericFields tag). The former is used for custom fields, the latter for custom object relationship fields. In this case the data type might be something like dataType="NAMED_ID", which means this is related to a complex object

          <rng_v1_2:GenericFields dataType="OBJECT" name="CO">

            <rng_v1_2:DataValue>

              <rng_v1_2:ObjectValue xsi:type="rng_v1_2:GenericObject">

                <rng_v1_2:ObjectType>

                  <rng_v1_2:TypeName>ContactCustomFieldsc</rng_v1_2:TypeName>

                </rng_v1_2:ObjectType>

                <rng_v1_2:GenericFields dataType="NAMED_ID" name="all_addr_region_lst">

                    <rng_v1_2:DataValue>

                      <rng_v1_2:NamedIDValue>

                        <rnb_v1_2:Name>

                          <xsl:value-of select="/ns0:contact/ns0:Region"/>

                        </rnb_v1_2:Name>

                      </rng_v1_2:NamedIDValue>

                    </rng_v1_2:DataValue>

                </rng_v1_2:GenericFields>

              </rng_v1_2:ObjectValue>

            </rng_v1_2:DataValue>

          </rng_v1_2:GenericFields>

• In order to blank any field in SC the client must pass the attribute xsi:nil="true" in the attribute tag or in the DataValue tag for the custom field.

          <rng_v1_2:GenericFields dataType="OBJECT" name="CO">

            <rng_v1_2:DataValue>

              <rng_v1_2:ObjectValue xsi:type="rng_v1_2:GenericObject">

                <rng_v1_2:ObjectType>

                  <rng_v1_2:TypeName>ContactCustomFieldsc</rng_v1_2:TypeName>

                </rng_v1_2:ObjectType>

                <rng_v1_2:GenericFields dataType="NAMED_ID" name="all_addr_region_lst">

                    <rng_v1_2:DataValue xsi:nil="true">

                      <rng_v1_2:NamedIDValue>

                        <rnb_v1_2:Name></rnb_v1_2:Name>

                      </rng_v1_2:NamedIDValue>

                    </rng_v1_2:DataValue>

                </rng_v1_2:GenericFields>

              </rng_v1_2:ObjectValue>

            </rng_v1_2:DataValue>

          </rng_v1_2:GenericFields>

• PhoneList and EmailList attribute needs to be managed via the ACTION (update, add, remove) attribute in the XSLT and via the TYPE ID (the ID of the Phone, since they might be multiple, like Mobile1, Work, Landline, etc, same applies to the Email)

           <rno_v1_2:Phones>

              <rno_v1_2:PhoneList action="update">

                <rno_v1_2:Number>

                  <xsl:value-of select="/ns0:contact/ns0:TelWork"/>

                </rno_v1_2:Number>

                <rno_v1_2:PhoneType>

                  <rnb_v1_2:ID id="{0}"/>

                </rno_v1_2:PhoneType>

              </rno_v1_2:PhoneList>

              <rno_v1_2:PhoneList action="remove">

                <rno_v1_2:PhoneType>

                  <rnb_v1_2:ID id="{1}"/>

                </rno_v1_2:PhoneType>

              </rno_v1_2:PhoneList>

              <rno_v1_2:PhoneList action="remove">

                <rno_v1_2:PhoneType>

                  <rnb_v1_2:ID id="{2}"/>

                </rno_v1_2:PhoneType>

              </rno_v1_2:PhoneList>

Below is an easy transformation used for the Programme CustomObject Update

    <ns1:Update>
      <ns1:RNObjects xsi:type="rng_v1_2:GenericObject">
        <rnb_v1_2:ID id="{$InvokeGetProgramme_QueryCSV_OutputVariable.parameters/ns1:QueryCSVResponse/ns1:CSVTableSet/ns1:CSVTables/ns1:CSVTable/ns1:Rows/ns1:Row}"/>
        <rng_v1_2:ObjectType>
          <rng_v1_2:Namespace>CO</rng_v1_2:Namespace>
          <rng_v1_2:TypeName>Programme</rng_v1_2:TypeName>
        </rng_v1_2:ObjectType>
        <rng_v1_2:GenericFields dataType="INTEGER" name="all_soa_totcodeid_int">
          <rng_v1_2:DataValue>
            <rng_v1_2:IntegerValue>
              <xsl:value-of select="/ns0:programme/ns0:CodeID"/>
            </rng_v1_2:IntegerValue>
          </rng_v1_2:DataValue>
        </rng_v1_2:GenericFields>
        <rng_v1_2:GenericFields dataType="STRING" name="all_all_name_txt">
          <rng_v1_2:DataValue>
            <rng_v1_2:StringValue>
              <xsl:value-of select="/ns0:programme/ns0:Description"/>
            </rng_v1_2:StringValue>
          </rng_v1_2:DataValue>
        </rng_v1_2:GenericFields>
        <rng_v1_2:GenericFields dataType="BOOLEAN" name="all_all_deleted_bol">
          <rng_v1_2:DataValue>
            <rng_v1_2:BooleanValue>
              <xsl:value-of select="/ns0:programme/ns0:Deleted"/>
            </rng_v1_2:BooleanValue>
          </rng_v1_2:DataValue>
        </rng_v1_2:GenericFields>
        <rng_v1_2:GenericFields name="all_soa_modified_dt" dataType="DATETIME">
          <rng_v1_2:DataValue>
            <rng_v1_2:DateTimeValue>
              <xsl:value-of select="ptutlGmt:getCurrentDateInGMT(string(/ns0:programme/ns0:SOA_ModifiedDate))"/>
            </rng_v1_2:DateTimeValue>
          </rng_v1_2:DataValue>
        </rng_v1_2:GenericFields>
        <rng_v1_2:GenericFields dataType="BOOLEAN" name="all_all_fromsoa_bol">
          <rng_v1_2:DataValue>
            <rng_v1_2:BooleanValue>1</rng_v1_2:BooleanValue>
          </rng_v1_2:DataValue>
        </rng_v1_2:GenericFields>
      </ns1:RNObjects>
    </ns1:Update>

Please download the transformation from here!

Also find here more information about this challenging project:
http://www.computing.co.uk/ctg/news/2433947/princes-trust-opts-for-oracle-for-digital-transformation
http://www.infomentum.com/uk/about-us/media-centre/news/princes-trust-golive

Let me know for any issues!!!

Connect and consume data with Oracle RightNowCX using the new SOA12c RightNow adapter

The  Oracle RightNow adapter has been released for the SOA 12.1.3 just couple of months ago, and I tested as soon as I've heard of it!

What it is needed for this tip

• JDeveloper 12.1.3
• An account with read right on the WebServices exposed by an Oracle Rightnow instance

Before starting!

Make sure the following patch bundle has been applied to your SOA/jdev Home.

Bundle Patch for Bug: 20423408

The patch can be downloaded from Oracle support of course, and installed using opatch apply.
The patch must be applied to both, the SOA Server home (if not in the jdev home) and Jdev home, since the new plugin which will shows the RightNow adapter wizard, must be configured into JDeveloper.
Remember to perform the post-installation steps (patch READ-ME for details):

1. Log in to Fusion Middleware Control Enterprise Manager.
2. Expand "Weblogic Domain" in the left panel
3. Right click on the domain you want to modify and select Security > System Policies to display the page System Policies.
4. In the System Policies page, expand "Search". For "Type" select "Codebase", for "Includes" enter "jca" and click the arrow button.
5. Select "jca-binding-api.jar" in the search returned result and click "Edit".
6. In the "Edit System Grant" page, click on "Add".
7. In the "Add Permission" page, click on "Select here to enter details for a new permission" and enter the following:

• Permission Class:oracle.security.jps.service.credstore.CredentialAccessPermission
• Resource Name: context=SYSTEM,mapName=SOA,keyName=*
• Permission Action: *

8. Click on "OK" to save the new permission.


In order to verify the installation went well please double check you'got the RightNow Adapter in the Cloud Adapter Component palette:

After the installation start JDeveloper with the option "jdev.exe -clean"

Hands on!

• Generate one SOA application with an empty SOA project.
• Drag and drop an Oracle Rightnow component in the External reference lane and the wizard will pop up
• Insert the WSDL url (the WSDL and XSD schemas will be downloaded), also create a new csf key in Jdeveloper with your username and password for Oracle Rightnow. 

• Select the Create WSDL operation and the Contact business object

• Click FINISH
• Now add a WIRE from the BPEL process to the Rightnow adapter
• Edit the composite input XSD adding the following fields:

<element name="process">

<complexType>

<sequence>

<element name="Name" type="string"/>

<element name="LastName" type="string"/>

<element name="Address" type="string"/>

<element name="PostCode" type="string"/>

</sequence>

</complexType>

</element> 

• Open the BPEL process and add an invoke to the adapter (create input and output variables)
• Add a transformation which will be used to set properly the invoke input variable for the Rightnow adapter.
• Edit the transformation as showed below. The left variable is the composite input variable, while the right one is the Rightnow input one 

• So the BPEL process will look like this below

• Deploy it top the integrated SOA Server
• Last step, configure the username and password in the EM console using the CSF key MyRightNowUser configured in the JCA adapter in WeblogicDomain => Security => Credentials in the Credential Map SOA, as showed below

The SOA Composite can now be tested and hopefully an account will be created in Oracle Rightnow SC!
Let me know for any issue (see Possible problems below)!

Tip: instead of configuring the credentials in the SOA-EM, the csfkey property parameter in the jca-properties definition can be omitted and replaced with username and password parameters

Possible problems

• In case the WebService invocation fails with this:

"Exception occurred during invocation of JCA binding: "JCA Binding execute of Reference operation 'Create' failed due to: Unable to create Cloud Operation:

The invoked JCA adapter raised a resource exception.

Please examine the above error message carefully to determine a resolution "

Then replace in the Rightnow JCA the targetWSDLURL local WSDL with the remote one, as explained here and redeploy it!

• In case the WebService invocation fails with this:

"Exception occurred during invocation of JCA binding: "JCA Binding execute of Reference operation 'Create' failed due to: Client received SOAP Fault from server : Username is not specified in UsernameToken."

Then the credential key is not configured correctly in the credential store or the process can't see it. Review it!

• In case the WebService invocation fails with this:

"Exception occurred during invocation of JCA binding: "JCA Binding execute of Reference operation 'Create' failed due to: Client received SOAP Fault from server : Access Denied."

Then the user-password are not correct in the credential key. Review it!

Please find the RightNow Cloud Service Adapter documentation here!
The source code of the composite created here! 

Endeca Guided Search Installation and Deployments

Endeca Guided Search - Pre-requisites

In order to setup Oracle Endeca Commerce on RHL the following requirements are needed:

• An oracle user
• A folder, owned by the oracle user, for the product binaries, possibly in the file-system root (in this how-to we are assuming that the main installation folder is set to /u01/oracle).
• A static ip-address and the hostname mapped in the /etc/hosts file.

Is also necessary download the installation packages from the oracle edelivery cloud for the Linux operating system. The packages to download are:

• Oracle Endeca MDEX engine.
• Oracle Endeca PlatformServices.
• Oracle Endeca Content Acquisition System.
• Oracle Endeca ToolsAndFrameworks.

Here the OS requirement:

• DOS2UNIX package has to be installed if not: yum install dos2unix 

Endeca Guided Search - Server Installation

Step 1 - Install the Oracle Endeca MDEX engine

Unzip the Oracle Endeca MDEX package and run the follow command (replace the ? with the version of the file in use):
chmod +x mdex?????.sh
./mdex???????.sh --target /u01/oracle
At the end of the process instead running the script as suggested open it and copy and paste the variables declaration into the .bash_profile file then reload the profile. Run the follow command to check that the MDEX root folder has been set in the environment
echo $ENDECA_MDEX_ROOT
Create an apps folder under the main Endeca installation folder.

Step 2 - Install the Oracle Endeca PlatformServices

Unzip the Oracle Endeca PlatformServices package and run the follow command (replace the ? with the version of the file in use):
chmod +x platformservices?????.sh
./platformservices?????.sh --target /u01/oracle
During the setup process provide:

• The Endeca HTTP service port, by default is set to 8888 (use this port if not already binded by other processes).
• The Endeca HTTP shutdown service port, by default is set to 8090 (use this port if not already binded by other processes).
• The Endeca Control System JCD port , by default is set to 8088 (use this port if not already binded by other processes).
• Type Y to install the EAC agent.
• The MDEX full path included with the version number (ie. /u01/oracle/endeca/MDEX/6.5.0)
• Type Y to install reference implementations.

At the end of the process, as for the MDEX engine, instead running the script as suggested open it and copy and paste the variables declaration into the .bash_profile file then reload the profile. Run the follow command to check that the ENDECA_ROOT has been set in the environment
echo $ENDECA_ROOT

Step 3 - Install the Oracle Endeca Tools And Framework

Unzip the Oracle Endeca Tools and Frameworks package and run the runInstaller.sh file located under the install sub-directory in the Disk1 folder. Then follow the steps below:

1. Click Next on the welcome page
2. Accept the licence agreement
3. Specify inventory directory and credential and click Next
4. Specify installation type, for development machine install the Full version as it contains reference
5. application, then click Next
6. Specify home details and click Next
7. Provide administrator password for Workbench console and click Next
8. Review installation options and click on Install
9. Run the inventory script as root before closing the window
10. Click on Exit

At the end of the process installation process is necessary, in order to proceeed with the Content Acquisition System setup, define in the bash_profile the following two variables (path could change) and reload the profile:
ENDECA_TOOLS_ROOT=/u01/oracle/endeca/ToolsAndFramework/11.0.0
export ENDECA_TOOLS_ROOT
ENDECA_TOOLS_CONF=/u01/oracle/endeca/ToolsAndFramework/11.0.0/server/workspace
export ENDECA_TOOLS_CONF

Step 4 - Install the Oracle Endeca Content Acquisition System

Unzip the Oracle Endeca Content Acquisition System package and run the follow command (replace the ? with the version of the file in use):
chmod +x cas?????.sh
./cas?????.sh --target /u01/oracle
During the setup process provide:

• The Endeca CAS service port, by default is set to 8500(use this port if not already binded by other processes).
• The Endeca CAS shutdown service port, by default is set to 8506(use this port if not already binded by other processes).
• The ENDECA_TOOLS_ROOT and ENDECA_TOOLS_CONF should already been defined in the system and the Content Acquisition System will retrieve this information from the user profile so this step will be skipped by default.
• Provide the hostname of the machine on which CAS is installed

Step 5 - Validating the Oracle Endeca Commerce setup

In order to validate the setup start the Endeca services as follow:

• Start PlatformServices using the startup.sh script in /u01/oracle/endeca/PlatformServices/11.0.0/tools/server/bin
• Start the Content Acquisition System using the cas-service.sh script in /u01/oracle/endeca/CAS/11.0.0/bin (better start this service in background using the command nohup ./cas-service.sh &)
• Start the Workbench using the startup.sh script in /u01/oracle/endeca/ToolsAndFrameworks/11.0.0/server/bin
• Connect to the Workbench console available at http://<host>:8006 and check that in the console page a Data
• Control section appears (to confirm that the CAS has been successfully installed, also if this console is accessible then the CAS is running on the host).

Step 6 - Try to deploy the reference application

To deploy the reference application run the deployment template pointing the discovery reference application.
Follow this step:
Access to the deployment template folder under ToolsAndFrameworks (ie. /u01/oracle/endeca/ToolsAndFrameworks/11.0.0/deployment_template/bin)

• Run the deployment command ./deploy.sh --app /u01/oracle/endeca/ToolsAndFrameworks/11.0.0/reference/discover-data-catalogintegration/deploy.xml
• Press Return
• Digit Y and press Return
• Provide an application name (ie. test)
• Provide the deployment directory (/u01/oracle/endeca/apps)
• provide the EAC port (by default is 8888)
• Provide the CAS installation folder (ie. /u01/oracle/endeca/CAS/11.0.0)
• Provide teh CAS version (ie. 11.0.0)
• Provide the hostname where CAS is running
• Provide the CAS port (byd efault is 8500)
• Provide the default language (by edfault is english)
• Provide the Workbench port (by default is 8006)
• Provide the port that the catalogue should use for the DGraph process (if not already used accept the default value 15000)
• Provide the port that the catalogue should use for the Authoring DGraph process (if not already used accept the default value 15002)
• Provide the port that the catalogue should use for the Log server process (if not already used accept the default value 15010)
• Press return
• Press return

To start the reference application follow this steps:

• Access to the control folder located under the main application catalogue folder.
• Run the ./initialize_services.sh script
• Run the script ./load_baseline_test_data.sh
• Run the script ./baseline_update.sh
• Run the script ./promote_content.sh
• Access to the reference application (http://<host>:8006/endeca_jspref) provide as host localhost and as port the DGraph port provided during the application deployment phase (in this case 15000) and check that the data has been succesfully loaded

Optional: Assembler service application Deployment

1. Copy the folder  ENDECA SERVER/ToolsAndFrameworks/3.1.2/reference/discover-service into a folder with a different name (for instance new-discover-service) within the same folder (so you'll have  ENDECA SERVER/ToolsAndFrameworks/3.1.2/reference/new-discover-service).
2. Edit the ENDECA SERVER /ToolsAndFrameworks/3.1.2/reference/new-discover-service/WEB-INF/assembler.properties with the correct port and host of the application previously deployed (Step 6).
3. Copy the file ENDECA_SERVER/ToolsAndFrameworks/3.1.2/server/workspace/conf/Standalone/localhost/discover.xml into a file with a different name (for instance new-discover-service.xml), customize it with the path of the application created at point 1 (ENDECA SERVER/ToolsAndFrameworks/3.1.2/reference/new-discover-service), and copy the file into the same folder (so you'll have ENDECA_SERVER/ToolsAndFrameworks/3.1.2/server/workspace/conf/Standalone/localhost/new-discover-service.xml).
4. Access to the Assembler application just deployed via REST interface using this url (update host and port if you need): http://54.228.239.224:8006/new-discover-service/json/services/guidedsearch?Ntt=<SearchKeyword>

Please let me know for any issues!!!

SOA11 and Coherence integration case study

In one of the project where I've worked on, the customer was facing issues due to the many web services calls triggered by their portal. Basically the Service Bus was crashing since it was reaching its limit in terms of web services transactions supported.

The initial architecture

The logged in users in Web Center portal were triggering calls trough the ADF framework to the OSB, and those calls were validated and enriched and then routed to the target third party services. All those operation were synchronous.

The analysis

We decided to take a deeper look to understand which services were being called, how many times and with which frequency, etc.
The tool we used here, was the Statistics in the OSB. We enabled them on all the Web Services, we run the Portal, and played with the functionality, which were calling the WS under analysis.

After 10 minutes we got the following result, where we noted 2 main things:

1. There were some WS operations called very frequently (1 each 20 msecs for each logged users) like GetTask and GetCurrentState, while all the others were being called only few times.
2.  The WS calls were getting information only for the specified WC Portal user which was triggering theggering thise calls.

The Solution

We spoke with the developers of the third party WS, proposing them to move to a "bundle" approach. Basically we asked them to expose two more operations, GetBundleTask and GetBundleState, which respectively were like GetTask and GetCurrentState, but with a list of usersId/taskId in input.
We configured a new Coherence server, thinking about using an asynchronous approach and the caching of the data. The architecture now looks like this:

Benefits:

• The WebCenter/ADF layer did not need any modification since we did not touch the OSB WS interfaces.
• The SOA Async process was getting data in bundle for all the Users logged in in one call (or very few) with much better results.
• The services exposed on the OSB were getting the data 99% of the time from the local cache, so the network latency was now almost zero and the average response time was 30 times less.

Here are the new statistics after applying those changes. The number of calls to getTask and getCurrent state external WebServices from the OSB were dropped of the 99%, all the data were coming from the cache.

Here the Async BPEL service was facing the same latency calling the bundle services then the singe OSB services, but at least this time we were calling them with a list of users.

Here are some sequence diagram which explains now the sequence of the operations. The OSB Service now try to get the data from Coherence, if it is  not found it get the same from the OLD external services, and "subscribe" the users for update.

The SOA Business service was calling the external bundle services based on the "subscribed" users list.  

SOA Testing in Maven

Currently there are few tools that can support testing SOAP interfaces.

For instance Jmeter and SoapUI are suited for testing soap interfaces.

• SoapUI is explicitly created for testing SOAP interfaces
• Jmeter has a SOAP support since version 2.3.x. 

SoapUI, has an intuitive user interface and is flexible.
You can run SoapUI stand alone and it can be to integrated within an automated process.

Below you will find instructions for running SoapUI as a part of a maven build. This makes it possible to run your automated SOAP tests in Maven with a build process like Jenkins. Combined with automatic deployment it is possible to support an agile software development process that supports frequent delivery of versions and continuous integration and testing.

Maven2 supports SoapUI with the Maven SoapUI plugin.

Usage:

Add the eviware plugin repository to your repository list.

 
<pluginRepositories>
  <pluginRepository>
    <id>eviwarePluginRepository</id>
    <url>http://www.eviware.com/repository/maven2/</url>
  </pluginRepository>
</pluginRepositories>

Attach to verify phase

By attaching the SoapUI maven plugin to the verify phase your build process runs it automatically in the integration-test phase. The “iso-soapui-project.xml” is the reference to the SoapUI xml file.

 
<plugin>
  <groupId>eviware</groupId>
  <artifactId>maven-soapui-plugin</artifactId>
  <version>2.0.2</version>
  <executions>
    <execution>
      <phase>verify</phase>
      <id>soapui-tests</id>
      <configuration>
        <projectFile>${basedir}/src/test/soapui/iso-soapui-project.xml</projectFile>
        <outputFolder>${basedir}/target/soapui</outputFolder>
        <junitReport>true</junitReport>
        <exportwAll>true</exportwAll>
        <printReport>false</printReport>
      </configuration>
      <goals>
        <goal>test</goal>
      </goals>
    </execution>
  </executions>
</plugin>

Convert log to a report

The log export of SoapUI can be interpreted like a normal Surefire unit report. By just adding this part to your maven reports section you can generate a nice overview of your test results.

 
<reporting>
  <plugins>
    <plugin>
      <groupId>org.apache.maven.plugins</groupId>
      <artifactId>maven-surefire-report-plugin</artifactId>
      <configuration>
         <outputDirectory>target/site/soapui</outputDirectory>
         <reportsDirectories>
           <reportsDirectories>target/soapui/</reportsDirectories>
         </reportsDirectories>
      </configuration>
    </plugin>
  </plugins>
</reporting>

Thanks to the AMIS blog for this information!!!

Oracle Code Compliance Inspector

The Code Compliance Inspector uses a pre-defined set of assertions that are based on SOA AIA Integration Developer guidelines and the Web Services Interoperability Organization Basic Profile (WS-I BP) to check SOA projects for design consistency and good coding and documentation practices. CCI qualifies code as Compliant, Conformant, or Fully Conformant to be in sync The Open Group Architecture Framework (TOGAF) standard guidelines based on the pass criteria of the highest priority assertions.

• CCI is available as a JDeveloper extension
• As a command-line utility
• Oracle Enterprise Repository (OER) utility

Developers will typically use the JDeveloper extension and will continuously check compliance on JDeveloper projects as they develop.

The CCI command line utility can be used to incorporate CCI code check as part of our build/deployment/continuous integration process. So every time someone checks code into main branch, the Continuous Integration tool can automatically checkout the code, do a CCI code compliance test and then build and deploy. Of course if the code is not compliant it can send an error notification to a distribution list, without deploying.
Here are some examples for invoking the Code Compliance Inspector from a command line:

• Windows: checkCompliance.bat -inputDir D:\AIA\demo -outputDir D:\ComplianceOut
• Linux: sh checkCompliance.sh -inputDir /AIA/demo -outputDir /ComplianceOut

CCI provides optional integration to Oracle Enterprise Repository (OER). When OER is present, CCI can synchronize results to the repository, enabling users to access the report from the OER console. Integrating compliance data into OER provides repository users with information about whether composites are compliant into the repository reports and individual asset metadata.

To make it working in JDEV11 is quite easy, just download and install the extensions in JDeveloper

Then right-click the project and select Check Code Compliance.

Note: when the project is selected, the code compliance inspector can also be launched
from the toolbar.

A highlighted Compliance Results tab will appear in the log panel, go ahead and select it
to see the project status

In this environment, we are simply checking compliance against WS-I standards, but there are also other standards delivered with Oracle Application Integration Architecture Foundation Pack that can check much more as well as additional checks that can be added by your team