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

28 Configuring and Deploying the Lead to Order: CRM OD - EBS PIP

This chapter discusses how to configure and deploy the Oracle Lead to Order Integration Pack for Oracle CRM On Demand and Oracle E-Business Suite (Lead to Order: CRM OD - EBS PIP).

This chapter includes the following sections:

28.1 Deployment Configuration Wizard

The DCW screens prompt you to enter the data required for successful configuration of the Lead to Order: CRM OD - EBS PIP. Enter the details of the Lead to Order: CRM OD - EBS PIP screens below, take a printout and keep it ready when you run the DCW. This action enables faster and error free configuration.

28.1.1 PIP Server Details Screen

All artifacts associated with the PIP infrastructure components deploy to the PIP server. This screen contains the following fields:

Table 28-1 PIP Server Details Screen Fields

Field Description

Admin Host Name

Specifies the admin server resides. This can be a remote server or the same system 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 the Weblogic Admin server is started. To find this value contact the 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 password is _____________________________________

Managed Server

After you enter the Admin Host Name, Admin Port and Admin User, this field populates with managed servers for the domain. Select the managed server from the list. If you are deploying the PIP to a SOA cluster, you should select the cluster name in this field.

The Managed Server is _______________________________

Managed Port

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


28.1.2 Oracle E-Business Suite Server Details Screen

Use this screen to enter details related to your Oracle E-Business Suite server instance.

The screen contains the following fields:

Table 28-2 Oracle E-Business Suite Server Details Screen Fields

Field Description

E-Business Suite Version

This is the version of the E-Business Suite application.

E-Business Suite Host Name

Specifies the fully qualified system name of the Oracle E-Business Suite application server. Example: servername.your.company.com.

E-Business Suite Host Name is ___________________________

E-Business Suite Port

This value is the Oracle E-Business Suite application port. To find this value, contact your administrator. Example: 8024.

E-Business Suite Port is ______________________________

E-Business Suite User Name

The user ID value for the designated Oracle E-Business Suite integration user responsible for integration transactions within the Oracle E-Business Suite.

E-Business Suite User Name is __________________________

E-Business Suite Password

The password that is associated with the Oracle E-Business Suite integration user ID

E-Business Suite Password is ___________________________

Workflow Business Event System Name

This is the Workflow Business Event System Name of E-Business Suite Server.

To find this value:

  1. Find the Responsibility Workflow Administrator Web Applications.

  2. Navigate to Administrator Workflow, Home, Administration.

  3. View section Business Event Local System.

  4. Find the value in the field System Name

Workflow Business Event System Name is _________________


28.1.3 Oracle E-Business Suite Database Details Screen

Use this screen to enter details related to your Oracle E-Business Suite database instance.

The screen contains the following fields:

Table 28-3 Oracle E-Business Suite Database Details Screen Fields

Field Description

E-Business Suite Database Host

Specifies the system name. To find this value, contact the database administrator. Example: server1.your.company.com.

E-Business Suite Database Host is ________________________

E-Business Suite Database Port

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

E-Business Suite Database Port is ________________________

E-Business Suite Database Username

To find this value, contact the database administrator. Example: apps.

E-Business Suite Database Username is ___________________

E-Business Suite Database Password

To find this value, contact the database administrator.

E-Business Suite Database Password is ____________________

E-Business Suite Database SID

To find this value, contact the database administrator. Example: ebiz.

E-Business Suite Database SID is _________________________

Database Schema

To find this value, contact the database administrator. Example: apps.

Database Schema is __________________________________

Note: All the database credentials are used for creating the connection pool URL (universal resource locator) and data source URLs.


28.1.4 CRM On Demand Web Services Details Screen

Use this screen to enter details related to your CRM On Demand Web services instance.

The screen contains the following fields:

Table 28-4 CRM On Demand Web Services Details Screen Fields

Field Description

Web Service URL

This value is the location of the CRM On Demand web services. Example: http://secure-ausomxdsa.crmondemand.com/Services/Integration.

To obtain the exact value of your CRM On Demand web service:

  1. Log in to CRM OD.

  2. Go to Admin.

  3. Go to Web Services Administration.

  4. Select Service APIs Service from LOV and click Go.

  5. Select Time and click Download Custom WSDL.

  6. At the end of the xml, look for <soap:address location> tag.

After performing these steps, you see the exact Web Service URL value.

Web service URL location is __________________________

Company

This is the company Sign In ID associated with the CRM On Demand instance.

This value equals the value entered for "User Sign In ID" when logging in to CRM On Demand. For example, CORE_XE01/CRMEBSINT.

CORE_XE01 is the Company

Company is _______________________________

User ID

The user ID value for the designated CRM On Demand integration user responsible for integration transactions within CRM On Demand.

This value equals the value entered for "User Sign In ID" when logging in to CRM On Demand. For example, CORE_XE01/CRMEBSINT.

CRMEBSINT is the User ID

User ID is _________________________________

Password

The password that is associated with the CRM On Demand integration user. Example: PASSWORD.

Password is _________________________________

Operating Unit

Operating unit indicates whether CRMOD Env is implementing Multi org. If it is implementing Multi Org then the value should be 'Y', otherwise 'N'


28.1.5 Session Pool Manager Screen (Optional)

This PIP uses the Session Pool Manager utility to interact with Siebel web services. If the AIA server must invoke Siebel web services through a proxy server, fill in the values in this screen. If no proxy server is involved, these values can be left blank.

Use this screen to enter details related to your Session Pool Manager.

The screen contains the following fields:

Table 28-5 Session Pool Manager Screen Fields

