Skip Headers
Oracle® Application Integration Architecture Order Management Integration Pack for Oracle Transportation Management, Oracle E-Business Suite and Siebel CRM Implementation Guide
Release 3.1.1

Part Number E20504-05
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

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

These are the DVMs for the customer process flow:

Table 11-1 DVMs for the Customer Process Flow

Name Columns Description

ADDRESS_COUNTRYID

COMMON, Siebel, OTM_01

/

COMMUNICATION_METHOD

COMMON, OTM_01

Fax, Phone, and so on

CONTACT_SALUTATION

COMMON, Siebel, OTM_01

Mr., Mrs., and so on

LOCATION_ROLE

COMMON, OTM_01

Ship To, Bill To, and so on

STATE

COMMON, Siebel, OTM_01

State code


Note:

Customer flow reuses some components from Oracle Customer Master Data Management Integration, which use some more DVMs.

For more information about the Customer MDM components and DVMs being used by those components, refer Oracle Customer Master Data Management Integration - Implementation Guide.

These are the DVMs for the location process flow:

Table 11-2 DVMs for the Location Process Flow

Name Columns Description

ADDRESS_COUNTRYID

Siebel, COMMON, OTM_01

Country code

COMMUNICATION_METHOD

Siebel, COMMON, OTM_01

Phone, Fax, and so on

CONTACT_SALUTATION

Siebel, COMMON, OTM_01

Salutation of a contact

LOCATION_ROLE

COMMON, OTM_01

Ship To, Bill To, and so on

PHONENUMBER_TYPE

PHONENUMBER_TYPE

Types of Phone number

STATE

Siebel, COMMON, OTM_01

State code

TIMEZONE_ID

Siebel, COMMON, OTM_01

Time zone description

TRANSPORTATIONSTOP_TYPE

Siebel, COMMON, OTM_01

TransportationStopType


These are the DVMs for the order process flow:

Table 11-3 DVMs for the Order Process Flow

Name Columns Description

CURRENCY_CODE

SEBL_01,COMMON, OTM_01

Used to convert the Siebel Currency Data to Oracle Transportation Management (OTM) Currency Data

EQUIPMENT_TYPE

SEBL_01,COMMON, OTM_01

Equipment Type DVM

ORDER_DIVISION

SEBL_01,COMMON, OTM_01

Siebel Division Code equivalent

ORDER_STATUSCODE

SEBL_01,COMMON, OTM_01

Relates the status of the order whether it is accepted or rejected.

SHIP_DEVICE

SEBL_01,COMMON, OTM_01

Shipping Device DVM

STOP_TYPE

SEBL_01,COMMON, OTM_01

Type of Stops

TRANSPORT_MODE

SEBL_01,COMMON, OTM_01

Transport Mode DVM

TRANSPORTATIONSALESORDER_ORDERLINEITEMPROPERTY

SEBL_01,COMMON, OTM_01

Relates the Siebel Items to the OTM Items.

TRANSPORTATIONSALESORDER_PRODUCTTYPECODE

SEBL_01,COMMON, OTM_01

Relates the type of Product at the Line Item level, whether Accessorial product or Transportation product or Commodity.

TRANSPORTATIONSALESORDER_STOPACTIONTYPE

SEBL_01,COMMON, OTM_01

Relates the Stop action types.

TRANSPORTSALESORDER_PACKAGING

SEBL_01,COMMON, OTM_01

Relates the Packaging of the Items.

TRANSPORTSALESORDER_TYPE

SEBL_01,COMMON, OTM_01

Relates the CarrierRouteStopPickUp or DropOff.

UNIT_OF_MEASURE

SEBL_01,COMMON, OTM_01

Relates the Volume, Weight and Distance units compatible to OTM.


These are the DVMs for the order status process flow:

Table 11-4 DVMs for the Order Status Process Flow

Name Columns Description

ORDER_STATUS

COMMON, OTM_01, Siebel_01

Derives the status type value for one system.

TRANSPORTATIONSALESORDER_STATUSCODE

COMMON, OTM_01, Siebel_01

Derives the status values for one system.


These are the DVMs for the product process flow:

Table 11-5 DVMs for the Product Process Flow

Name Columns Description

ITEM_INDICATOR

Siebel, COMMON, OTM

Item Indicator

ITEM_TYPE.xml

Siebel, COMMON, OTM

Item type

PRODUCT_STATUS

Siebel, COMMON, OTM

Product Status

UNIT_OF_MEASURE

Siebel, COMMON, OTM

Unit of Measure


These are the DVMs for the query transportation sales order process flow:

Table 11-6 DVMs for the Query Transportation Sales Order Process Flow

Name Columns Description

Country Code in Address (ADDRESS_COUNTRYID)

SEBL_01,COMMON, OTM_01

Used to identify the Country codes in the Address.

CURRENCY_CODE

SEBL_01,COMMON, OTM_01

Currency codes

FEASIBLE_FLAG

SEBL_01,COMMON, OTM_01

Relates the Feasible Solution for the Itineraries time wise.

ITEM_TYPE

SEBL_01,COMMON, OTM_01

Relates the type of Costs associated with the itineraries.

State Code in Address (STATE)

SEBL_01,COMMON, OTM_01

Used to identify the State Code in Destination and Origin Location.

TRANSPORTATIONSALESORDER_TRANSPORTMODE

SEBL_01,COMMON, OTM_01

Relates mode of Transport for the commodities, for example, Rail, Road, and Truck.

TRANSPORTATIONSTOP_TYPE

EBL_01,COMMON, OTM_01

TransportationStopType

UNIT_OF_MEASURE

SEBL_01,COMMON, OTM_01

Relates the Weight Units, Volume units and Distance Units compatible to Oracle Transportation Management (OTM).