Skip Headers
Oracle® Application Integration Architecture Installation and Upgrade Guide for Pre-Built Integrations
Release 11.3

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

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

4 Configuring and Deploying the Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration

This chapter discusses how to configure and deploy the Siebel CRM Integration Pack for Oracle Communications Billing and Revenue Management: Agent Assisted Billing Care (Comms Agent Assisted Billing Care: SBL CRM - BRM).

This chapter includes the following sections:

4.1 Creating Oracle Data Integrator Repositories

Prerequisite/Assumption: The Master Repository and the Work Repository are created in ODI.

You need not create a master repository. You can use an existing master repository if it exists on an Oracle database and the ID is between 126 and 999. If you are creating a new master repository, ensure that the repository ID is between 126 and 999.

You can use an existing work repository if it exists on an Oracle database and its ID is between 126 and 999. If its ID is not in that range, AIA advises you to create a repository with an ID between 126 and 999.

Table 4-1 details a list of ids you must avoid when creating master and work repositories.

Table 4-1 Prohibited IDs

Master Repository IDs Work Repository IDs

219

129

999

239

-

543


When you run the DCW, it inserts or updates the integration artifacts into these repositories.

AIA recommends that you take a backup of master and work repositories before you start the install process.

For information about creating Oracle Data Integrator Master and Work repositories, see the Oracle Data Integrator Installation Guide, "Creating Repositories."

4.2 Deployment Configuration Wizard

The DCW screens prompt you to enter the data required for successful configuration of the Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration. Enter the details of the Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration screens below, take a printout and keep it ready when you run the DCW. This action enables faster and error free configuration.

4.2.1 Integration Server Details Screen

All artifacts associated with the integration infrastructure components are deployed to the integration server. This screen contains the following fields:

Table 4-2 Integration Server Details Screen Fields

Field Description

Admin Host Name

This is where the admin server resides. This can be a remote server or the same computer where the AIA Pre-Built Integrations Installer is launched. Example: server1.company.com.

The Admin Host Name is _________________________________

Admin Port

This is the port number on which Weblogic Admin server is started. To find this value contact WebLogic administrator. Example: 7001.

The Admin Port is _____________________________________

Domain Name

This is WebLogic server domain corresponding to the Admin Server. Example: domain1

The Domain Name is _____________________________________

Admin User

This value is the WebLogic admin user name. To find this value contact your WebLogic administrator.

The Admin User is __________________________________

Admin Password

This value is the WebLogic admin password. To find this value contact your WebLogic administrator.

The Admin Password is _____________________________________

Managed Server

After you enter the Admin Host name, Admin Port, Domain Name, Admin user name and Admin Password, this field gets populated with managed servers for the domain. Select the manager server from the list. If you are deploying the integration to a SOA cluster, you should select the cluster name in this field.

The Managed Server is _______________________________

Managed Port

This field gets updated automatically after you select the managed server. If you have configured a SOA Cluster the SOA Cluster port appears in the list.


4.2.2 Siebel CRM Server Details Screen

Use this screen to enter details related to your Siebel CRM server instance. The screen contains the following fields:

Table 4-3 Siebel CRM Server Details Screen Fields

Field Description

Siebel Host name

This is a computer name of the Siebel host. For example: example1.corp.siebel.com. To find the value, contact your administrator.

Siebel Host name is _____________________________

Siebel HTTP Port

This value is the Siebel application port. For example: 80. To find the value, contact your administrator.

Siebel HTTP Port is ________________________________

InternetProtocol

This value is the Siebel host internet protocol. For example, http://. To find the value, contact your administrator.

InternetProtocol is _______________________

Note: Our internal environments are always on http://. The default value is https// and must be changed for Siebel web services and Session Pool Manager services to work.

Siebel Enterprise Server Name

This value is the Siebel enterprise server name. For example, siebel. To find the value, contact your administrator.

Siebel Enterprise Server Name is _________________________

