Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Oracle AIA Communications Pre-Built Integrations
• Common Oracle AIA Pre-Built Integration Guides
• Documentation Accessibility
• Additional Resources

What's New in This Guide for Release 11.2

1 Oracle Communications Order to Cash for Siebel CRM, Oracle OSM, and Oracle BRM Overview

• 1.1 Oracle Communications Order to Cash Overview

Part I Understanding the Delivered Integrations

2 Understanding the Process Integration for Product Lifecycle Management

• 2.1 Product Lifecycle Management Overview

3 PLM - Understanding the Synchronize Product and Price Business Flow

• 3.1 Synchronize Product and Price Business Flow Overview
  • 3.1.1 Real-Time Billing Product and Billing Discount Synchronization
  • 3.1.2 Update Real-Time Billing Product and Billing Discount Synchronization
  • 3.1.3 Batch Billing Product and Billing Discount Synchronization
  • 3.1.4 Update Batch Billing Product and Billing Discount Synchronization
• 3.2 Simple and Customizable Products
  • 3.2.1 Synchronization of Billing Products with Pricing Details
    • 3.2.1.1 Product Attributes
    • 3.2.1.2 Effective Start and End Dates
  • 3.2.2 Synchronization of Billing Discounts
  • 3.2.3 Usage Charges on Products
• 3.3 Understanding the Product Bundling Methodology
  • 3.3.1 Basic Entity Mappings
  • 3.3.2 Defining Products and Discounts in Oracle BRM
    • 3.3.2.1 Using Fixed Amounts versus Scaled Amounts in Oracle BRM
  • 3.3.3 Physical Goods
  • 3.3.4 Sales Catalogs
  • 3.3.5 Recommendations for Product Definition in Siebel CRM
    • 3.3.5.1 Recommendation for Discounts
  • 3.3.6 Service Bundles
    • 3.3.6.1 Working with Products and Nested Service Bundles
    • 3.3.6.2 Working with Nonservice Bundle Customizable Products
    • 3.3.6.3 Working with Service Bundles with a Child Non-Service Bundle Customizable Product
  • 3.3.7 Simple Service Bundles
    • 3.3.7.1 Guidelines for Using Service Bundles or Simple Service Bundles
    • 3.3.7.2 Service Bundle versus Simple Service Bundle Example
    • 3.3.7.3 Assumptions and Constraints
  • 3.3.8 Marketing Bundles
  • 3.3.9 Balance Groups
  • 3.3.10 Credit Limits
  • 3.3.11 Promotion Penalty, Service Activation, and Other MACD Charges
  • 3.3.12 Supporting Friends and Family
    • 3.3.12.1 Design Time Setup
  • 3.3.13 Product Definition Methodology for Friends and Family: Example
  • 3.3.14 Supporting Time-Based Offerings
    • 3.3.14.1 Time-Based Offerings Methodology
    • 3.3.14.2 Using Time-Based Offerings
• 3.4 Solution Assumptions and Constraints

4 PLM - Synchronize Product and Price: Implementation

• 4.1 Synchronize Product and Price Business Flow Overview
• 4.2 Product Synchronization Integration Flow
• 4.3 Billing Discount Synchronization Integration Flow
• 4.4 Oracle BRM Interfaces
• 4.5 Siebel CRM Interfaces
• 4.6 Industry Oracle AIA Components
• 4.7 Integration Services
  • 4.7.1 SyncProductBRMCommsReqABCSImpl
  • 4.7.2 SyncDiscountBRMCommsReqABCSImpl
  • 4.7.3 SyncItemCompositionListSiebelCommsProvABCSImpl
  • 4.7.4 ProductOptimizedSyncPriceListListSiebelCommsProvABCSImpl

5 PLM - Understanding the Query Product Classes Business Flow

• 5.1 Product Classes in Siebel CRM Overview
• 5.2 Design-Time Setup in SCE Studio
• 5.3 Solution Assumptions and Constraints

6 PLM - Query Product Classes: Implementation

• 6.1 Query Product Classes Overview
• 6.2 Query Product Classes - Implementation Overview
  • 6.2.1 Logical Data Model in Siebel
  • 6.2.2 Updating the Attribute Valueset
• 6.3 Support for Effectivity during Design-Time - Methodology
  • 6.3.1 Deciding on Effectivity and Cartridge Deployment