Field Description

Proxy Host URL

Specify the proxy host location. Example: www-proxy.your.company.com

Proxy Host URL is _________________________________

Proxy Port

Specify the proxy port. Example: 80

Proxy Port is _________________________________


For information about Session Pool Manager, see Oracle Application Integration Architecture Process Integration Pack Utilities Guide, "Session Pool Manager".

28.2 Performing Predeployment Configurations

You must modify transaction properties and configure the JVM parameters to complete the PIP installation.

To modify transaction properties:

  1. Login to WebLogic Server Console. Navigate to Services, JTA. Change the value of property JTA Transaction Timeout from 30 to 3600.

  2. Change the SyncMaxWaitTime parameter as follows:

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

    2. Expand SOA folder, right click soa_infra.

    3. Select SOA Administration, BPEL Properties, More BPEL Properties.

    4. Change the value of syncMaxWaitTime from 45 to 240.

    5. Click Apply.

To configure JVM parameters

  1. Navigate to <Middleware home>/user_projects/domains/<domain_name>/bin.

  2. For Linux, update the following parameters in the setDomainEnv.sh file. Search for the string USER_MEM_ARGS and modify as necessary.

    USER_MEM_ARGS="-Xms4096m -Xmx4096m -XX:PermSize=512m -XX:MaxPermSize=512m -Xmn2048m -XX:-UseAdaptiveSizePolicy -XX:+PrintGCDateStamps -verbose:gc -XX:+UseParallelGC -XX:ParallelGCThreads=2 -XX:SurvivorRatio=6"

    For Windows, update the following parameters in the setDomainEnv.cmd file. Search for the string USER_MEM_ARGS and modify as necessary.

    USER_MEM_ARGS="-Xms4096m -Xmx4096m -XX:PermSize=512m -XX:MaxPermSize=512m -Xmn2048m -XX:-UseAdaptiveSizePolicy -XX:+PrintGCDateStamps -verbose:gc -XX:+UseParallelGC -XX:ParallelGCThreads=2 -XX:SurvivorRatio=6"

    Note:

    The values specified are baseline values. You can modify the values to improve performance. Your server class machines must have 8GB RAM or more of available space for the above memory settings to be valid.

    If the above parameters are not present in those files, then add the above parameters under the string "# IF USER_MEM_ARGS the environment variable is set".

For more information, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, "Tuning Java Virtual Machines (JVMs)".

28.3 Configuring and Deploying the Lead to Order: CRM OD - EBS PIP

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

  1. Configure your PIP using the deployment DCW.

  2. Deploy the PIP to the Fusion Middleware server.

28.3.1 Configuring the Lead to Order: CRM OD - EBS PIP

The screens that appear prompt you to enter the data that is required for successful configuration of the Lead to Order: CRM OD - EBS PIP. Keep the completed worksheets of the Lead to Order: CRM OD - EBS PIP screens ready before you launch the DCW.

Note:

If you are harvesting content to OER, perform the first three steps. Else start from step 4.

To configure the Lead to Order: CRM OD - EBS PIP:

  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 the 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. Select the Lead to Order: CRM OD - EBS PIP

  8. Click Next.

28.3.1.1 Specify PIP Server Details

To specify PIP Server details:

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

  2. Click Next.

28.3.1.2 Specify Oracle E-Business Suite Server Details

To specify Oracle E-Business Suite Server details:

  1. Enter information about your Oracle E-Business Suite Server installation in the E-Business Suite Server Details screen.

  2. Click Next.

28.3.1.3 Specify Oracle E-Business Suite Database Details

To specify Oracle E-Business Suite Database details:

  1. Enter information about your Oracle E-Business Suite Database installation in the E-Business Suite Database Details screen.

  2. Click Next.

28.3.1.4 Specify CRM On Demand Web Services Details

To specify CRM On Demand Web Services details:

  1. Enter information about your CRM On Demand Web Services installation in the CRM On Demand Web Services Information screen.

  2. Click Next.

28.3.1.5 Specify Session Pool Manager Details

To specify Session Pool Manager details:

  1. Enter information related to your Session Pool Manager installation in the Session Pool Manager Details screen.

  2. Click Next.

28.3.1.6 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 PIP. You can configure using the steps described in Section 28.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 the configuration.

    The system displays progress of the 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 Configuration Progress screen.

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

  4. Click Finish to close the DCW.

28.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.

Note:

When you run the PIP deployment command, AIACompositeScheduler gets deployed onto WebLogic server along with the PIP.

If you are installing on WebLogic cluster, ensure the following before you run the deployment command:

  • Leasing is enabled for cluster.

  • In the config wizard, if you did not select default option to Create default Job Scheduler table and datasource if one does not exist then ensure that data source and table for Job Scheduler are created and set on cluster. This option is selected by default.

These tasks enable AIACompsiteScheduler schedule jobs in cluster. This is a requirement from WebLogic Job Scheduler which AIACompositeScheduler uses to schedule jobs. For more information, see the Implementing and Configuring Job Schedulers section at http://download.oracle.com/docs/cd/E12840_01/wls/docs103/commonj/commonj.html#wp1058049

For information on AIACompositeScheduler, see Oracle Application Integration Architecture Process Integration Pack Utilities Guide, "Deploying AIACompositeScheduler", "Deploying AIACompositeScheduler on Cluster Server."

28.3.3 Deploying the Lead to Order: CRM OD - EBS PIP