Note: This value must be in lowercase (siebel) for the Update Account flow to work.

Siebel EAI Application User

The Siebel application user is used for making EAI web service calls. For example: sadmin. To find the value, contact your administrator.

Siebel EAI Application User is ___________________________

Siebel EAI Application Password

This is the password for the EAI user. For example: sadmin. To find the value, contact your administrator.

Siebel EAI Application Password is ________________________

Siebel Version

Version of application, for example Siebel 8.1.1 SIA. To find the value, contact your administrator. Kindly ensure that the value is only 10 character long.

Siebel Version is __________________________

Siebel Language

This is the language used by the Siebel application. For example, enu. To find the value, contact your administrator.

Siebel Language is ________________________


4.2.3 Siebel CRM Database Details Screen

Use this screen to enter details related to your Siebel CRM database instance. The screen contains the following fields:

Table 4-4 Siebel CRM Database Details Screen Fields

Field Description

Siebel Database Host

This value is typically the computer name. For example: server1.oracle.com. To find the value, contact your database administrator.

Siebel Database Host is _________________________________

Siebel Database Port

This is the Siebel database port. For example: 1521. To find the value, contact your database administrator.

Siebel Database Port is _________________________________

Siebel Database SID

This is the Siebel database system ID. For example: qa7a. To find the value, contact your database administrator.

Siebel Database SID is ________________________________

Siebel Database Username

Specifies a database user that has access to loading the EIM tables Siebel. To find this value, contact the database administrator. Example: ora12345

Siebel Database Username is ______________________

Siebel Database Password

This is the Siebel Database Password. For example: ora07103. To find the value, contact your database administrator.

Siebel Database Password is _____________________


4.2.4 Oracle Communications BRM Screen

Use this screen to enter details related to your Oracle Communications BRM instance. The screen contains the following fields:

Table 4-5 Oracle Communications BRM Details Screen

Field Description

Primary CM Host Name

This is the host name of the primary Connection Manager (CM) of the BRM server. For example: example1.portal.com To find this value, contact your Oracle AQ system administrator.

Primary CM Host Name is ______________________________

Primary CM Port Number

This is the port number of primary Connection Manager (CM) of the BRM server. For example: 12600. To find this value contact your Oracle AQ database administrator System Administrator

Primary CM Port Number is ______________________________

Database Host

This is the database host name of the Oracle AQ for which the BRM DM_AQ is configured. For example: example2.portal.com. To find this value, contact your Oracle AQ database administrator.

Database Host is _______________________

Database Port

This is the database port number of the Oracle AQ. For example: 1521. To find this value, contact your Oracle AQ database administrator.

Database Port is _________________________

Oracle AQ Database SID

This is the database instance of the Oracle AQ. For example: orcl. To find this value, contact your Oracle AQ database administrator.

Oracle AQ Database SID is _______________________________

Oracle AQ Username

This is the database user name of the Oracle AQ. For example, PIN7820. To find this value, contact your Oracle AQ administrator.

Oracle AQ Username is _________________________

Note: This value must be in uppercase (PIN7820) for the OOTB PLM flow to work.

Oracle AQ Password

This is the database password of the Oracle AQ. To find this value, contact your Oracle AQ administrator.

Oracle AQ Password is ___________________________

AQ Queue Name

This is the queue name configured for the BRM DM_AQ. For example: AqportalUser. To find this value, contact your Oracle AQ database administrator.

AQ Queue Name is _________________________________


4.2.5 Oracle Data Integrator Access Information Details Screens

Use these screens to enter details to access Oracle Data Integrator. These screens contain the following fields:

Table 4-6 Oracle Data Integrator Access Information Details Screens Fields

Field Description

Path to Oracle Data Integrator

Provide the path to the ODI_HOME up to the oracledi/agent folder (included).

To find this value, contact your administrator. Example: /slot/ems8141/oracle/ODI11113/oracledi/agent for Linux and C\odi\oracledi\agent for Windows.

