Skip Headers
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
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

9 Working with Domain Value Maps

This chapter provides domain value mapping information for these process integration flows:

9.1 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 Pack, Working with Message Transformations. and Oracle Fusion Middleware Developer's Guide for Oracle SOA Suite, Working with Domain Value Maps.

9.1.1 Driver Profiles Process Flow

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.


9.1.2 Location Process Flow

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.


9.1.3 Training and Absence Calendar Process Flow

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.


9.1.4 Work Invoice Process Flow

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.