OSB - B2B Integration - EDIFACT

Usecase 1: OSB to use B2B for translating the EDIFACT XML document to native using the translation webservice exposed by B2B .

 

B2B Configuration

 

Oracle B2B 11g PS2 release has exposed webservices to translate XML document to Native document. This service needs an outbound agreement in B2B configured with appropriate document  targeted for a specific trading partner.

 

For e.g FromTP - MarketInc,  and toTP -OracleServices ( these value has to be updated in OSB configuration - File-In ProxyService). From EDIFACT XML document, we can identify the document type and document revision.  These details used to identify the agreement in B2B.

 

B2B translation webservice can be used in two modes, one for only translation and another for translation and routing.

 

OSB-B2B integration sample are developed based on the B2B sample "b2b-003-EDIFACT" in OTN, which deals with the creation/management of B2B configuration in detail.

 

Path structure:

b2b_003_edifact_1.0.zip\SOASamples\b2b\b2b_003_edifact\artifacts\b2b\

b2b_003_MI_EDIFACT_ORDERS_CONTRL_v1.zip\AS2_M_O_EDIFACT_D3_CONTRL_Agr.zip

 

 
 
msgosb1.jpg
 
 

 

 
OSB Configuration

 

Steps to create OSB Configuration sample:

1.       Create a OSB Project with name OSB-B2B

2.       Create BusinessService with name B2BBusinessService to consume B2B TranslateService

URL http://<host:8001>/b2b/services/ TranslateService

 

 

3.       Create BusinessService with name File_Out

Property Name

Value

RequestType

text

Provider id

File

URI

file:///C:/temp/OSB/out

Suffix

.txt

 

4.       Create ProxyService with name local_Proxy with following properties

Property Name

Value

requestType

text

reponseType

text

Provider id

local

 

5.       Add Rout node for local_Proxy

6.       Add Service Callout to Rout node to wire OSB-B2B/File_Out

7.       Create ProxyService with name File_in  with following properties

Property Name

Value

fileMask

.xml

pollingInterval

5

Binding type

XML

postAction

delete

Provider id

 File

URI

file:///C:/temp/OSB/in

stageDir

C:\temp\OSB\stage

errorDir

C:\temp\OSB\error

 

8.       Add pipeline pair

9.       In request pipeline pair create following assign actions

Variable

XQuery Text

documentType 

$body//pf1:Element-0065/text()

version

xs:string($body/(@Version))

from

xs:string('MarketInc')

to

xs:string('OracleServices')

body1

<![CDATA[<b2b:TranslateRequest xmlns:b2b="http://xmlns.oracle.com/integration/b2b">

    <!--Optional:-->

    <b2b:from type="Name">{$from}</b2b:from>

    <!--Optional:-->

    <b2b:to type="Name">{$to}</b2b:to>

    <b2b:documentTypeName>{$documentType}</b2b:documentTypeName>

    <b2b:documentProtocolVersion>{$version}</b2b:documentProtocolVersion>

    <!--Optional:-->

    <b2b:action>anyType</b2b:action>

    <!--Optional:-->

    <b2b:encoding>utf-8</b2b:encoding>

    <b2b:payload>{$body/*}</b2b:payload>

</b2b:TranslateRequest>]]>

body

&lt;soap:Body xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

{$body1}

&lt;/soap:Body>

 

10.    In response pipeline pair create following assign actions

Property Name

Value

body1

fn:data($body/*)

 

11.    In response pipeline pair create following sevice callout with Service reference "B2B-OSB/local proxy"

Property Name

Value

Request

$body1

response

response

 

clip_image003.jpg

 

 

12.       Add route node for File_in  with  Service reference "B2B-OSB/B2BBusinessService" and select operation "Translate"

 

 

 

osb4.jpg
 

 

 

 

13.       File_in ProxyService

 

 

 

osb5.jpg
 

 

 

 

 

14.       OSB project elements

 

 

 

osb6.jpg
 

 

 

 

Usecase 2: B2B webservice used for translation and routing as well.

 

For translation and routing, OSB is required to create the BusinessService using the URL.

 

http://<host:port>/b2b/services/OutboundService

 

Useful Links:

OTN B2B website

B2B Samples in OTN

  

Same approach can be used for B2B-OSB integration for a healthcare scenario. This is one way of integrating B2B translation service with OSB. Refer for more details in OTN B2B website .

 

Comments:

The information about B2B is quite confusing when we try to make an integration with Oracle eBS, is this component needed to install adapters for RosettaNet or Edifact?. Some documents say that B2B is needed only in case of using BPEL. Is that true?, how can be in case the trading partner has its own B2B with webMethods? Thanks!

Posted by Eva Santisteban on February 15, 2011 at 06:57 PM IST #

B2B is a gateway product which comes with pre-built protocol/adapters support like RN and EDI. B2B can be used directly, where backend has to be either of JMS, AQ or BPEL. Please do contact Oracle Support or PM team to get more details. This way we can understand your business need and give best solution for the same.

Posted by krishnamoorthy.dharmalingam on February 21, 2011 at 07:02 AM IST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

To Discover and discuss the capability of B2B in the world of Trading Partner Integration. This blog is primarily intended to share thoughts on Oracle B2B Product and to share best practices in performance, scalability and various topologies.

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today