Skip Headers
Oracle® Application Integration Architecture Oracle Communications Order to Cash Integration Pack Implementation Guide for Siebel CRM, Oracle Order and Service Management, and Oracle Billing and Revenue Management
Release 11.2

Part Number E26501-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Feedback page
Contact Us

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

20 CM - Synchronize Customer Special Rating Profile: Implementation

This chapter describes the synchronize friends and family list updates to Oracle BRM integration flow and discusses Siebel Customer Relationship Management (Siebel CRM) and Oracle Billing and Revenue Management (Oracle BRM) interfaces, industry Oracle Application Integration Architecture (Oracle AIA) components, and integration services.

This chapter includes the following sections:

20.1 Synchronize Friends and Family List Updates to Oracle BRM Integration Flow

The synchronize friends and family list updates to Oracle BRM integration flow uses the following interfaces:

Figure 20-1 displays the synchronizing friends and family list updates to the Oracle BRM sequence of events.

Figure 20-1 Synchronizing Friends and Family List Updates

This image is described in surrounding text.

This flow has the following activities. It has a one-way asynchronous pattern.

  1. This flow starts when, because of updating the Special Rating List in Siebel CRM for an account; Siebel CRM pushes the ListOfSWISpecialRatingListIO message into an Oracle Advanced Queuing (AQ) named AIA_SPECIALRATINGJMSQ.

  2. The ProcessInstalledProductSpecialRatingSetListSiebelCommsJMSConsumer picks up this message and routes it to the ProcessInstalledProductSpecialRatingSetListSiebelCommsReqABCSImpl.

  3. The ProcessInstalledProductSpecialRatingSetListSiebelCommsReqABCSImpl transforms this message into the ProcessInstalledProductSpecialRatingSetListEBM and routes this message to the ProcessInstalledProductSpecialRatingSetListBRMCommsProvABCSImpl.

  4. The ProcessInstalledProductSpecialRatingSetListBRMCommsProvABCSImpl calls the Oracle BRM opcode PCM_OP_CUST_MODIFY_PROFILE to update this information in Oracle BRM.

20.1.1 Defining Transaction Boundaries and Recovery Details

For this flow there is one transaction boundary. Table 20-1 describes the transaction involved, the database operations, and what actions to take in case of an error.

For more information about system errors and business errors, see Section 27.5.2, "Using Error Type to Control Response to Order Fallout."

The following services are involved:

  • ProcessInstalledProductSpecialRatingSetListSiebelCommsJMSConsumer

  • ProcessInstalledProductSpecialRatingSetListSiebelCommsReqABCSImpl

  • ProcessInstalledProductSpecialRatingSetListBRMCommsProvABCSImpl

Table 20-1 Transaction Boundaries and Recovery Details

Transaction DB Operations In Case of Error Recovery

ProcessInstalledProductSpecialRatingSetListSiebelCommsJMSConsumer picks up message and routes it to ProcessInstalledProductSpecialRatingSetListSiebelCommsReqABCSImpl, which transforms message and routes to ProcessInstalledProductSpecialRatingSetListBRMCommsProvABCSImpl. The opcode is called to update information in Oracle BRM.

AIA cross-references updated.

Message goes back to the originating queue AIA_SPECIALRATINGJMSQ_ErrorQ.

Resubmit from AIA_SPECIALRATINGJMSQ_ErrorQ.


For more information about rollback procedures, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, "Configuring Oracle AIA Processes for Error Handling and Trace Logging", Configuring Fault Policies to Not Issue Rollback Messages.

20.2 Oracle BRM Interfaces

This integration flow uses the following service:

20.3 Siebel CRM Interfaces

This integration uses this Siebel CRM workflow event interface:

20.4 Industry Oracle AIA Components

This is the enterprise business message (EBM) used by this integration:

The industry enterprise business object (EBO) and enterprise business message XML schema (EBM XSD) files are located here: $AIA_HOME/AIAMetaData/AIAComponents/EnterpriseObjectLibrary/Industry/Communications/EBO/

The industry enterprise business service (EBS) WSDL files are located here: $AIA_HOME/AIAMetaData/AIAComponents/EnterpriseBusinessServiceLibrary/Industry/Communications/EBO/

For detailed documentation of individual EBOs and EBMs, click the AIA Reference Doc link on EBO and EBM detail pages in the Oracle Enterprise Repository (OER).

For more information about using the OER 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 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, so long as the extensibility guidelines are followed.

For more information, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, "Working with AIA Design Patterns," AIA Assets Extensibility Patterns, Extending Existing Schemas in AIA.

20.5 Integration Services

These services are delivered with this integration:

20.5.1 ProcessInstalledProductSpecialRatingSetListSiebelCommsJMSConsumer

The ProcessInstalledProductSpecialRatingSetListSiebelCommsJMSConsumer is implemented as a Mediator process.

This consumer listens over the AIA_SPECIALRATINGJMSQ into which Siebel enqueues the SOAP-Wrapped Siebel Special Rating List ABM. This consumer dequeues the messages from this queue, unwraps the message from the SOAP envelope, and routes the Siebel ABM to ProcessInstalledProductSpecialRatingSetListSiebelCommsReqABCSImpl

20.5.2 ProcessInstalledProductSpecialRatingSetListSiebelCommsReqABCSImpl

The ProcessInstalledProductSpecialRatingSetListSiebelCommsReqABCSImpl is a BPEL process with one operation: ProcessInstalledProductSpecialRatingSetList. This service accepts as input the Siebel SWISpecialRatingListIO and converts it to the ProcessInstalledProductSpecialRatingSetListEBM structure before routing the message to ProcessInstalledProductSpecialRatingSetListBRMCommsProvABCSImpl.

This service is invoked when an existing customer (an account exists in Siebel CRM and is synchronized to Oracle BRM) modifies the existing special rating (friends and family) profile in Siebel.

The service looks up the cross-reference values for the customer account ID and installed product ID to find common IDs to appropriately populate the EBM.

20.5.3 ProcessInstalledProductSpecialRatingSetListBRMCommsProvABCSImpl

The ProcessInstalledProductSpecialRatingSetListBRMCommsProvABCSImpl is implemented as a BPEL process with a single operation: ProcessInstalledProductSpecialRatingSetList.

This service is invoked when an existing customer (an account exists in Siebel CRM and is synchronized to Oracle BRM) modifies the existing special rating (friends and family) profile in Siebel CRM. This service synchronizes the changes in a special rating profile to Oracle BRM.

This service is the Oracle BRM ABCS implementation, which converts the ProcessInstalledProductSpecialRatingSetList into the Oracle BRM ABM before invoking the Oracle BRM opcode PCM_OP_CUST_MODIFY_PROFILE.