Oracle® Application Integration Architecture Oracle Order Management for Oracle Transportation Management, Oracle EBS, and Siebel CRM Implementation Guide Release 3.1.1 Part Number E20504-07 |
|
|
PDF · Mobi · ePub |
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, "Working with Message Transformations" and Oracle Fusion Middleware Developer's Guide for Oracle SOA Suite, "Working with Domain Value Maps."
This section provides a listing of all the DVMs for each of the Oracle Order Management Integration Pack for Oracle Transportation Management, Oracle E-Business Suite, and Siebel CRM process flows.
Table 11-1 lists 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.
Table 11-2 lists 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 |
Table 11-3 lists 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. |
Table 11-4 lists 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. |
Table 11-5 lists 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 |
Table 11-6 lists 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). |