• 6.4 Query Product Classes Integration Flow
• 6.5 Siebel CRM Interfaces
• 6.6 Industry Oracle AIA Components
• 6.7 Integration Services
  • 6.7.1 QueryProdClassAndAttributesSCEReqCommsABCSImpl
  • 6.7.2 QueryClassificationListSiebelCommsProvABCSImpl
  • 6.7.3 QuerySpecificationListSiebelCommsProvABCSImpl
  • 6.7.4 QuerySpecificationValueSetListSiebelCommsProvABCSImpl

7 Understanding the Process Integration for Order Lifecycle Management

• 7.1 Order Lifecycle Management Overview
  • 7.1.1 Order Lifecycle Management Business Flows
• 7.2 Typical Topology
• 7.3 Order Capture Overview
• 7.4 Describing the Deliver Customer Order Subflow
• 7.5 Describing the Qualify Customer Order Subflow
• 7.6 Product Definition and Mapping Design Considerations
• 7.7 Data Requirements

8 OLM - Understanding the Process Sales Order Fulfillment Business Flow

• 8.1 Process Sales Order Fulfillment Overview
  • 8.1.1 New Orders
  • 8.1.2 Revision Orders
  • 8.1.3 Follow-On Orders
  • 8.1.4 Future-Dated Orders
• 8.2 Supporting Order Priorities
• 8.3 Solution Assumptions and Constraints

9 OLM - Process Sales Order Fulfillment Business Flow: Implementation

• 9.1 Process Sales Order Fulfillment Business Flow Overview
• 9.2 Submitting Orders from Siebel CRM to Oracle OSM Integration Flow
  • 9.2.1 Defining Transaction Boundaries and Recovery Details
• 9.3 Supporting Order Priorities
• 9.4 Siebel CRM Interfaces
• 9.5 Industry Oracle AIA Components
• 9.6 Integration Services
  • 9.6.1 ProcessSalesOrderFulfillmentSiebelCommsJMSConsumer
  • 9.6.2 ProcessSalesOrderFulfillmentSiebelCommsReqABCSImpl
  • 9.6.3 ProcessSalesOrderFulfillmentOSMCFSCommsJMSProducer

10 OLM - Understanding the Synchronize Fulfillment Order Billing Account Business Flow

• 10.1 Synchronize Fulfillment Order Billing Account Overview
• 10.2 Solution Assumptions and Constraints

11 OLM - Synchronize Fulfillment Order Billing Account Business Flow: Implementation

• 11.1 Synchronize Fulfillment Order Billing Account Business Flow Overview
• 11.2 Interfacing Orders to Create Customer Data in Oracle BRM
  • 11.2.1 Defining Transaction Boundaries and Recovery Details
• 11.3 Oracle BRM Interfaces
• 11.4 Industry Oracle AIA Components
• 11.5 Integration Services
  • 11.5.1 ProcessFulfillmentOrderBillingAccountListOSMCFSCommsJMSConsumer
  • 11.5.2 CommsProcessFulfillmentOrderBillingAccountListEBF
  • 11.5.3 CommsProcessBillingAccountListEBF
  • 11.5.4 ProcessFulfillmentOrderBillingAccountListResponseOSMCFSCommsJMSProducer

12 OLM - Understanding the Bill Fulfillment Order Business Flow

• 12.1 Bill Fulfillment Order Overview
• 12.2 Interfacing Orders to Oracle BRM
• 12.3 Supporting Simple Service Bundles
  • 12.3.1 Cross-Reference Impact
• 12.4 Supporting Single Phase versus Two-Phase Billing
  • 12.4.1 Considerations for using the Single Phase versus the Two Phase Billing Pattern
  • 12.4.2 Using the Single Phase versus the Two Phase Billing Pattern
    • 12.4.2.1 INITIATE BILLING Mode
    • 12.4.2.2 FULFILL BILLING Mode
  • 12.4.3 Assumptions and Constraints for Two-Phase Billing
• 12.5 Supporting Revisions
  • 12.5.1 Assumptions and Constraints for Revisions
• 12.6 Supporting Time-Based Offerings
  • 12.6.1 Assumptions and Constraints for Time-Based Offerings
• 12.7 Supporting Friends and Family Lists
  • 12.7.1 Using Change Orders and Special Rating Products
  • 12.7.2 Modifying Friends and Family List
• 12.8 Solution Assumptions and Constraints

13 OLM - Bill Fulfillment Order Business Flow: Implementation

• 13.1 Bill Fulfillment Order Business Flow Overview
• 13.2 Interfacing Orders to Create Transaction Data in Oracle BRM
  • 13.2.1 Defining Transaction Boundaries and Recovery Details
