Domain value maps (DVMs) are a standard feature of the Oracle Service Oriented Architecture (Oracle 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.
This chapter includes the following section:
For more information about DVMs, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack Oracle 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.
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 |