Siebel Communications Guide > Overview of Siebel Communications > Configuring Communications, Order-to-Cash, and Master Data Management Integration >

Oracle Advanced Queuing

Oracle Streams Advanced Queuing (AQ) is a database-integrated messaging infrastructure in Oracle database. AQ uses the functionality of the Oracle database to store messages in persistent queues. All operational benefits of the Oracle database such as high availability, scalability, and reliability are applicable to the messages and queues in AQ. Standard database features such as backup and recovery, security, and manageability are available to AQ.

AQ has been implemented for the following outbound Web services in this release:

• Special Rating List
• Submit Order
• Adjustment

The following topics contain information about how to implement AQ in your Siebel application and more detailed information about these outbound Web services.

Special Rating List

This service is used to synchronize the modified friends and family list with the external Oracle Communications Billing and Revenue Management application. It is invoked through the Synchronize button in the Special Rating list applet.

Use the following procedure to sync the modified list.

To sync the modified list

1. Navigate to Accounts screen, then Accounts List view.
2. Query for the Target Account from the list.
3. Drill down on the name of the account.
4. Navigate to the Profiles view, then the Special Rating Profile subview.
5. Query for the target special rating list and click Synchronize.

   The Synchronize button invokes the SWI Special Rating List - Synchronize Process workflow using the Named Method Business Component user property.

The SWI Special Rating - Synchronize Process workflow is a new workflow created for the AIA Comm 2.4 release. It is invoked through the Synchronize button, which is available in the Special Rating list applet (Navigate to the Accounts screen, Accounts List, Profiles, and then the Special Rating Profile view). The workflow contains the steps to query for and synchronize the updated Special Rating List with Oracle Communications Billing and Revenue Management by calling the Proxy Business Service, as follows:

Start > (Connector 0) > Query Special Rating List > Synchronize > Update List Synch Date > Update Items Synch Date > End 0

Note the following information about the SWISpecialRatingList outbound Web service:

• It is a new Web service.
• It is an asynchronous outbound Web service.
• Its namespace is http://siebel.com/asi.

This Web service is used to send the Updated/Modified Special Rating List details to Oracle Communications Billing and Revenue Management for synchronizing when the user clicks the Synchronize button in the Special Rating list applet.

This AQ and connection factories are created in FMW and the same URI must be used in outbound Web service target address.

Update Target Address

Use the following procedure to update the target address.

To update the target address

1. Navigate to the Administration - Web Services screen.
2. Navigate to the Outbound Web Services aggregate view.
3. Query for the SWISpecialRatingList service name.
4. Change the following field values in the Service Port applet:
   • Transport: JMS
   • Address: Give the AQ URL in FMW.

     (For example, jms://java:comp/resource/CommsJmsRP1/Queues/AIA_SPECIALRATINGJMSQ@java:comp/resource/CommsJmsRP1/QueueConnectionFactories/QCF)

     NOTE:  If FMW 11g is used, then the example of the address is as follows:

   jms://jms/aia/AIA_SPECIALRATINGJMSQ@jms/aia/COMMS_SPECIALRATINGLIST_CONSUMER

5. Save the record and click Clear Cache.

Submit Order Outbound Web Service

This outbound service is used to send the order details to Oracle Application Integration Architecture. The user initiates the service by clicking the Submit button on the order header form in the Order Entry view.

Use the following procedure to initiate the Submit Order outbound service.

To initiate the Submit Order outbound service

1. Navigate to the Sales Order screen, then the List view.
2. Query for the Target Sales Order.
3. Drill down on the order number of the order.
4. Click Submit.

SISOMBillingSubmitOrder Web Service Workflow

This workflow is an existing workflow that submits an order from the Siebel CRM application to the billing application and creates a new account, if needed, in the billing application. Users initiate this workflow by clicking the Submit button on the order header form in the Order Entry view.

Note the following information about the SWISubmitOrder outbound Web service:

• It is a new Web service.
• It is an outbound Web service.
• Its namespace is http://siebel.com/asi.

Use this Web service to submit orders into the queue. This AQ and connection factories are created in FMW and the same URI must be used in outbound Web service target address.

Use the following procedure to update the address:

To update the address

1. Navigate to the Administration - Web Services screen.
2. Navigate to the Outbound Web Services aggregate view.
3. Query for the SWISubmitOrder service name.
4. Change the following field values in the Service Port applet:
   • Transport: JMS
   • Address: Give the AQ URL in FMW.

     (for example, jms://java:comp/resource/CommsJmsRP1/Queues/AIA_SALESORDERJMSQUEUE@java:comp/resource/CommsJmsRP1/QueueConnectionFactories/QCF)

     NOTE:  If FMW 11g is used, then the example of the address is as follows:

   jms://jms/aia/AIA_SALESORDERJMSQUEUE@jms/aia/COMMS_SUBMITORDER_CONSUMER

5. Save the record and click Clear Cache.

SWICreateAdjustment Outbound Web Service

This outbound service is used to Submit an Adjustment request to Oracle Communications Billing and Revenue Management. Users initiate the service by clicking the Submit button on the SIA CUT Adjustment External Line Items view.

To initiate the SWICreateAdjustment outbound Web service

1. Navigate to the Billing Adjustments screen, then SIA CUT Adjustment External Line Items view.
2. Query for the particular adjustment.
3. Click Submit.

CMU SIA Submit Adjustment Request to External Workflow

This workflow has been modified as part of the Adjustment Revenue Leakage Enhancement feature. This workflow submits the Adjustment Request to the external application by invoking an outbound Web service and changing the status of Adjustment Header to Submitted. Users initiate this workflow by clicking the Submit button in the Billing Adjustments screen.

This workflow does the following:

1. Queries the adjustment request.
2. If the adjustment request is not approved, then it changes the status of the request to Pending, and terminates.
3. If the adjustment request is approved, then it reads the enterprise details, such as the enterprise server name, language, and locale.
4. Sets the enterprise details as part of the request message.
5. Makes an outbound call to the AQ.
6. Updates the Siebel database for the Adjustment Record to reflect the status as Submitted.

SWICreateAdjustment Outbound Web Service

Note the following information about the SWICreateAdjustment outbound Web service:

• It is a new Web service.
• It is an outbound Web service.
• Its namespace is http://siebel.com/asi.

Use this Web service to Submit Adjustment Request into the queue. This AQ and connection factories are created in FMW and the same URL must be used in outbound Web service target address.

Use the following procedure to update the address.

To update the address

1. Navigate to the Administration - Web Services screen.
2. Navigate to the Outbound Web Services aggregate view.
3. Query for the SWICreateAdjustment service name.
4. Change the following field values in the Service Port applet:
   • Transport: JMS
   • Address: Give the AQ URL in FMW.

     (for example, jms://java:comp/resource/CommsJmsRP1/Queues/AIA_CMUREQADJIOJMSQUEUE@java:comp/resource/CommsJmsRP1/QueueConnectionFactories/QCF)

     NOTE:  If FMW 11g is used, then the example of the address is as follows:

   jms://jms/aia/AIA_CMUREQADJIOJMSQUEUE@jms/aia/COMMS_ADJUSTMENT_CONSUMER

5. Save the record and click Clear Cache.