• 13.3 Oracle BRM Interfaces
• 13.4 Industry Oracle AIA Components
• 13.5 Integration Services
  • 13.5.1 ProcessFulfillmentOrderBillingOSMCFSCommsJMSConsumer
  • 13.5.2 ProcessFulfillmentOrderBillingBRMCommsProvABCSImpl
  • 13.5.3 ProcessFulfillmentOrderBillingBRMCommsAddSubProcess
  • 13.5.4 ProcessFulfillmentOrderBillingBRMCommsMoveAddSubProcess
  • 13.5.5 ProcessFulfillmentOrderBillingBRMCommsSuspendResumeSubProcess
  • 13.5.6 ProcessFulfillmentOrderBillingBRMCommsUpdateSubProcess
  • 13.5.7 ProcessFulfillmentOrderBillingBRMCommsDeleteSubProcess
  • 13.5.8 ProcessFulfillmentOrderBillingResponseOSMCFSCommsJMSProducer

14 OLM - Understanding the Provision Order and Update Fulfillment Order Business Flows

• 14.1 Order Provisioning Overview
• 14.2 Creating Provisioning Orders
• 14.3 Updating Fulfillment Orders
• 14.4 Solution Assumptions and Constraints

15 OLM - Provision Order and Update Fulfillment Order Business Flows: Implementation

• 15.1 Provision Order and Update Fulfillment Order Business Flows Overview
• 15.2 Oracle OSM Fulfillment to Oracle OSM Provisioning Integration Flow
  • 15.2.1 Defining Transaction Boundaries and Recovery Details
• 15.3 Industry Oracle AIA Components
• 15.4 Integration Services
  • 15.4.1 ProcessProvisioningOrderOSMCFSCommsJMSConsumer
  • 15.4.2 ProcessProvisioningOrderOSMPROVCommsJMSProducer
  • 15.4.3 ProcessFulfillmentOrderUpdateOSMPROVCommsJMSConsumer
  • 15.4.4 ProcessFulfillmentOrderUpdateOSMCFSCommsJMSProducer

16 OLM - Understanding the Update Sales Order Business Flow

• 16.1 Update Sales Order Overview
• 16.2 Updating the Sales Order Data
• 16.3 Updating the Sales Order Status
• 16.4 Creating or Updating Installed Assets in Siebel CRM

17 OLM - Update Sales Order Business Flow: Implementation

• 17.1 Update Sales Order Business Flow Overview
• 17.2 Updating Statuses from Oracle OSM to Siebel CRM Integration Flow
  • 17.2.1 Defining Transaction Boundaries and Recovery Details
• 17.3 Siebel CRM Interfaces
• 17.4 Industry Oracle AIA Components
• 17.5 Integration Services
  • 17.5.1 UpdateSalesOrderOSMCFSCommsJMSConsumer
  • 17.5.2 UpdateSalesOrderSiebelCommsProvABCSImpl

18 Understanding the Process Integration for Customer Management

• 18.1 Customer Management Process Integration Overview
• 18.2 Solution Assumptions and Constraints
• 18.3 Data Requirements
• 18.4 Synchronize Customer Account Business Flow
  • 18.4.1 Create/Sync Account Integration Flow
  • 18.4.2 Update Customer Account Integration Flow
    • 18.4.2.1 Account Status Synchronization Methodology
• 18.5 Synchronize Customer Special Rating Profile Business Flow

19 CM - Synchronize Customer Account: Implementation

• 19.1 Create/Sync Customer Account Integration Flow
• 19.2 Update Customer Accounts Integration Flow
• 19.3 Oracle BRM Interfaces
• 19.4 Siebel CRM Interfaces
• 19.5 Industry Oracle AIA Components
• 19.6 Integration Services
  • 19.6.1 ProcessFulfillmentOrderBillingAccountListOSMCFSCommsJMSConsumer
  • 19.6.2 CommunicationsCustomerPartyEBSV2Resequencer
  • 19.6.3 CommsProcessFulfillmentOrderBillingAccountListEBF
  • 19.6.4 CommsProcessBillingAccountListEBF
  • 19.6.5 SyncCustomerSiebelEventAggregator
  • 19.6.6 SyncAccountSiebelAggregatorAdapter
  • 19.6.7 SyncContactSiebelAggregatorAdapter
  • 19.6.8 SyncAddressSiebelAggregatorAdapter
  • 19.6.9 SyncBPSiebelAggregatorAdapter
  • 19.6.10 SyncAcctSiebelAggrEventConsumer
  • 19.6.11 SyncAccountSiebelReqABCSImpl
  • 19.6.12 CustomerPartyEBSV2
  • 19.6.13 QueryCustomerPartyListSiebelProvABCSImplV2
  • 19.6.14 SyncCustomerPartyListBRMCommsProvABCSImpl
  • 19.6.15 SyncCustomerPartyListBRM_01CommsJMSConsumer

