Oracle® Application Integration Architecture Oracle Driver Management Integration Pack for Oracle Transportation Management and Oracle E-Business Suite Implementation Guide Release 3.1 Part Number E23246-03 |
|
|
PDF · Mobi · ePub |
This chapter provides domain value mapping information for these process integration flows:
Driver profiles
Location
Training and Absence Calendar process
Work invoice process
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 Pack, Working with Message Transformations. and Oracle Fusion Middleware Developer's Guide for Oracle SOA Suite, Working with Domain Value Maps.
These are the domain value mappings (DVMs) for the driver profiles process flow:
Table 9-1 DVM for Driver Profile Process Flow
Name | Columns | Description |
---|---|---|
ADDRESS_COUNTRYID |
EBIZ_01, COMMON, OTM_01 |
Mapping for country codes. |
APPS_USER |
USER_NAME, LANG_CODE |
Domain value mapping for language code and user. |
BLOOD_TYPE |
EBIZ_01, COMMON, OTM_01 |
Mapping for blood type. |
BUSINESSGROUP_DOMAIN |
EBIZ_01, COMMON, OTM_01 |
Domain value mapping for business group. |
COMMUNICATION_METHOD |
EBIZ_01, COMMON, OTM_01 |
Mapping for communication methods. |
CONTACT_GENDERCODE |
EBIZ_01, COMMON, OTM_01 |
Mapping for gender. |
PHONE_TYPE |
EBIZ_01, COMMON, OTM_01 |
Mapping for phone type. |
QUALIFICATIONTYPE_ID |
EBIZ_01, COMMON, OTM_01 |
Mapping for qualification type ID/Code. |
STATE |
EBIZ_01, COMMON, OTM_01 |
Mapping for state codes. |
WORKER_ADDRESSTYPE |
EBIZ_01, COMMON, OTM_01 |
Mapping for address type. |
WORKER_ASSIGNMENT_STATUS |
EBIZ_01, COMMON, OTM_01 |
Mapping for assignment status. |
WORKER_CERTIFICATIONID |
EBIZ_01, COMMON, OTM_01 |
Mapping for certification ID. |
WORKER_COMPETENCE_ID |
EBIZ_01, COMMON, OTM_01 |
Mapping for competence ID. |
WORKER_PERIOD_STATUS_CODE |
EBIZ_01, COMMON, OTM_01 |
Mapping for status. |
WORKER_PERSON_TYPE_ID |
EBIZ_01, COMMON, OTM_01 |
Mapping for person type ID. |
These are the domain value mappings (DVMs) for the Location process flow:
Table 9-2 DVMs for Location Process Flow
Name | Columns | Description |
---|---|---|
ADDRESS_COUNTRYID |
EBIZ_01, COMMON, OTM_01 |
Domain value mapping for domain names. |
APPS_USER |
USER_NAME, LANG_CODE |
Domain value mapping for language code and user. |
BUSINESSGOURP_DOMAIN |
EBIZ_01, COMMON, OTM_01 |
Domain value mapping for domain names. |
STATE |
EBIZ_01, COMMON, OTM_01 |
Domain value mapping for state. |
TIMEZONE |
EBIZ_01, COMMON, OTM_01 |
Domain value mapping for domain timezone. |
These are the domain value mappings (DVMs) for the Training and Absence Calendar process flow:
Table 9-3 DVMs for Training and Absence Calendar
Name | Columns | Description |
---|---|---|
APPS_USER |
USER_NAME, LANG_CODE |
Domain value mapping for language code and user. |
BUSINESSGOURP_DOMAIN |
EBIZ_01, COMMON, OTM_01 |
Domain value mapping for domain names. |
CALENDAR_EVENT_TYPE |
EBIZ_01, COMMON, OTM_01 |
Domain value mapping for Absence Category/Calendar Event types. |
TIMEZONE_OFFSET |
EBIZ_01, COMMON |
Domain value mapping for timezone offset. |
These are the domain value mappings (DVMs) for the Work Invoice process flow:
Table 9-4 Work Invoice Process Flow
Names | Columns | Description |
---|---|---|
Currency_Code |
EBIZ_01, COMMON, OTM_01 |
Domain value mappings for Currency code. |
PAYABLEINVOICE_PAYABLE_STATUS |
EBIZ_01, COMMON, OTM_01 |
Domain value mappings for Payable status. |
PAYABLEINVOICE_Revenue_Class |
EBIZ_01, COMMON, OTM_01 |
Domain value mappings for Revenue class. |
UNIT_OF_MEASURE |
EBIZ_01, COMMON, OTM_01 |
Domain value mappings for UOM code. |