Path to Oracle Data Integrator is ___________________________

Path for exported DVMs

Enter the path of the directory to export Domain Value Mappings (DVM). DVM folder gets created along with Foundation Pack installation. If you have installed Foundation Pack use $AIA_HOME/AIAMetaData/dvm.

If you are installing the integration along with Foundation Pack for the first time, create a temporary folder for the DVMs. DVM are exported to this location.

If you want to change the path to reflect the above location, open AIAInstallProperties.xml file from $AIA_INSTANCE/config post installation, search for odi.dvm.path and replace the temporary folder path with the above location.

Path for exported DVMs is ______________________________

ODI Username

To find this value, contact your administrator. Example: SUPERVISOR.

ODI Username is ____________________________________

ODI User Password

To find this value, contact your administrator. Example: SUNOPSIS

ODI User Password is _________________________________


4.2.6 Oracle Data Integrator Master Repository Details Screen

You must set up an ODI Master Repository before installing the Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration. This master repository must be created in an Oracle database.

Caution:

If you are using either a new master repository or an existing master repository, you must ensure that the identifier for that repository is between 126 and 999.

The install process appends integration artifacts into this master repository.

Use this screen to enter details to access the Oracle Data Integrator Master Repository. If the Master repository is configured, field values in the screen are populated automatically.

The screen contains the following fields:

Table 4-7 Oracle Data Integrator Master Repository Details Screen Fields

Field Description

Database Host

To find this value, contact your database administrator. Example: server1.oracle.com

Database Host is_______________________________

Database Port

To find this value, contact your database administrator. Example: 1521

Database Port is________________________________

Database SID

To find this value, contact your database administrator. Example: oracle

Database SID is__________________________________

Database Username

To find this value, contact your database administrator. Example: snpm

Database Username is_______________________________

Database Password

To find this value, contact your database administrator. Example: snpm

Database Password is_________________________________


4.2.7 Oracle Data Integrator Work Repository Details for Agent Assisted Billing Care Screen

The install process imports the collections flow ODI artifacts into an ODI Work Repository. You can provide an existing ODI Work Repository or provide an empty one. It is recommended that you use an empty repository.

Caution:

If you are creating either an existing work repository or a new work repository, you must ensure that the repository is created with an ID between 126 and 999.

Use this screen to enter details related to the ODI Work Repository. If the Master repository is configured, field values in the screen are populated automatically.

The screen contains the following fields:

Table 4-8 Oracle Data Integrator Work Repository Details for Agent Assisted Billing Care Screen Fields

Field Description

ODI Work Repository Name

Enter the name you gave to the ODI Work Repository for integration Artifacts. Example: WORKREP

ODI Work Repository Name is ___________________________

ODI Work Repository ID

Enter the ID number that you used for the ODI Work Repository.

ODI Work Repository ID is ______________________________


4.2.8 Session Pool Manager Details Screen

The Session Pool Manager (SPM) details are optional and required only when your Siebel server is outside of the firewall. If all your servers are within the network, leave these fields blank.

In the java.net application programming interface (API) used by SPM, proxies are supported through two system properties: http.proxyHost and http.proxyPort. They must be set to the proxy server and port respectively. This value is only set when ProxySettings_Enabled is set to TRUE.

Table 4-9 Session Pool Manager Details Screen Fields

Field Description

Proxy host url

This determines the server to be set in the system properties for http.proxyHost property.

Proxy host url is ___________________________

Proxy port

This determines the port to be set in the system properties for the http.proxyPort property.

Proxy port is ______________________________


Caution:

These fields are optional so leave the values blank. These values are required only if the Siebel server is outside of the firewall.

4.3 Configuring and Deploying the Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration

This section discusses the integration configuration and deployment process. There are two steps:

  1. Configure your integration using the DCW.

  2. Deploy the integration to the Fusion Middleware server.

4.3.1 Configuring the Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration

