SOA 11g DVM with Qualifier Example

DVM with Qualifier is little different.
Code.dvm

?xml version="1.0" encoding="UTF-8" ?
dvm name="Foods" xmlns=http://xmlns.oracle.com/dvm
description /description
columns
column name="KEY" qualifier="true"/
column name="NAME"/
column name="VALUE"/
/columns
rows
row
cellASIA/cell
cellINDIA/cell
cell91/cell
/row
row
cellASIA/cell
cellSRILANKA/cell
cell044/cell
/row
/rows
/dvm

Function to use in Transformation or in Assign activity is as below
xsl:value-of select='dvm:lookupValue("Foods.dvm","NAME",/client:process/client:input,"VALUE","DEFAULTVALUE","KEY","ASIA")'/

You can find more information in the below URL.
Example:
http://docs.oracle.com/cd/E21764_01/integration.1111/e10224/med_dvm.htm#autoId3

Printing output value in EM Console while using Java Embedded in BPEL

When you work with Java Embedded, you wont be able to see the output in console.
To see the output value in the console,  use the below function

addAuditTrailEntry("Status is: " + status);

You can see the output message as below.

Status is: TRUE