How to use Domain Value Map in SOA Suite 12C

When information transmits between different domains, each domain might use different codes to define a same entity. For example, one domain use country code for representing country and other domain use original country name. In this case Domain Value Map is preferable. Domain Value Map is static in nature. DVM should be specified at the design time in jdeveloper and at the run time application will perform a look for the values in the DVM (Domain Value Map).

Description of Example

Here we will perform DVM operation using File adapters. SOA application will read the city code from one file and write the city name in the other file. Follow the below steps to see how to implement Domain Value Map in SOA application.

1. Create an application for DVM implementation. Select File -> Application -> SOA Application. Enter application name DVMApplication
2. Click on Next and Enter project name. Select Composite With Mediator as Composite type in the next wizard.
3. Mediator creation window will open. Enter mediator name DVMMediator and select Define Interface Later as template type
4. Now create file adapter in both lane Exposed Services and External References. Select File adapter from Technology component palate and drag and drop it in the Exposed Services lane
5. Enter the service name and select the option Define from operation and schema(specified later)
6. Click on Next and select Read File as operation type in the next wizard
7. Navigate to next wizard and enter file directory where input file will be located an also enter the name pattern of the file. File adapter will process only the files which will be matched by the pattern.
8. Click on Next and enter the polling frequency. Then define schema for file adapter in the next wizard by click on cog icon
9. Enter schema file name and directory. Choose Delimited file type in the next wizard and file description also like below screenshot.
10. Click on Next and select the options as shown in the below screenshot
11. Schema is created
12. Drag and drop a file adapter in the External References lane
13. Select Write file as operation type for this file adapter
14. Enter configuration property of file and select same schema which is create for input file earlier in this example.
15. Now the composite will look like below screenshot
16. Create Domain Value Map for city values. Right click on the project and select From Gallery -> SOA Tier -> Transformations/Translations -> Domain Value Map(DVM)
17. DVM file creation window will open. Enter file name and initials DVM entries as per below screenshots.
18. Create mapping in the mediator between exposed service and external reference. Click on transform icon to create mapper file
19. Select dvm:lookup from Advanced XPath -> DVM Functions in the components palate and drag and drop it in the middle lane of the mapper file.
20. Double click on the icon A�and enter dvmLocation, sourceColumnName, souirceValue, targetColumnName and defaultValue as per below screenshot
21. Now mapper file will look like below screenshot
22. Save the project. SOA Composite will look like this
23. Deploy the project and test the project in EM Console. Keep the input file in the indir directory. Use the sample file for testing in the testing folder.
24. Output file will be created in the ourdir that is specified during the configuration of file adapter

Note: If business user adds another domain value with same citycode, below error will come at the time of testing.

To overcome from this type of system error, qualifier will come into the picture. Refer this link for qualifier.