12 Working with Domain Value Maps

Domain value maps (DVMs) are a standard feature of the Oracle Service Oriented Architecture (SOA) suite. They are tables containing mapping between related information in the participating applications. They enable you to equate lookup codes and other static values across applications, for example, FOOT and FT or US and USA. These DVM tables are maintained in the AIA layer. The AIA layer uses these DVM tables in transforming the messages from one system in the expected format of the other system.

For more information about DVMs, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation PackOracle Fusion Middleware Developer's Guide for Oracle SOA Suite,, "Working with Message Transformations" and "Working with Domain Value Maps."

Table 12-1 lists the domain value mappings (DVMs) for the Financial Management Integration:

Table 12-1 DVMs for Financial Management Integration

Names	Columns	Description
ACCOUNTINGENTRY_ACCOUNTINGENTRYTYPE	COMMON, EBIZ, OTM does not have corresponding value	Domain value mapping for the Accrual Type
ACCOUNTINGENTRY_JOURNALCATCODE	COMMON, EBIZ	Domain value mapping for Journal Category Code
ADDRESS_COUNTRYID	EBIZ_01, COMMON, OTM_01	Domain value mapping for country codes
ADDRESS_COUNTRYSUBDIVID	EBIZ_01, COMMON, OTM_01	Domain value mapping for state code in supplier address
APPS_USER	USER_NAME, LANG_CODE	Domain Value mapping for the Oracle E-Business Suite User and Language Code
CURRENCYEXCHANGE_CONVERSIONTYPECODE	EBIZ_01, COMMON, OTM_01	Domain value mapping for currency type codes.
CURRENCYEXCHANGE_STATUSCODE	EBIZ_01, COMMON,	Domain value mapping for status code of currency exchange rates.
INVOICE_INVOICELINETYPE	COMMON, OTM, EBIZ	Domain Value mapping for the Receivable Invoice Line Type
INVOICE_INVOICETYPE	COMMON, EBIZ, OTM does not have corresponding value	Domain Value mapping for the Invoice Type
LANGUAGE_CODE	EBIZ_01, COMMON, OTM_01	Domain value mapping for Languages
PAYABLEINVOICE_PAYABLEINVOICELINETYPE	COMMON, OTM, EBIZ	Domain Value mapping for the Payable Invoice Line Types.
PAYABLEINVOICE_PAYABLEINVOICETYPE	COMMON, EBIZ, OTM does not have corresponding value.	Domain Value mapping for the Invoice Type.
PAYMENTMETHOD_CODE	COMMON, OTM, EBIZ	Domain Value mapping for the Payment Method Codes
SUPPLIERPARTY_ADDRESSTYPE	EBIZ_01, COMMON	Domain value mapping to map type of site pay/purchase
SUPPLIERPARTY_PAYSITEFLAG	EBIZ_01, COMMON, OTM_01	Domain value mapping to map Pay site flag Y/N to True/False
SUPPLIERPARTY_PRIMARYSITEFLAG	EBIZ_01, COMMON, OTM_01	Domain value mapping to map Primary site flag Y/N to True/False
SUPPLIERPARTY_TYPECODE	EBIZ_01, COMMON, OTM_01	Domain value mapping for supplier type

Table 12-2 displays the domain value mappings (DVMs) seeded data:

Table 12-2 DVM Seed Data

Name	Column	Description
ADDRESS_COUNTRYID	Common, OTM_01, EBIZ_01	NA
COMMUNICATION_METHOD	Common, OTM_01, EBIZ_01	NA
CONTACT_SALUTATION	Common, OTM_01, EBIZ_01	Mr., Mrs., and so on.
CUSTOMERPARTY_ACCTSITESTATUS	Common, OTM_01, EBIZ_01	ACTIVE, INACTIVE
CUSTOMERPARTY_STATUSCODE	Common, OTM_01, EBIZ_01	ACTIVE, INACTIVE
LOCATION_ROLE	Common, OTM_01, EBIZ_01	Ship To, Bill To, and so on.
STATE	Common, OTM_01, EBIZ_01	NA