To deploy the PIP 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:

    When you copy and paste the command in the command line, ensure that there is space between .xml and -. Ensure that there is space between these two when you run undeployment command too.

    Table 28-6 Deployment Commands for the Lead to Order: CRM OD - EBS PIP

    Platform Deployment Command

    Linux

    Solaris SPARC

    IBM AIX Based Systems.

    HP-UX

    ant -f <AIA_HOME>/Infrastructure/Install/AID/AIAInstallDriver.xml 
    -DPropertiesFile=<AIA_HOME>/aia_instances/<AIA_Instance_name>/config/AIAInstallProperties.xml 
    -DDeploymentPlan=<AIA_HOME>/pips/CRMODtoEbizLeadToOrder/DeploymentPlans/CRMODtoEbizLeadToOrderDP.xml  
    -DSupplementaryDeploymentPlan=<AIA_HOME>/pips/CRMODtoEbizLeadToOrder/DeploymentPlans/CRMODtoEbizLeadToOrderSupplementaryDP.xml 
    -l <AIA_HOME>/pips/CRMODtoEbizLeadToOrder/DeploymentPlans/CRMODtoEbizLeadToOrder.log
    

    Microsoft Windows

    ant -f <AIA_HOME>\Infrastructure\Install\AID\AIAInstallDriver.xml 
    -DPropertiesFile=<AIA_HOME>\aia_instances\<AIA_Instance_name>\config\AIAInstallProperties.xml 
    -DDeploymentPlan=<AIA_HOME>\pips\CRMODtoEbizLeadToOrder\DeploymentPlans\CRMODtoEbizLeadToOrderDP.xml 
    -DSupplementaryDeploymentPlan=<AIA_HOME>\pips\CRMODtoEbizLeadToOrder\DeploymentPlans\CRMODtoEbizLeadToOrderSupplementaryDP.xml 
    -l <AIA_HOME>\pips\CRMODtoEbizLeadToOrder\DeploymentPlans\CRMODtoEbizLeadToOrder.log
    

    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 PIPs are not displayed.

  3. Review the log file in the location specified in the command to verify successful deployment.

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

AIA PIP development teams, most often, also require deployment of artifact types that are beyond what is supported by the Project Lifecycle Workbench and AIA Harvester. For instance, integration may require 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".

28.4 Performing Postdeployment Configurations

This section discusses the postdeployment configuration for the Lead to Order: CRM OD - EBS PIP. This section contains the following:

28.4.1 Populating the inventory_location_id cross-reference Table

You must create a cross-reference in the inventory_location_id cross-reference (XREF) table for each operating unit in Oracle E-Business Suite for which data is to be synchronized to CRM On Demand. To create a cross-reference in the inventory_location_id XREF table you must perform the following tasks:

  1. Identify inventory location details for each operating unit.

  2. Create a cross-reference for the inventory location ID of the operating unit.

  3. Validate the cross-reference.

To identify inventory location details in Oracle EBS:

  1. Log in to Oracle E-Business Suite.

  2. Select the Order Management responsibilities for the relevant operating unit.

  3. Perform the following steps for each of the relevant Order Management responsibilities:

    1. Select Setup: System Parameter, Values from menu option.

    2. Note the name of the organization associated with the Item Validation Organization parameter, for example, DivisionA Operations.

  4. To obtain the full name of the operating unit:

    1. Log in to the Oracle E-Business Suite database (apps/apps).

    2. Identify the operating unit for which data is to be synchronized to CRM On Demand.

    3. Log in to Oracle Applications and identify the full name of the operating unit, for example, DivisionA Operations (204).

  5. Obtain the organization_id of the operating unit by issuing the following query:

    select organization_id from hr_operating_units where name = 'DivisionA Operations'

    Where DivisionA Operations is the name of the organization associated with the Item Validation Organization parameter that you identified in step 3.

To create cross-references in the inventory_location_id XREF Table:

Note:

SOA Domain must be running to perform these steps.

  1. Log in to the WebLogic Server EM Console.

  2. Navigate to SOA, soa-infra, default.

  3. Click the UtilityXREF composite.

  4. Click Test.

  5. Expand Security and select WSS Username Token. Use Weblogic username/password.

  6. Enter the following values:

    Example 28-1 Cross-References in the inventory_location_id XREF Table

    <XREFTableName>oramds:/apps/AIAMetaData/xref/INVENTORY_LOCATION_ID.xref</XREFTableName>
    <ReferenceColName>EBIZ_01</ReferenceColName>
    <ReferenceVal>organization_ID</ReferenceVal>
    <ColumnName>COMMON</ColumnName>
    <ColumnValue>12345</ColumnValue>
    

    In Example 28-1:

    • organization_id in the <ReferenceVal> record is the organization ID of the operating unit which you identified in the previous procedure.

    • 12345 in the <ColumnValue> record is a numeric string with a maximum length of 32 characters.

      The <ColumnValue> you specify must be unique in the inventory_location_id XREF table. If you must create inventory_location_id records for multiple operating units, increment the value you specify for the <ColumnValue> record for each subsequent record.

  7. Click Test Web Service.

  8. Restart the SOA server.

To validate the cross-references you created:

  1. Log in to the AIA XREF database.

  2. Using the following query, search the XREF_DATA table to confirm that every organization and every inventory location used in the XML files has three records, <ReferenceVal>, <ColumnName>, and ColumnValue>.

    Example 28-2 Cross-Reference Validation Query

    select value||'::'||Xref_column_name from xref_Data where
    row_number in (select row_number from xref_data where
    xref_table_name = 'oramds:/apps/AIAMetaData/xref/INVENTORY_LOCATION_ID.xref'and value in ('organization_id'))
    

    In Example 28-2, organization_id is the organization ID of the operating unit for which you created the cross-reference.