The screens that appear prompt you to enter the data that is required for successful configuration of the Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration. Keep the completed worksheets of the Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration screens ready before you launch the DCW.

To configure the Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration:

Note:

If you are harvesting content to Oracle Enterprise Repository (OER), perform the first three steps. Else start from step 4.

  1. Navigate to /slot/emsxxxx/oracle/Middleware/user_projects/domains/soa_domain/bin/ and open setDomainEnv.sh for Linux based systems and setDomainEnv.bat for Microsoft Windows.

  2. Replace WLS_JDBC_REMOTE_ENABLED="-Dweblogic.jdbc.remoteEnabled=false" with WLS_JDBC_REMOTE_ENABLED="-Dweblogic.jdbc.remoteEnabled=true".

  3. Restart the server.

  4. Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh for Linux based systems and aiaenv.bat for Microsoft Windows to configure installation environment.

  5. Navigate to <AIA_HOME>/bin and run the command ./aiaconfig.sh for Linux based systems and aiaconfig.bat for Microsoft Windows.

    This launches the AIA DCW.

  6. Click Next.

  7. Expand Communications Pre-built Integrations and select Comms Agent Assisted Billing Care: SBL CRM - BRM.

  8. Click Next.

4.3.1.1 Specify Integration Server Details

To specify integration server details:

  1. Enter information related to your integration server in the Integration Server Details screen.

  2. Click Next.

4.3.1.2 Specify Siebel CRM Server Details

To specify Siebel CRM Server details:

  1. Enter information about your Siebel CRM application in the Application Details - Siebel CRM screen.

  2. Click Next.

4.3.1.3 Specify Siebel CRM Database Details

To specify Siebel CRM Database details:

  1. Enter information about your Siebel CRM database in the Siebel CRM Database Details screen.

  2. Click Next.

4.3.1.4 Specify Oracle Communications BRM Details

To specify Oracle Communications BRM details:

  1. Enter Oracle Communications BRM information in the Oracle Communications BRM screen.

  2. Click Next.

4.3.1.5 Specify Oracle Data Integrator Access Details

To specify Oracle Data Integrator Access details:

  1. Enter information about your Oracle Data Integrator Access installation in the Oracle Data Integrator Access Information screens.

    Oracle Data Integration Access Information is captured in three screens. Enter the following information in the screens:

  2. Specify the path to Oracle Data Integrator.

  3. Click Next.

  4. Specify the path for exported DVMs.

  5. Click Next.

  6. Enter ODI User name and ODI User Password.

  7. Click Next.

4.3.1.6 Specify Oracle Data Integrator Master Repository Details

To specify Oracle Data Integrator Master Repository details:

  1. Enter information about your Oracle Data Integrator Master Repository installation in the Oracle Data Integrator Master Repository screen.

  2. Click Next.

4.3.1.7 Specify Oracle Data Integrator Work Repository Details

To specify Oracle Data Integrator Work Repository Details:

  1. Enter information about your Oracle Data Integrator Work Repository installation in the Oracle Data Integrator Work Repository Details for Agent Assisted Billing Care screen.

  2. Click Next.

4.3.1.8 Complete Configuration

To complete configuration:

  1. Review the configuration information on the Configuration Summary screen.

    Note:

    If you want to make changes to the configuration, use the navigation pane on the left and select the screen you want to edit.

    You can create a response file based on the input provided in the DCW and use it in future when you want to deploy the integration. You can configure using the steps described in Section 4.3.2, "Configuring using the Response File". Click Save Response File and save the response file with the name and location of your choice.

  2. Click Configure to accept this configuration and begin the installation.

    The system displays progress of configuration in the Configuration Progress screen.

    The system displays any warnings or errors as necessary. You can review the configuration log for additional details. The configuration log location is displayed in the Configuration Progress screen.

  3. When configuration process finishes without errors, the DCW displays the Configuration Complete screen.

  4. Click Finish to close the DCW.