20 CM - Synchronize Customer Special Rating Profile: Implementation

• 20.1 Synchronize Friends and Family List Updates to Oracle BRM Integration Flow
  • 20.1.1 Defining Transaction Boundaries and Recovery Details
• 20.2 Oracle BRM Interfaces
• 20.3 Siebel CRM Interfaces
• 20.4 Industry Oracle AIA Components
• 20.5 Integration Services
  • 20.5.1 ProcessInstalledProductSpecialRatingSetListSiebelCommsJMSConsumer
  • 20.5.2 ProcessInstalledProductSpecialRatingSetListSiebelCommsReqABCSImpl
  • 20.5.3 ProcessInstalledProductSpecialRatingSetListBRMCommsProvABCSImpl

21 Understanding the Process Integration for Order Fallout Management

• 21.1 Order Fallout Management Process Integration Overview
  • 21.1.1 Order Fallout Detection
  • 21.1.2 Order Fallout Notification
  • 21.1.3 Order Correction
• 21.2 How Oracle AIA Error Handling Framework Captures Faults
• 21.3 Order Fallout Management Process Integration Business Flows
  • 21.3.1 Create Trouble Ticket from Oracle AIA Business Flow
    • 21.3.1.1 Solution Assumptions and Constraints
  • 21.3.2 Create and Manage Trouble Ticket from Oracle OSM Business Flow
    • 21.3.2.1 Solution Assumptions and Constraints
• 21.4 Extending Fault Messages to Capture Order Fallout Information
  • 21.4.1 Exception Handling

22 OFM - Create Trouble Ticket from Oracle AIA Business Flow: Implementation

• 22.1 Creating Trouble Tickets in Siebel CRM from Oracle AIA Overview
• 22.2 Creating a Trouble Ticket in Siebel CRM Integration Flow
  • 22.2.1 Defining Transaction Boundaries and Recovery Details
  • 22.2.2 Exception Handling
• 22.3 Siebel CRM Interfaces
• 22.4 Industry Oracle AIA Components
• 22.5 Integration Services
  • 22.5.1 CreateTroubleTicketSiebelCommsProvABCSImpl
  • 22.5.2 AIAOrderFalloutJMSBridgeService
  • 22.5.3 AIACOMOrderFalloutNotificationJMSConsumer
  • 22.5.4 CreateTroubleTicketAIACommsReqImpl
  • 22.5.5 AIAOrderFalloutErrorHandlerExtension - Java Class
• 22.6 Business Flow Fallout-Enabled Services

23 OFM - Create and Manage Trouble Ticket from Oracle OSM Business Flow: Implementation

• 23.1 Creating Trouble Tickets in Siebel CRM from Oracle OSM Overview
• 23.2 Order Failure Notification to Oracle OSM Integration Flow
• 23.3 Creating a Trouble Ticket in Siebel CRM from Oracle OSM Integration Flow
  • 23.3.1 Defining Transaction Boundaries and Recovery Details
• 23.4 Updating a Trouble Ticket in Siebel CRM from Oracle OSM Integration Flow
  • 23.4.1 Defining Transaction Boundaries and Recovery Details
• 23.5 Siebel CRM Interfaces
• 23.6 Industry Oracle AIA Components
• 23.7 Integration Services
  • 23.7.1 UpdateTroubleTicketSiebelCommsProvABCSImpl
  • 23.7.2 CreateOrderFalloutNotificationOSMCFSCommsProvImpl
  • 23.7.3 CreateOrderFalloutNotificationOSMCFSCommsJMSConsumer
  • 23.7.4 CreateOrderFalloutNotificationOSMCFSCommsJMSProducer
  • 23.7.5 CreateTroubleTicketOSMCFSCommsJMSConsumer
  • 23.7.6 CreateTroubleTicketRespOSMCFSCommsJMSProducer
  • 23.7.7 UpdateTroubleTicketOSMCFSCommsJMSConsumer
  • 23.7.8 CreateFaultNotificationLFCommsJMSConsumer
• 23.8 Business Flow Fallout-Enabled Services

Part II Implementing the Delivered Integrations

24 Configuring the Process Integration for Product Lifecycle Management

