|Oracle® Application Integration Architecture Order Management Integration Pack for Oracle Transportation Management, Oracle E-Business Suite and Siebel CRM Implementation Guide
Part Number E20504-05
|PDF · Mobi · ePub|
This chapter provides an overview of the process integration for customers and includes the following sections:
The process integration for creating and synchronization of customer accounts between Siebel, E-Business Suite, and Oracle Transportation Management (OTM) involves these integrations:
Synchronize create account from Siebel CRM to OTM and Oracle E-Business Suite.
Synchronize update account from Siebel CRM to OTM and Oracle E-Business Suite.
Customers are important for any transportation order. In Siebel, the customers are created as accounts. These accounts must be in OTM for execution of the order and the same accounts must be in Oracle E-Business Suite for billing purpose.
In this integration, Siebel sends accounts to OTM and Oracle E-Business Suite. Whenever a new account is created in Siebel, a real-time synchronization flow is initiated to synchronize it to a customer account in Oracle E-Business Suite. A new location and the corresponding corporation are created in OTM simultaneously for that Siebel account.
The addresses of the Siebel account are synchronized to Oracle E-Business Suite to create locations, party sites, and account sites are synchronized as separate locations in OTM. The Bill To and Ship To address relationships from Siebel are synchronized to Party Site Use and Account Site Use in Oracle E-Business Suite and to Location Roles in OTM.
If an update to a customer record or any of the details, for example, addresses, contacts occurs in Siebel, the updated account record is synchronized to both OTM and Oracle E-Business Suite.
Siebel application can send one of these messages:
Account Message - This message contains the details about an account and its associated addresses and contacts. This message is sent to SyncAccountSiebelReqABCSImpl requester process. The requester process converts the message to SyncCustomerPartyListEBM and sends it to CustomerPartyEBS. From enterprise business service (EBS), the message then flows through the OTM provider and E-Business Suite provider to create the entries in the respective systems.
Address Message - This message comes to application integration architecture (AIA) layer when an address is modified in Siebel. Siebel sends an address message that contains the changed address data and all the associated accounts and locations for that address. Master data management (MDM) code then deciphers that message, picks up the associated accounts, and for each account it creates an account message and sends it to the MDM account requester. The requester then processes the message in the same manner as described in account message.
Contact Message - This message comes to AIA layer when a contact is modified in Siebel. Siebel sends a contact message that contains the changed contact data and all the associated accounts and locations for that contact. The MDM code then deciphers that message, picks up the associated accounts, and for each account it creates an account message and sends it to the MDM account requester. The requester then processes the message in the same manner as described in account message.
These are the solution assumptions and constraints:
Only B2B (business to business) scenarios are supported. B2C (business to customer) scenarios are not supported.
Siebel contacts are synchronized as account contacts to Oracle E-Business Suite, and not as person parties in Oracle E-Business Suite; however, contacts related to synced locations are synced to OTM.
Deletion of accounts, contacts, or address associated to a customer is not supported in the synchronization.
If any error occurs and the customer message does not reach the target application, then AIA error handling framework notifies you. You should then manually re-submit that transmission that failed for re-processing.
This integration does not perform any business validation and thus does not raise errors for business data issues.
The customer integration only supports the synchronization of accounts (and its addresses and contacts).
Contacts can be shared across to multiple accounts in Siebel. In OTM, the same contact cannot be associated to multiple locations. Thus, if a contact is associated to two different locations in Siebel, then the same contact is created twice in OTM for each location.
Prospect contacts are not synchronized from Siebel.
Account hierarchy synchronization is not in the scope of this release.
The process integration pack for Oracle Customer Hub master data management is used for transformation from Siebel to enterprise business object (EBO) and Oracle E-Business Suite provider (EBO to Oracle E-Business Suite) transformation.
OTM domain value is derived from business unit mapping in cross-references. If you want to use a specific logic for deriving the domain, you must use the extensible transformation template.
The OTM specific columns in cross-references are populated based on the identifiers derived in the OTM connector. If you want to pass a different value in the OTM identifier, you can use the transformation's extensibility to update the cross-reference as well.
The direction of data flow is only from Siebel to OTM and Oracle E-Business Suite. The reverse data flow is not supported in this integration. If any customer data is modified or created in OTM or Oracle E-Business Suite, those changes are not reflected in Siebel. Any subsequent synchronization of the same data from Siebel to OTM or Oracle E-Business Suite may overwrite the changes made in OTM or Oracle E-Business Suite.
The schemas available for this outbound integration from Siebel are:
Change Address schema
Change Contact schema
For more information about Siebel customer WSDL and schema definition, see Oracle Customer Master Data Management Integration documentation.
For more information about Oracle E-Business Suite web services definition language (WSDL) and schema definition, see Oracle Customer Master Data Management Integration documentation.
For more information about Oracle E-Business Suite web services and documentation prior to Release 12.1.3, see the library on Oracle Technology Network:
http://www.oracle.com/technetwork/documentation/applications-167706.html?. For Oracle E-Business Suite documentation for R12.1.3 and beyond, see this library:
The Oracle Transportation Management (OTM) provides an interface through a web service to connect to its application. This connectivity is established as a partner link in the provider service. The logistics web service on being called immediately returns an acknowledgment with a transmission number. When the processing is complete, it then sends a transmission report back indicating the success or the failure.
For more information about the Logistics Service, see Oracle Transportation Management Integration Guide.
The integration flow uses these components:
The core enterprise business object (EBO) and enterprise business message (EBM) XSD files can be located by EBO within the $AIA_HOME/AIAMetaData/AIAComponents/EnterpriseObjectLibrary/Core/EBO/ parent folder.
The core enterprise business services (EBS) web services definition language (WSDL) files can be located by EBO within the $AIA_HOME/AIAMetaData/AIAComponents/EnterpriseBusinessServiceLibrary/Core/EBO/ parent folder.
For detailed documentation of individual EBOs and EBMs, click AIA Reference Doc link on EBO and EBM detail pages in the Oracle Enterprise Repository.
For more information about using the Oracle Enterprise Repository and configuring it to provide the AIA Reference Doc link, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, "Configuring and Using Oracle Enterprise Repository as the Oracle AIA SOA Repository."
EBOs can be extended, for instance, to add new data elements. These extensions are protected and remain intact after a patch or an upgrade.
For more information, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, "Extensibility for AIA Artifacts.
The services delivered with the customer process integration are:
The SyncCustomerPartyListLogisticsProvABCSlmpl service is a Business Process Execution Language (BPEL) process that receives SyncCustomerPartyListEBM as input from CustomerPartyListLogisticsJMSConsumerV1, transforms that message to Logistics application business message (ABM), and calls the Oracle Transportation Management (OTM) web service to process that message in OTM. Cross-reference values are populated upon successful message processing.
A JMS topic receives a message from the customer party EBS and routes it to both OTM connector and Oracle E-Business Suite connector. The topic is created in the AIA database under the user JMSUSER. The topic name is AIA_CustomerPartyJMSTV1.
This service publishes the SyncCustomerPartyListEBM JMS message from EBS into the topic.
This is a mediator service with JMS Adapter and a routing rule. It accepts SyncCustomerPartyListEBM as input from CustomerPartyEBSV2. The received Customer Party List enterprise business message (EBM) payload message is published into the JMS Topic AIA_CustomerPartyJMSTV1.
SyncCustomerPartyEbizJMSConsumerV1service is a subscriber to the topic that dequeues the SyncCustomerPartyListEBM JMS message from the JMS Topic for Oracle E-Business Suite connector.
This is a mediator service with JMS Adapter. This adapter dequeues the SyncCustomerPartyListEBM message for the subscribed consumer from the JMS Topic AIA_CustomerPartyJMSTV1 and routes the message to the SyncCustomerPartyListEbizProvABCSImpl provider service.
SyncCustomerPartyLogisticsJMSConsumerV1 service is the other subscriber of the topic that dequeues the SyncCustomerPartyListEBM JMS message from the topic for logistics connector.
This is a mediator service with JMS Adapter. This adapter dequeues the SyncCustomerPartyListEBM message for the subscribed consumer from the JMS Topic AIA_CustomerPartyJMSTV1 and routes to the SyncCustomerPartyListLogisticsProvABCSImpl.