4.3.2 Configuring using the Response File

To configure using the response file:

  1. Open the response file.

    When you create a response file through OUI, passwords get stored as <SECURE>.

  2. Replace the password fields with actual passwords in the response file.

  3. Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh for Linux based systems and aiaenv.bat for Microsoft Windows to configure the environment.

  4. Navigate to <AIA_HOME>/bin and run the command ./aiaconfig.sh <Response File Location and Name> for Linux based systems and aiaconfig.bat <Response File Location and Name> for Microsoft Windows.

4.3.3 Deploying Mandatory Patches

Before deploying Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration, you must install the patch 16598272.

4.3.4 Deploying the Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration

To deploy the integration to Fusion Middleware server:

  1. Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh for Linux based systems and aiaenv.bat for Microsoft Windows to configure the environment.

  2. Run the command for your platform.

    Note:

    In Windows 2008, 2008 R2 and Vista, run the command prompt as an administrator (elevated mode). If the command prompt is invoked in normal mode, the integrations are not displayed.

    Table 4-10 Deployment Commands for the Comms Agent Assisted Billing Care Pre-Built Integration

    Platform Deployment Command

    Linux x86

    Solaris SPARC (64-bit)

    IBM AIX Based Systems (64-bit).

    HP-UX 11i (64 bit)

    $AIA_HOME/pips/Communications/AABC/DeploymentPlans/deployAABC.sh
    

    Microsoft Windows (32-bit)

    %AIA_HOME%\pips\Communications\AABC\DeploymentPlans\deployAABC.bat
    

  3. Review the log file in the location specified in the command or at the default location <AIA_Instance>/logs/AABCDP_Deployments_YYYY-MM-DD_HH-MI-SS.log to verify successful deployment of the integration.

Oracle AIA ships a few artifacts in AIA Lifecycle Workbench which can be used in your integrations. These native artifacts created using FMW technologies such as BPEL and Mediator are natively supported by AIA Foundation Pack tools such as Project Lifecycle Workbench, Harvester, Deployment Generator and AID. These artifacts include SOA artifact types such as composites, DataSources, DVM, xRef, and so on. These can be modified or new natively supported artifacts can be added using AIA Lifecycle Workbench and a BOM.xml file can be generated.

Integrations, most often, also require deployment of artifact types that are beyond what is supported by the Project Lifecycle Workbench and AIA Harvester. For instance, you may want to deploy artifacts such as Java applications, Shell Scripts, ANT based build scripts which constitute part of integration landscape in addition to the artifacts that are delivered by AIA. AIA also supports deployment of these supplementary artifacts. However, you must modify and add new non native artifacts outside AIA Lifecycle Workbench.

For more information on deploying artifacts, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, "Generating Deployment Plans and Deploying Artifacts".

4.4 Performing Postdeployment Configurations

This section discusses the postdeployment configurations for Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration.

4.4.1 Suppressing Auto-Retry and Preventing Multiple Error Notifications and Trouble Tickets

To suppress auto-retry and prevent multiple error notifications and trouble tickets:

  1. Set the GlobalTxMaxRetry property for outbound adapters:

    1. Log in to the Oracle Enterprise Manager Fusion Middleware Control.

    2. Expand the SOA folder, right-click soa_infra.

    3. Select SOA Administration, Common Properties.

    4. Click More SOA Infra Advanced Configuration Properties.

    5. Search for the GlobalTxMaxRetry property and set the value as 0 (zero).

  2. Set the GlobalInboundJcaRetryCount property for inbound adapters:

    1. Log in to the Oracle Enterprise Manager Fusion Middleware Control.

    2. Expand the SOA folder, right-click soa_infra.

    3. Select Administration, System Mbean Browser.

    4. Search for oracle.as.soainfra.config, expand <Server>, expand AdapterConfig.

    5. Select Adapter.

    6. Search for the GlobalInboundJcaRetryCount property and set the value as 0 (zero).

  3. Change Audit Level from development to production for soa infrastructure:

    1. Log in to the Oracle Enterprise Manager Fusion Middleware Control.

    2. Expand the SOA folder, right-click soa_infra.

    3. Select SOA Administration, Common Properties.

    4. Choose Production from the Audit Level list.

    5. Click Apply

  4. Stop and Start the SOA and Admin Server so that your changes can take effect.

