OSB 12c: tips for use DomainValueMap in Xquery

Today I was building a Xquery with a reference to a DomainValueMap (DVM) in JDeveloper 12c for an OSB 12c project.

When testing my Xquery I ran into the following error:

Caused by: oracle.tip.dvm.exception.DVMValidationException: Unable to get Metadata Manager for DVM ""
Please ensure the Metadata Manager is available.
at oracle.tip.dvm.DVMManagerImpl.getDVMRTObject(DVMManagerImpl.java:223)
at oracle.tip.dvm.DVMManagerImpl.lookupValue(DVMManagerImpl.java:88)
at com.bea.wli.sb.functions.dvm.DVMFunctions.lookupValue(DVMFunctions.java:40)

When you create a dvm lookup function in Xquery you get this :

dvmtr:lookup(<dvm-location>,<dvm source-domain>, <dvm sourcevalue>, <dvm targetvalue>, <defaultvalue>).

This is the default folderstructure that I use for a servicebus project:

The solution for the error I had is the following.  If you create a Xquery in the folder “Transformation” and use a reference to a domain-value-map remember of the next tips:

1. use for <dvm-location> the name without the extension.
2. also for the <dvm-location>; use the relative path, even when the files are in the same folder.

When you combine tip 1 and 2, the dvm-location of the example will be: ‘ServiceBusProject/Transformation/domainValueMapExample’ and your Xquery referenced with the DVM will run perfectly!