28.4.2 Defining the Application Context for E-Business Suite Service Calls

The application context for E-Business Suite service or API calls comprises the following components:

  • Operating unit

  • User name

  • Responsibility

You must define the application context in process flows where E-Business Suite API or service calls are made. This involves the following steps:

  1. Map operating units to the corresponding entities in other applications.

    If the source application's organization context is available in a flow and if it is mapped in the ORGANIZATION_ID cross-reference table, the operating unit is obtained by looking up the ORGANIZATION_ID cross-reference table.

    If the organization context is not mapped or cannot be looked up, the default operating unit is used as the organization context value.

    The default operating unit is set in the TransformAppContextEbizService.DefaultOperatingUnit property; the service name is TransformAppcontextEbizService.

  2. If required, you can define cross-reference mappings for users between applications in the USER_NAME cross-reference table.

    If the source application's user context is available in a flow and is mapped in the USER_NAME cross-reference table, the user name for E-Business Suite can be derived from the USER_NAME cross-reference table.

    If the user context is not mapped or cannot be looked up, then a default user name is used. The default user is defined in the TransformAppContextEbizService.DefaultUser property; the service name is TransformAppcontextEbizService.

  3. Responsibilities must be mapped to the E-Business Suite User+Operating Unit combined field.

    You must specify a valid responsibility that is assigned privileges to operate in the operating unit, and the responsibility must be assigned to the specified user.

    Map responsibilities in the ORACLE_RESPONSIBILITY domain value map.

    • In the EBIZ_USER_OU column, enter the user name and organization ID in a format like USER_NAME:ORGANIZATION_ID. The following is an example entry:

      EBIZ_USER_OU - OPERATIONS:204

    • In the EBIZ_RESP column, enter the Responsibility to be used for the user and organization specified. The following is an example entry:

      EBIZ_RESP - Order Management Super User, Vision Operations (USA)

The default responsibility is set in the TransformAppContextEbizService.DefaultResponsibility property; the service name is TransformAppcontextEbizService.

28.4.3 Updating the Oracle E-Business Suite Database

In the Oracle E-Business Suite database, run the following command:

Example 28-3 Oracle E-Business Suite Database Update Command

/
BEGIN
DBMS_AQADM.ALTER_QUEUE(
      queue_name => 'WF_BPEL_Q',
      max_retries => 0,
      retention_time => 0);        
end;
/
BEGIN
sys.dbms_aqadm.start_queue(
queue_name => 'AQ$_WF_BPEL_QTAB_E'
, enqueue => FALSE
, dequeue => TRUE);
END;
/
CREATE OR REPLACE PROCEDURE MSG_RESUBMIT (
 MSG_ID RAW,
 CONSUMER_NAME VARCHAR,
 DEQUEUE_NAME VARCHAR,
 RESUBMIT_QUEUE_NAME VARCHAR
) AS
 R_DEQUEUE_OPTIONS DBMS_AQ.DEQUEUE_OPTIONS_T;
 R_ENQUEUE_OPTIONS DBMS_AQ.ENQUEUE_OPTIONS_T;
 R_MESSAGE_PROPERTIES DBMS_AQ.MESSAGE_PROPERTIES_T;
 R_ENQUEU_MESSAGE_PROPERTIES DBMS_AQ.MESSAGE_PROPERTIES_T;
 L_MESSAGE_HANDLE RAW(16);
 RESUBMIT_MESSAGE_ID RAW(2000);
 MSG WF_EVENT_T;
 ANYEXCEPTION EXCEPTION;
 V_MESSAGE_HANDLE RAW(16);
BEGIN
 R_DEQUEUE_OPTIONS.CONSUMER_NAME := NULL;
 R_DEQUEUE_OPTIONS.DEQUEUE_MODE := DBMS_AQ.REMOVE;
 R_DEQUEUE_OPTIONS.WAIT := DBMS_AQ.NO_WAIT;
 R_DEQUEUE_OPTIONS.VISIBILITY := DBMS_AQ.ON_COMMIT;
 R_DEQUEUE_OPTIONS.NAVIGATION := DBMS_AQ.FIRST_MESSAGE;
 R_DEQUEUE_OPTIONS.MSGID := MSG_ID;
 DBMS_AQ.DEQUEUE(
  QUEUE_NAME => DEQUEUE_NAME,
  DEQUEUE_OPTIONS => R_DEQUEUE_OPTIONS,
  MESSAGE_PROPERTIES => R_MESSAGE_PROPERTIES,
  PAYLOAD => MSG,
  MSGID => V_MESSAGE_HANDLE
 );
 R_ENQUEUE_OPTIONS.VISIBILITY:=DBMS_AQ.IMMEDIATE;
 DBMS_AQ.ENQUEUE(
  QUEUE_NAME => RESUBMIT_QUEUE_NAME,
  ENQUEUE_OPTIONS => R_ENQUEUE_OPTIONS,
  MESSAGE_PROPERTIES => R_ENQUEU_MESSAGE_PROPERTIES,
  PAYLOAD => MSG,
  MSGID => RESUBMIT_MESSAGE_ID
 );
 
 COMMIT;
 EXCEPTION
 WHEN ANYEXCEPTION THEN
  ROLLBACK;
END;
/

28.4.4 Updating the AIA Configuration Properties