4.4.2 Deploying Mandatory Patches

After deploying Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration, you must deploy the following patches:

  • 11843588

  • 12755349

4.5 Verifying Deployment

To verify the Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration deployment:

  1. Open the log files from the following location and look for warnings and error messages:

    • For Linux x86, Solaris SPARC (64-bit), HP-UX 11i (64 bit) and IBM AIX Based Systems (64-bit): Review the install log located at <AIA_HOME>/aia_instances/<instance name>/logs to verify whether the integration is successfully installed.

    • For Microsoft Windows (32-bit): Review the install log located at <AIA_HOME>\aia_instances\<instance name>\logs to verify whether the integration is successfully installed.

  2. Confirm that the Comms Agent Assisted Billing Care: Siebel - BRM Pre-Built Integration services were installed.

    1. Navigate to the Oracle Enterprise Manager Fusion Middleware Control (http://<server name>:<port number>/em/)

    2. Log in with the server admin user name. For access details, contact the system administrator.

    3. Expand Farm_soa_domain, SOA, soa-infra, Default and look for the following items:

    • AccountBalanceSiebelCommsReqABCS

    • AdjustmentSiebelCommsReqABCS

    • CommunicationsCustomerPartyEBSV2

    • CommunicationsCustomerPartyResponseEBSV2

    • Core2CommsCustomerPartyBridge

    • CreateAccountBalanceAdjustmentBRMCommsProvABCSImpl

    • CreateAccountBalanceAdjustmentListResponseBRMCommsJMSConsumer

    • CreateAccountBalanceAdjustmentListResponseBRMCommsJMSProducer

    • CreateAccountBalanceAdjustmentSiebelCommsJMSConsumer

    • CreateAccountBalanceAdjustmentSiebelCommsReqABCSImpl

    • CreateInvoicePaymentSiebelCommsReqABCSImpl

    • CreatePaymentSiebelCommsReqABCSImpl

    • CreateReceivedPaymentBRMCommsProvABCSImpl

    • CustomerPartyEBSV2

    • InvoiceSiebelCommsReqABCS

    • PaymentSiebelCommsReqABCS

    • QueryAccountBalanceAdjustmentBRMCommsProvABCSImpl

    • QueryAccountBalanceAdjustmentSiebelCommsReqABCSImpl

    • QueryBalanceDetailsSiebelCommsReqABCSImpl

    • QueryBalanceGroupListSiebelCommsReqABCSImpl

    • QueryBalanceGroupServicesSiebelCommsReqABCSImpl

    • QueryBalanceSummarySiebelCommsReqABCSImpl

    • QueryCustomerPartyListBRMCommsProvABCSImpl

    • QueryInstalledProductListBRMCommsProvABCSImpl

    • QueryInvoiceBalanceDetailsSiebelCommsReqABCSImpl

    • QueryInvoiceEventDetailsSiebelCommsReqABCSImpl

    • QueryInvoiceListBRMCommsProvABCSImpl

    • QueryInvoiceListSiebelCommsReqABCSImpl

    • QueryInvoicePaymentSiebelCommsReqABCSImpl

    • QueryInvoiceSiebelCommsReqABCSImpl

    • QueryPaymentSiebelCommsReqABCSImpl

    • QueryReceivedPaymentListBRMCommsProvABCSImpl

    • QueryServiceUsageBRMCommsProvABCSImpl

    • QueryUnbilledBalanceDetailsSiebelCommsReqABCSImpl

    • QueryUnbilledEventDetailsSiebelCommsReqABCSImpl

    • QueryUnbilledUsageSiebelCommsReqABCSImpl

    • SearchInvoiceEventDetailsSiebelCommsReqABCSImpl

    • SearchPaymentSiebelCommsReqABCSImpl

    • SearchUnbilledEventDetailsSiebelCommsReqABCSImpl

    • SyncAccountSiebelAggregatorAdapter

    • SyncAccountSiebelReqABCSImpl

    • SyncAcctSiebelAggrEventConsumer

    • SyncAddressSiebelAggregatorAdapter

    • SyncBPSiebelAggregatorAdapter

    • SyncContactSiebelAggregatorAdapter

    • SyncCustomerPartyListBRM_01CommsJMSConsumer

    • SyncCustomerPartyListBRMCommsJMSProducer

    • SyncCustomerPartyListBRMCommsProvABCSImpl

    • SyncCustomerSiebelEventAggregator

    • TransformAppContextSiebelService

    • UnbilledUsageSiebelCommsReqABCS

    • UpdateAccountBalanceAdjustmentRespSiebelCommsProvABCSImpl

    • UpdateCreditAlertBRMCommsProvABCSImpl

    • UpdateCreditAlertSiebelCommsReqABCSImpl

  3. Verify Collections installation.

    1. Verify that CURRENCY_CODE.dvm, COLLECTION_STATUS.dvm, COLLECTION_ACTIONNAME.dvm, COLLECTION_PRIORITY.dvm and COLLECTION_SUBSTATUS.dvm are present in the DVM path. This is the same path that is mentioned during installation (<AIA_Instance>/config/AIAInstallProperties.xml file).

    2. Open <AIA_Instance>/logs/AABCDP_Deployments_YYYY-MM-DD_HH-MI-SS.log. The log contains several statements starting with "[exec] OracleDI: Starting Command: OdiImportObject -FILE_NAME=". None of these statements should be followed by error messages except the error messages mentioned below.

4.5.1 Error Messages During Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration Deployment

When deploying the Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration, you can encounter the following errors:

  • Failed to execute: Create user xxxxx identified by yyyyy

  • Unique Constraint Violation

4.5.1.1 Failed to execute: Create user xxxxx identified by yyyyy

AIA Pre-Built Integrations Installer displays this error message in the log file if the install script attempts to create a database user name for an existing database user name. You can ignore this message and continue with the install process.

The AIA Pre-Built Integrations Installer displays the following message when it finds an identical database user name:

Example 4-1 Identical Database User Name Message

ODIInstall_CreateDBSchemaWorkRep:
[echo] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
[echo] Creating ODI Work Repository DB User: xxxxx
[sql] Executing commands
[sql] Failed to execute: create user xxxxx identified by yyyyy
[sql] java.sql.SQLException: ORA-01920: user name 'xxxxx' conflicts with another user or role name
[sql] 1 of 2 SQL statements executed successfully
[echo] Done creating DB User for ODI Work Repository: xxxxx
[echo] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Note:

xxxxx refers to the database user name provided for ODI Work Repository and yyyyy is the password.

4.5.1.2 Unique Constraint Violation

AIA Pre-Built Integrations Installer displays this error message in the log file if the ODI data source xxxxx exists in the ODI master repository. The ODI data source is defined in Topology in the Physical Architecture tab. This error occurs when the Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration is reinstalled.

The AIA Pre-Built Integrations Installer displays the following message when it finds an identical ODI data source:

Example 4-2 Identical ODI Data Source Message

[echo] - Importing CONN_xxxxx.xml
[exec] OracleDI: Starting Command: OdiImportObject -FILE_NAME=<AIA_HOME>/PIPS/Industry/Communications/DIS/Collections/src/master/CONN_xxxxx.xml -IMPORT_MODE=SYNONYM_INSERT_UPDATE ...
[exec] java.sql.SQLException: ORA-00001: unique constraint (SNPM.PK_MTXT) violated

This error does not stop the install process. The process imports the remaining ODI integration artifacts into the ODI; however, it is important to verify the accuracy of the connections for these ODI data sources. To resolve this issue, verify that the connections and associated logical schemas in the ODI topology are accurate.

For integration implementation, see Oracle Application Integration Architecture Siebel CRM Integration Pack for Oracle Communications Billing and Revenue Management: Agent Assisted Billing Care Implementation Guide.

Also see Oracle Application Integration Architecture Oracle Communication Order to Cash Integration Pack Implementation Guide for Siebel CRM, Oracle Order and Service Management, and Oracle Billing and Revenue Management for information related to customer management.

4.5.2 Validating Security Policies

All SOA composites are protected by Global Policies provided by Foundation Pack as defined in the Security section of the Developer Guide. Additionally individual services for this integration have locally attached security policies.

To validate locally attached security policies:

  1. Log in to Oracle Enterprise Manager Fusion Middleware Control

  2. Expand WebLogic Domain.

  3. Select soa_domain.

  4. Right-click soa_domain.

  5. Select Web Services, Policies.

  6. Verify Service Policy attachment.

    1. Find no_authentication_service_policy in the list of policies.

    2. Click the number in Attachment Count column.

      This opens Usage Analysis screen.

    3. Change the Subject Type list box to SOA Service.

    4. Validate that all the composites are listed with local attachment to this service policy.

  7. Verify Client Policy attachment

    1. Navigate back to Web Services Policies screen.

    2. Navigate to Applies To LOV, select Service Clients and hit enter. Find no_authentication_client_policy.

    3. Click the number in Attachment Count column.

      This opens Usage Analysis screen.

    4. Change the Subject Type list box to SOA Reference.

    5. Validate that all the composites are listed with local attachment to this client policy and attached to the correct references.

      Table 4-11 No Authentication Service Policy Attachments for Comms Agent Assisted Billing Care: SBL CRM - BRM

      Composite Service Policy

      AccountBalanceSiebelCommsReqABCS

      oracle/no_authentication_service_policy

      UpdateCreditAlertSiebelCommsReqABCSImpl

      oracle/no_authentication_service_policy

      SyncCustomerSiebelEventAggregator

      oracle/no_authentication_service_policy

      UnbilledUsageSiebelCommsReqABCS

      oracle/no_authentication_service_policy

      PaymentSiebelCommsReqABCS

      oracle/no_authentication_service_policy

      AdjustmentSiebelCommsReqABCS

      oracle/no_authentication_service_policy

      InvoiceSiebelCommsReqABCS

      oracle/no_authentication_service_policy


      Table 4-12 No Authentication Client Policy for Comms Agent Assisted Billing Care: SBL CRM - BRM

      Composite Client Policy

      SyncAccountSiebelReqABCSImpl

      oracle/no_authentication_client_policy

      UpdateAccountBalanceAdjustmentRespSiebelCommsProvABCSImpl

      oracle/no_authentication_client_policy


4.6 Undeploying the Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration

To undeploy the integration from Fusion Middleware Server:

  1. Navigate to <AIA_Instance>/bin and run the command source aiaenv.sh for Linux based systems and aiaenv.bat for Microsoft Windows to configure the environment.

  2. Run the command for your platform.

    Table 4-13 Undeployment Command for the Comms Agent Assisted Billing Care Pre-Built Integration

    Platform Undeployment Command

    Linux x86

    Solaris SPARC (64-bit)

    IBM AIX Based Systems (64-bit).

    HP-UX 11i (64 bit)

    $AIA_HOME/pips/Communications/AABC/DeploymentPlans/undeployAABC.sh
    

    Microsoft Windows (32-bit)

    %AIA_HOME%\pips\Communications\AABC\DeploymentPlans\undeployAABC.bat
    

  3. Restart the SOA server.

  4. Uninstall the integration following the instructions in the Chapter 37, "Uninstalling Oracle AIA"