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-03 |
|
|
PDF · Mobi · ePub |
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). |