• 24.1 Prerequisites
• 24.2 Setting Up Oracle BRM
• 24.3 Configuring Siebel CRM to Integrate with Oracle AIA for Communications
• 24.4 Working with DVMs
• 24.5 Working with Cross-References
• 24.6 Handling Error Notifications
  • 24.6.1 Describing Delivered Error Notification Roles and Users
• 24.7 Configuring Properties in the AIAConfigurationProperties File
  • 24.7.1 Configuring Properties for the Product Lifecycle Management Feature
  • 24.7.2 Configuring Properties for the Query Product Class Feature

25 Configuring the Process Integration for Order Lifecycle Management

• 25.1 Setting Up Oracle BRM
• 25.2 Configuring Siebel CRM to Integrate with Oracle AIA for Communications
• 25.3 Working with DVMs
• 25.4 Working with Cross-References
• 25.5 Handling Error Notifications
  • 25.5.1 Describing Delivered Error Notification Roles and Users
• 25.6 Configuring the Process Integration for Order Lifecycle Management

26 Configuring the Process Integration for Customer Management

• 26.1 Setting Up Oracle BRM
• 26.2 Configuring Siebel CRM to Integrate with Oracle AIA for Communications
• 26.3 Working with DVMs
• 26.4 Working with Cross-References
• 26.5 Handling Error Notifications
  • 26.5.1 Describing Delivered Error Notification Roles and Users
  • 26.5.2 Order Fallout Management
• 26.6 Configuring the Process Integration for Customer Management

27 Configuring the Process Integration for Order Fallout Management

• 27.1 Setting Up Oracle AIA
• 27.2 Configuring Siebel CRM to Integrate with Oracle AIA for Communications
• 27.3 Working with DVMs
• 27.4 Working with Cross-References
• 27.5 Handling Error Notifications
  • 27.5.1 Describing Delivered Error Notification Roles and Users
  • 27.5.2 Using Error Type to Control Response to Order Fallout
• 27.6 Configuring Properties for Order Fallout Services

A PLM - Cross-References for the Process Integration for Product Management

• A.1 Integration Solution Cross-References
  • A.1.1 Cross-Reference Values
• A.2 Product Synchronization Flow
  • A.2.1 Simple Product Synchronization Example
  • A.2.2 Complex Product Synchronization Example
• A.3 Discount Synchronization Flow
  • A.3.1 Discount Synchronization Example

B OLM - Communications Orders Dictionary

• B.1 Communications Orders - Order Header Component Attributes
• B.2 Communications Orders - Order Line Component Attributes

C OLM - Mapping Billing Dates

• C.1 How Dates are Set in Oracle BRM

D OLM Bill Fulfillment Order - Matrix of MACD Actions Supported Per Billing Product Type

• D.1 Table A
• D.2 Table B
  • D.2.1 Table B Notes

E OLM - Examples of Changing the Paying Parent on Subordinate Accounts

• E.1 Scenario One - Supported
• E.2 Scenario Two - Supported
• E.3 Scenario Three - Supported (with caveats)

F Configuring Multiple Oracle BRM Instances for Communications Integrations

• F.1 Understanding System Codes in Oracle AIA
• F.2 Configuring Multiple Oracle BRM Instances - General Steps
  • F.2.1 Creating a New Consumer for Product Synchronization
  • F.2.2 Creating a New Consumer for Discount Synchronization
  • F.2.3 Creating a New Consumer for Customer Updates
• F.3 Creating a Data Source and Connection Factory
• F.4 Creating Logical Instances in Oracle AIA
• F.5 Creating Service Bundles in Siebel CRM
• F.6 Merging Logical Oracle BRM Instances into a Single Oracle BRM Instance

G OLM - Reconfiguring Oracle AIA for Communications

• G.1 Reconfiguring Oracle AIA for Communications Overview
• G.2 Changing the Oracle BRM Instance

H Expectations from a COM System for Billing Integration

I Using the Oracle Mediator Resequencer Feature

• I.1 Queues and Flows Enabled for Sequencing
• I.2 Resolving Errors in Flows with Resequencer

J OLM - Guidelines for Ensuring that Oracle AIA Processes are Fallout-Compliant

• J.1 Populating Sender Context Information in the EBM Header
• J.2 Populating the Enriched Fault Message with Business Faults
• J.3 Populating the Enriched Fault Message in Services without EBMs

K Composite Application Validation System Changes

• K.1 Configuration Properties for CAVS Enablement in 11.1
• K.2 Configuration Properties for CAVS Enablement in 11.2
  • K.2.1 Requestor ABCS
  • K.2.2 Provider ABCS

L Reintroducing Enterprise Business Services

Index