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:
- use for <dvm-location> the name without the extension.
- 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!Overzicht blogs