To update the AIAConfigurationProperties:

  1. Open the following file in a text editor:

    <AIA_HOME>/aia_instances/<instance_name>/AIAMetaData/config/AIAConfigurationProperties.xml

    <instance_name> is the value entered while configuring the PIP.

  2. Locate the service configuration section for the CreateSalesQuoteEbizProvABCSImpl service.

  3. Ensure the value of Routing.CreateSalesQuoteEbizAdapter.EBIZ_01.EndpointURL is set as follows:

    • http://${fp.server.soaserverhostname}:${fp.server.soaserverport}/soa-infra/services/default/CreateSalesQuoteEbizAdapter/CreateSalesQuoteEbizAdapter_ep if you are using Oracle E-Business Suite 11i

    • http://${fp.server.soaserverhostname}:${fp.server.soaserverport}/soa-infra/services/default/CreateSalesQuoteEbizR12VersionAdapter/CreateSalesQuoteEbizR12VersionAdapter_ep if you are using Oracle E-Business Suite R12.1.1 or R12.1.2

28.4.5 Configuring Session Pool Manager

This PIP uses the Session Pool Manager utility. Configure Session Pool Manager after you install the PIP. For information on how to configure Session Pool Manager for your integration environment and needs, see Oracle Application Integration Architecture Process Integration Pack Utilities Guide , "Session Pool Manager".

For more information on Session Pool Manager configurations, see MOS ID 1314624.1. This document provides a solution for the Cipher not initialized error.

28.5 Verifying Deployment

