12c OSB - DVM Implementation

Create a Service bus project

Create a Proxy schema:

<?xml version="1.0" encoding="windows-1252" ?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns="http://www.proxyDVM.org"
targetNamespace="http://www.proxyDVM.org" elementFormDefault="qualified">
<xsd:element name="Request">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="CountryCodeIn" type="xsd:string"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
<xsd:element name="Response">
<xsd:complexType>
<xsd:sequence>
<xsd:element name="CountryCodeOut" type="xsd:string"/>
</xsd:sequence>
</xsd:complexType>
</xsd:element>
</xsd:schema>

Create a proxy wsdl based on the created schema.

Create a proxy and pipeline based on the created proxy wsdl.

Create a Country.dvm 

Open the pipeline and drag and drop pipeline pair node and take a assign activity and use the dvm to fetch the mapping values.

dvm:lookup('DVMSBProject/CountryCode', 'CountryName', $body/prox:Request/prox:CountryCodeIn, 'CountryCode', 'NotFound')

Now create one xquery to map this dvm output to proxy response.

Use the created Xquery in the replace activity

deploy to the server and test