To verify the Lead to Order: CRM OD - EBS PIP deployment:

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

    • For Linux, Solaris SPARC, HP-UX and IBM AIX Based Systems: Review the install log located at <AIA_HOME>/aia_instances/<instance name>/logs to verify that the PIP is successfully installed.

    • For Microsoft Windows: Review the install log located at <AIA_HOME>\aia_instances\<instance name>\logs to verify that the PIP is successfully installed.

  2. Verify that AIACompositeScheduler is deployed.

    1. Log into Weblogic Server console.

    2. Navigate to your_domain, Deployments and check whether you can see AIACompositeScheduler.

  3. Verify whether Session Pool Manager is successfully installed and ensure that the CRMOnDemand server is active.

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

    2. On the left panel under Farm_soa_domain, SOA, soa-infra (soa_server1), Default, click AIASessionPoolManager.

    3. Click Test.

    4. Enter Operation = Start.

    5. Select WSS Username Token and use Weblogic user name and password.

    6. Enter Input Argumemt Host Id = CRMOD_01.

    7. Click Test Web Service.

      You should see a successful initialization response message. For more information and troubleshooting steps, see Oracle Application Integration Architecture Process Integration Pack Utilities Guide, "Session Pool Manager".

  4. Confirm that the Lead to Order: CRM OD - EBS PIP 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:

    • AIASessionPoolManager

    • BatchLoadCustomerPartyListEbizAdapter

    • BatchLoadCustomerPartyListEbizEventConsumer

    • BatchLoadCustomerPartyListEbizReqABCSImpl

    • BatchLoadItemEbizEventConsumer

    • BatchLoadProductEbizReqABCSImpl

    • ContactCRMODRoutingService

    • ContactWSEndPointCRMOnDemand

    • CreateCustomerAddressCRMODReqABCSImpl

    • CreateCustomerCRMODReqABCSImpl

    • CreateCustomerPartyEbizProvABCSImpl

    • CreateItemEbizEventConsumer

    • CreateProductEbizReqABCSImpl

    • CreateSalesOrderEbizProvABCSImpl

    • CreateSalesQuoteEbizAdapter

    • CreateSalesQuoteEbizProvABCSImpl

    • CreateSalesQuoteEbizR12VersionAdapter

    • CRMOnDemandActivationAgent

    • CRMOnDemandErrorHandlerService

    • CRMOnDemandIntegrationEventProcessor

    • CRMOnDemandPriorityIntegrationEventProcessor

    • CustomerCRMODRoutingService

    • CustomerPartyEBSV2

    • CustomerPartyOrchestrationEBSV2

    • CustomerPartyOrchestrationResponseEBSV2

    • CustomerPartyResponseEBSV2

    • DeleteCustomerAddressCRMODReqABCSImpl

    • DeleteCustomerCRMODReqABCSImpl

    • InterfaceCustomerToFulfillmentEBF

    • InterfaceSalesOrderToCustomerEBFV2

    • InterfaceSalesOrderToFulfillmentEBF

    • InterfaceSalesQuoteToCustomerEBF

    • InterfaceSalesQuoteToFulfillmentEBF

    • ItemEBSV2

    • MergeAccountEbizEventConsumer

    • MergeAccountEbizReqABCSImpl

    • MergePartyEbizEventConsumer

    • MergePartyEbizReqABCSImpl

    • OpportunityWSEndPointCRMOnDemand

    • OrderWSEndPointCRMOnDemand

    • PriorityCRMODRoutingService

    • ProcessContactCRMODReqABCSImpl

    • ProcessSalesOrderCRMODReqABCSImpl

    • ProcessSalesOrderEbizAdapter

    • ProcessSalesQuoteCRMODReqABCSImpl

    • ProductWSEndPointCRMOnDemand

    • QueryCustomerPartyEbizAdapter

    • QueryCustomerPartyListCRMODProvABCSImpl

    • QueryCustomerPartyListEbizCreateAdapter

    • QueryCustomerPartyListEbizUpdateAdapter

    • QueryJTFResourceSalesPersonAdapter

    • QueryMergeAccountEbizAdapter

    • QueryMergeOrgCustEbizAdapter

    • QueryPartyMergeEbizAdapter

    • QueryRelatedOrgCustEbizAdapter

    • QueryResponsibilityEbizAdapter

    • QuerySimpleItemAdapter

    • QuerySimpleItemBatchLoadAdapter

    • QuerySimpleItemUpdateAdapter

    • QuoteWSEndPointCRMONDemand

    • SalesOrderEBSV2

    • SalesOrderOrchestrationEBSV2

    • SalesOrderOrchestrationResponseEBSV2

    • SalesOrderResponseEBSV2

    • SalesQuoteEBS

    • SalesQuoteOrchestrationEBS

    • SalesQuoteOrchestrationResponseEBS

    • SalesQuoteResponseEBS

    • SyncCustomerCRMODProvABCSImpl

    • SyncCustomerPartyListEbizAdapter

    • SyncCustomerPartyListEbizEventConsumer

    • SyncCustomerPartyListEbizProvABCSImpl

    • SyncCustomerPartyListEbizReqABCSImpl

    • SyncCustomerPartyListPersonEbizAdapter

    • SyncItemListCRMODProvABCSImpl

    • TransformAppContextEbizService

    • UpdateCustomerAddressCRMODReqABCSImpl

    • UpdateCustomerCRMODReqABCSImpl

    • UpdateCustomerPartyEbizProvABCSImpl

    • UpdateItemEbizEventConsumer

    • UpdateProductEbizReqABCSImpl

  5. Verify whether CRM On Demand Error Handler is configured.

    1. Log in to the AIA console.

    2. Navigate to the AIA Setup page.

    3. In the Error Notification tab, verify whether the required values for the fields are set as listed in the table for these services:

      Note:

      NA in the table stands for Not Applicable.

      Table 28-7 Error Handler Configuration for Lead to Order: CRM OD - EBS PIP

      Service Name System Code Error Type Error Ext Handler

      InterfaceCustomerToFulfillmentEBF

      NA

      AIA_EH_ONDEMAND

      ERRORHANDLER_EXT

      InterfaceSalesQuoteToFulfillmentEBF

      NA

      AIA_EH_ONDEMAND

      ERRORHANDLER_EXT

      InterfaceSalesOrderToCustomerEBFV2

      NA

      AIA_EH_ONDEMAND

      ERRORHANDLER_EXT

      CreateSalesOrderEbizProvABCSImpl

      NA

      AIA_EH_ONDEMAND

      ERRORHANDLER_EXT

      SyncItemListCRMODProvABCSImpl

      NA

      AIA_EH_ONDEMAND

      ERRORHANDLER_EXT

      UpdateCustomerPartyEbizProvABCSImpl

      NA

      AIA_EH_ONDEMAND

      ERRORHANDLER_EXT

      SyncCustomerPartyListEbizProvABCSImpl

      NA

      AIA_EH_ONDEMAND

      ERRORHANDLER_EXT

      CreateSalesQuoteEbizProvABCSImpl

      NA

      AIA_EH_ONDEMAND

      ERRORHANDLER_EXT

      CreateCustomerPartyEbizProvABCSImpl

      NA

      AIA_EH_ONDEMAND

      ERRORHANDLER_EXT

      CreateCustomerAddressCRMODReqABCSImpl

      NA

      AIA_EH_ONDEMAND

      ERRORHANDLER_EXT

      CreateCustomerCRMODReqABCSImpl

      NA

      AIA_EH_ONDEMAND

      ERRORHANDLER_EXT

      DeleteCustomerAddressCRMODReqABCSImpl

      NA

      AIA_EH_ONDEMAND

      ERRORHANDLER_EXT

      UpdateCustomerAddressCRMODReqABCSImpl

      NA

      AIA_EH_ONDEMAND

      ERRORHANDLER_EXT

      UpdateCustomerCRMODReqABCSImpl

      NA

      AIA_EH_ONDEMAND

      ERRORHANDLER_EXT

      ProcessSalesOrderCRMODReqABCSImpl

      NA

      AIA_EH_ONDEMAND

      ERRORHANDLER_EXT

      ProcessContactCRMODReqABCSImpl

      NA

      AIA_EH_ONDEMAND

      ERRORHANDLER_EXT

      DeleteCustomerCRMODReqABCSImpl

      NA

      AIA_EH_ONDEMAND

      ERRORHANDLER_EXT

      ProcessSalesQuoteCRMODReqABCSImpl

      NA

      AIA_EH_ONDEMAND

      ERRORHANDLER_EXT


28.5.1 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 PIP have locally attached security policies.

To validate locally attached security policies:

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

  2. Navigate to WebLogic Domain, soa_domain, Web Services, Policies.

  3. Verify Service Policy attachment.

    1. Find the 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.

  4. Verify Client Policy attachment

    1. Navigate back to Policies screen and find the client policy

    2. Click the number in Attachment Count column.

      This opens Usage Analysis screen.

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

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

      Table 28-8 Service Policy Attachments for Lead to Order: CRM OD - EBS PIP

      Composite Service Policy

      AccountWSEndPointCRMOnDemand

      oracle/aia_wss_saml_or_username_token_service_policy_OPT_ON

      AIASessionPoolManager

      oracle/aia_wss_saml_or_username_token_service_policy_OPT_ON

      ContactCRMODRoutingService

      oracle/aia_wss_saml_or_username_token_service_policy_OPT_ON

      ContactWSEndPointCRMOnDemand

      oracle/aia_wss_saml_or_username_token_service_policy_OPT_ON

      CRMOnDemandIntegrationEventProcessor

      oracle/aia_wss_saml_or_username_token_service_policy_OPT_ON

      CRMOnDemandPriorityIntegrationEventProcessor

      oracle/aia_wss_saml_or_username_token_service_policy_OPT_ON

      CustomerCRMODRoutingService

      oracle/aia_wss_saml_or_username_token_service_policy_OPT_ON

      OpportunityWSEndPointCRMOnDemand

      oracle/aia_wss_saml_or_username_token_service_policy_OPT_ON

      OrderWSEndPointCRMOnDemand

      oracle/aia_wss_saml_or_username_token_service_policy_OPT_ON

      PriorityCRMODRoutingService

      oracle/aia_wss_saml_or_username_token_service_policy_OPT_ON

      ProductWSEndPointCRMOnDemand

      oracle/aia_wss_saml_or_username_token_service_policy_OPT_ON

      QuoteWSEndPointCRMONDemand

      oracle/aia_wss_saml_or_username_token_service_policy_OPT_ON

      TransformAppContextEbizService

      oracle/aia_wss_saml_or_username_token_service_policy_OPT_ON

      UtilityXREF

      oracle/aia_wss_saml_or_username_token_service_policy_OPT_ON


      Table 28-9 No Authentication Client Policy Attachments for Lead to Order: CRM OD - EBS PIP

      Composite Reference Client Policy

      AccountWSEndPointCRMOnDemand

      ODAccountWS

      oracle/no_authentication_client_policy

      ContactWSEndPointCRMOnDemand

      CRMOnDemandContactWS

      oracle/no_authentication_client_policy

      CRMOnDemandIntegrationEventProcessor

      CRMOnDemandIntegrationEventsWS

      oracle/no_authentication_client_policy

      CRMOnDemandPriorityIntegrationEventProcessor

      CRMOnDemandPriorityEventsWebService

      oracle/no_authentication_client_policy

      OpportunityWSEndPointCRMOnDemand

      CRMOnDemandOpportunityWS

      oracle/no_authentication_client_policy

      OrderWSEndPointCRMOnDemand

      ODOrderWS

      oracle/no_authentication_client_policy

      ProductWSEndPointCRMOnDemand

      ProductWebService

      oracle/no_authentication_client_policy

      QuoteWSEndPointCRMONDemand

      ODQuoteWS

      oracle/no_authentication_client_policy

      ProcessSalesQuoteCRMODReqABCSImpl

      UserWS

      oracle/no_authentication_client_policy


      Table 28-10 Saml Opt On Client Policy Attachments for Lead to Order: CRM OD - EBS PIP

      Composite Reference Client Policy

      AccountWSEndPointCRMOnDemand

      AIASessionPoolManager

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      ContactCRMODRoutingService

      ProcessContactCRMODReqABCSImpl

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      ContactWSEndPointCRMOnDemand

      AIASessionPoolManager

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      CRMOnDemandActiviationAgent

      CRMOnDemandIntegrationEventProcessor

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      CRMOnDemandActiviationAgent

      CRMOnDemandPriorityIntegrationEventProcessor

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      CRMOnDemandErrorHandlerService

      AccountWSEndPointCRMOnDemand

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      CRMOnDemandErrorHandlerService

      AIAErrorTaskAdministrationProcess

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      CRMOnDemandErrorHandlerService

      ContactWSEndPointCRMOnDemand

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      CRMOnDemandErrorHandlerService

      OrderWSEndPointCRMOnDemand

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      CRMOnDemandErrorHandlerService

      QuoteWSEndPointCRMONDemand

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      CRMOnDemandIntegrationEventProcessor

      AIASessionPoolManager

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      CRMOnDemandIntegrationEventProcessor

      CustomerCRMODRoutingService

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      CRMOnDemandPriorityIntegrationEventProcessor

      AIASessionPoolManager

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      CRMOnDemandPriorityIntegrationEventProcessor

      PriorityCRMODRoutingService

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      CRMOnDemandIntegrationEventProcessor

      ContactCRMODRoutingService

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      CustomerCRMODRoutingService

      CreateCustomerAddressCRMODReqABCSImpl

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      CustomerCRMODRoutingService

      CreateCustomerCRMODReqABCSImpl

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      CustomerCRMODRoutingService

      DeleteCustomerAddressCRMODReqABCSImpl

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      CustomerCRMODRoutingService

      DeleteCustomerCRMODReqABCSImpl

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      CustomerCRMODRoutingService

      UpdateCustomerAddressCRMODReqABCSImpl

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      CustomerCRMODRoutingService

      UpdateCustomerCRMODReqABCSImpl

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      OpportunityWSEndPointCRMOnDemand

      AIASessionPoolManager

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      OrderWSEndPointCRMOnDemand

      AIASessionPoolManager

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      PriorityCRMODRoutingService

      ProcessSalesOrderCRMODReqABCSImpl

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      PriorityCRMODRoutingService

      ProcessSalesQuoteCRMODReqABCSImpl

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      ProductWSEndPointCRMOnDemand

      AIASessionPoolManager

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      QuoteWSEndPointCRMONDemand

      AIASessionPoolManager

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      TransformAppContextEbizService

      QueryRespEbizAdapter

      oracle/aia_wss10_saml_token_client_policy_OPT_ON

      TransformAppContextEbizService

      AIAAsyncErrorHandlingBPELProcess

      oracle/aia_wss10_saml_token_client_policy_OPT_ON


      Table 28-11 Wss User Name Token Client Policy Attachments for Lead to Order: CRM OD - EBS PIP

      Composite Reference Client Policy

      InterfaceCustomerToFulfillmentEBF

      CustomerPartyOrchestrationErrorResponseEBSV2

      oracle/wss_username_token_client_policy(AIABasicCredentials)

      InterfaceSalesOrderToCustomerEBFV2

      SalesOrderOrchestrationErrorResponseEBSV2

      oracle/wss_username_token_client_policy(AIABasicCredentials)

      InterfaceSalesOrderToFulfillmentEBF

      SalesOrderErrorEBSV2

      oracle/wss_username_token_client_policy(AIABasicCredentials)

      InterfaceSalesOrderToFulfillmentEBF

      SalesOrderOrchestrationErrorResponseEBSV2

      oracle/wss_username_token_client_policy(AIABasicCredentials)

      CreateSalesOrderEbizProvABCSImpl

      SalesOrderErrorResponseEBSV2

      oracle/wss_username_token_client_policy(AIABasicCredentials)

      SyncCustomerPartyListEbizProvABCSImpl

      CustomerPartyErrorResponseEBSV2

      oracle/wss_username_token_client_policy(AIABasicCredentials)


For more information about security validation, see Oracle Fusion Middleware Developer's Guide for Oracle Application Integration Architecture Foundation Pack, "Working with Security."

For PIP implementation, see Oracle Application Integration Architecture Oracle Lead to Order Integration Pack for Oracle CRM On Demand and Oracle E-Business Suite Implementation Guide.

28.6 Undeploying the Lead to Order: CRM OD - EBS PIP

To undeploy the PIP 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 28-12 Undeployment Command for Lead to Order: CRM OD - EBS PIP

    Platform Undeployment Command

    Linux

    Solaris SPARC

    IBM AIX Based Systems.

    HP-UX

    ant Uninstall -f <AIA_HOME>/Infrastructure/Install/AID/AIAInstallDriver.xml -DPropertiesFile=<AIA_HOME>/aia_instances/<AIA_Instance_name>/config/AIAInstallProperties.xml  -DDeploymentPlan=<AIA_HOME>/pips/CRMODtoEbizLeadToOrder/DeploymentPlans/CRMODtoEbizLeadToOrderUndeployDP.xml -l <AIA_HOME>/pips/CRMODtoEbizLeadToOrder/DeploymentPlans/CRMODtoEbizLeadToOrderUndeployDP.log
    

    Microsoft Windows

    ant Uninstall -f <AIA_HOME>\Infrastructure\Install\AID\AIAInstallDriver.xml -DPropertiesFile=<AIA_HOME>\aia_instances\<AIA_Instance_name>\config\AIAInstallProperties.xml  -DDeploymentPlan=<AIA_HOME>\pips\CRMODtoEbizLeadToOrder\DeploymentPlans\CRMODtoEbizLeadToOrderUndeployDP.xml -l <AIA_HOME>\pips\CRMODtoEbizLeadToOrder\DeploymentPlans\CRMODtoEbizLeadToOrderUndeployDP.log
    

  3. Session Pool Manager does not get undeployed when you undeploy the PIP as it belongs to common components. To undeploy Session Pool Manager, run the command specific to your platform.

    Note:

    Undeploy Session Pool Manager only if no other PIP is using it.

    Table 28-13 Undeployment Command for Session Pool Manager

    Platform Undeployment Command

    Linux

    Solaris SPARC

    IBM AIX Based Systems.

    HP-UX

    ant Uninstall -f <AIA_HOME>/Infrastructure/Install/AID/AIAInstallDriver.xml 
    -DPropertiesFile=<AIA_HOME>/aia_instances/<AIA_Instance_name>/config/AIAInstallProperties.xml  
    -DDeploymentPlan=<AIA_HOME>/utilities/SessionPoolManager/V1/DeploymentPlans/SessionPoolManagerUndeployDP.xml
    

    Microsoft Windows

    ant Uninstall -f <AIA_HOME>\Infrastructure\Install\AID\AIAInstallDriver.xml 
    -DPropertiesFile=<AIA_HOME>\aia_instances\<AIA_Instance_name>\config\AIAInstallProperties.xml  
    -DDeploymentPlan=<AIA_HOME>\utilities\SessionPoolManager\V1\DeploymentPlans\SessionPoolManagerUndeployDP.xml
    

  4. AIA Composite Scheduler does not get undeployed when you undeploy the PIP as it belongs to common components. To undeploy AIA Composite Scheduler, run the command specific to your platform.

    Note:

    Undeploy AIA Composite Scheduler only if no other PIP is using it.

    Table 28-14 Undeployment Command for AIA Composite Scheduler

    Platform Undeployment Command

    Linux

    Solaris SPARC

    IBM AIX Based Systems.

    HP-UX

    ant Uninstall -f <AIA_HOME>/Infrastructure/Install/AID/AIAInstallDriver.xml 
    -DPropertiesFile=<AIA_HOME>/aia_instances/<AIA_Instance_name>/config/AIAInstallProperties.xml  
    -DDeploymentPlan=<AIA_HOME>/utilities/AIACompositeScheduler/V1/DeploymentPlans/AIACompositeSchedulerSupplementaryUndeployDP.xml
    

    Microsoft Windows

    ant Uninstall -f <AIA_HOME>\Infrastructure\Install\AID\AIAInstallDriver.xml 
    -DPropertiesFile=<AIA_HOME>\aia_instances\<AIA_Instance_name>\config\AIAInstallProperties.xml  
    -DDeploymentPlan=<AIA_HOME>\utilities\AIACompositeScheduler\V1\DeploymentPlans\AIACompositeSchedulerSupplementaryUndeployDP.xml
    

  5. Restart the SOA server.

  6. Uninstall the PIP following the instructions in Chapter 37, "Uninstalling Oracle AIA".