Skip Headers
Oracle® Application Integration Architecture Agile Product Lifecycle Management for Oracle EBS: Design to Release Install Guide
Release 3.4
E54321-01
  Go To Table Of Contents
Contents

Previous
Previous
 
 

3 Installing and Configuring Design to Release: Agile - EBS

This chapter discusses how to configure and deploy the Agile Product Lifecycle Management for Oracle E-Business Suite: Design to Release (Design to Release: Agile - EBS) pre-built Integration.

3.1 Web Services Security Configurator

The Web Services Security (WSS) Configurator integrates the Design to Release: Agile - EBS pre-built integration with the Agile PLM 9.3.4 security environment. If you are running Agile PLM 9.3.3 or 9.3.4 in a non-WSS environment, the Web Services Security Configurator does not need to be run.

3.1.1 Starting the Web Services Security Configurator

After you install the Agile PLM PIP, the Web Services Security Configurator files are located in the $SERVICES_LOCATION/pips/AgileToEbiz/Tool directory.

Make sure that the WebLogic Server is started and that the WebLogic console is accessible before running the configurator tool.

To start the Web Services Security Configurator:

  1. Open a Command Prompt window.

  2. Make sure the JAVA_HOME and WLS_HOME environment variables point to the correct locations.

  3. Change to the $SERVICES_LOCATION/pips/AgileToEbiz/Tool directory.

  4. Open the wssconfig-d2rpip file and update the value of the wlstlocation variable, based on the example path in the file.

  5. Run the wssconfig-d2rpip script.

3.1.2 Using the Web Services Security Configurator

When the Web Services Security Configurator initializes, you have the option to review your current security policy, to support the Agile PLM 9.3.4 security policy, or to restore the security policy to the default policy (oracle/wss_http_token_client_policy).

For more information on the Agile PLM 9.3.4 security policy, see the Agile Product Lifecycle Management Security Guide.

Figure 3-1 Web Services Security Configurator

Surrounding text describes Figure 3-1 .

3.1.3 Viewing the Current Web Services Security Policy

To view the current web services security policy:

  1. Enter 1 at the prompt.

  2. Enter your SOA server URL, username, and password ad the designated prompts.


  3. Note:

    If you are running a standalone server, the SOA server URL should be the URL of the Admin Server. If you are running a cluster environment, the SOA server URL should be the URL of one of the Managed SOA servers.

  4. Press Enter.

The current web services security policy displays and the configurator tool closes. If you need to update or rollback your security policy, you must restart the tool.

3.1.4 Updating to the Agile PLM 9.3.4 Security Policy

Enter option 2 on the Web Services Security Configurator to update your security policy to the Agile PLM 9.3.4 policy (oracle/wss_username_token_over_ssl_client_policy). After enter the required information, the updated policy is attached and the endpoint address is updated for the related web services.

Figure 3-2 Sample output when updating the security policy

Surrounding text describes Figure 3-2 .

You can validate the updated policy with Oracle Enterprise Manager.

3.1.4.1 Updating MDS

To update MDS:

  1. Download the Configuration File from MDS

  2. Update $DOMAIN_LOCATION/soa/aia/MDSUtils/DownloadMetaDataFileDP.xml content:

    <?xml version="1.0" standalone="yes"?>
    <DeploymentPlan>
        <Configurations>
            <DownloadMetadataFile downloadLocation="${env.DOMAIN_LOCATION}/soa/aia/bin/" fileToDownload = "/soa/configuration/default/AIAConfigurationProperties.xml" wlserver="fp" />
        </Configurations>
    </DeploymentPlan>
      
    source <DOMAIN_LOCATION>/soa/aia/bin/aiaenv.sh
    ant -f $SOA_HOME/aiafp/Install/AID/AIAInstallDriver.xml -DPropertiesFile=$DOMAIN_LOCATION/soa/aia/bin/AIAInstallProperties.xml -DDeploymentPlan=$DOMAIN_LOCATION/soa/aia/MDSUtils/DownloadMetaDataFileDP.xml
    
  3. Update AIAConfigurationProperties.xml and AIAInstallProperties.xml in $DOMAIN_LOCATION/soa/aia/bin.

    • If you are updating to the Agile PLM 9.3.4 security policy with web service security configurator:

      • In /properties/participatingapplicatons/agile of AIAInstallProperties.xml, update port to https port and update protocol to https.

      • In AIAConfigurationProperties.xml, replace all Agile URLs from http to https. Fourteen (14) locations should be replaced.

    • If you are restoring the web service security policy with Web Service Security Configurator:

      • In /properties/participatingapplicatons/agile of AIAInstallProperties.xml, update port to https port and update protocol to https.

      • In AIAConfigurationProperties.xml, replace all Agile URLs from http to https. Fourteen (14) locations should be replaced.

  4. Upload into MDS.

  5. Update $DOMAIN_LOCATION/soa/aia/MDSUtils/UpdateMetaDataFileDL.xml content:

    <?xml version="1.0" standalone="yes"?>
    <DeploymentPlan>
        <Configurations>
            <UpdateMetadataFile wlserver="fp" mdslocation="apps/AIAMetaData/config">
                <fileset dir="${env.DOMAIN_LOCATION}/soa/aia/bin">
                    <include name="AIAInstallProperties.xml" />
                </fileset>
            </UpdateMetadataFile>
            <UpdateMetadataFile wlserver="fp" mdslocation="/soa/configuration/default">
                <fileset dir="${env.DOMAIN_LOCATION}/soa/aia/bin">
                    <include name="AIAConfigurationProperties.xml" />
                </fileset>
            </UpdateMetadataFile>
        </Configurations>
    </DeploymentPlan>
     
    source <DOMAIN_LOCATION>/soa/aia/bin/aiaenv.sh
    cd $DOMAIN_LOCATION/soa/aia/MDSUtils/
    ant -f $SOA_HOME/aiafp/Install/AID/AIAInstallDriver.xml -DPropertiesFile=$DOMAIN_LOCATION/soa/aia/bin/AIAInstallProperties.xml -DDeploymentPlan=$DOMAIN_LOCATION/soa/aia/MDSUtils/UpdateMetaDataFileDP.xml
    

3.1.4.2 Setting the SSL Environment

After updating the security policy, you must set the SSL environment between Agile PLM 9.3.4 and the Design to Release: Agile - EBS pre-built Integration. For more information on installing Agile PLM 9.3.4, see Agile Product Lifecycle Management Application Installation Guide, Release 9.3.4.

Here's an example of how to set the SSL environment between Agile PLM 9.3.4 and the Design to Release PIP with self-signed certificates.

To set the SSL environment for Agile PLM 9.3.4:

  1. Create a directory named agile-keystore934 on the machine where the WebLogic files are located.

  2. Change to the newly created directory and run the following command to create the agile-keystore.jks file:

    keytool -genkey -keyalg RSA -alias ssl -keystore agile-keystore.jks -keysize 2048 -storepass <password>

  3. Enter the following information for the key generation command:

    CN=<Weblogic hostname>, OU=<organizationUnit>,O=<organizationName>, L=<localityName>, ST=<stateName>, C=<countryName>

  4. Run the following command to create and export the SSL certificate, agile-ssl-cert:

    keytool -export -file agile-ssl-cert.cer keystore agile-keystore.jks -storepass <password> -alias ssl

  5. Run the following command to import the SSL certificate and create the Trust store:

    keytool -import -file agile-ssl-cert.cer keystore agile-trust-store.jks -storepass <password>

  6. In a web browser, go to http://<Weblogic_hostname:portnumber>/console to open the WebLogic Console.

  7. In the left pane of the Console, select Environment>Servers, then click the Server name on the right pane.

  8. From ServerName>Configuration>General, check SSL Listen Port Enabled.The default port is 7002.

  9. Select Configuration>Keystores, choose Custom Identity and Custom Trust.

  10. In the Identity section, define the following attributes for the identity keystore:

    • Custom Identity Keystore: (Windows example) C:\agile-keystore-934\agile-keystore.jks

    • Custom Identity Keystore Type: JKS

    • Custom Identity Keystore Passphrase: <password>

  11. In the Trust section, define the following properties for the trust keystore:

    • Custom Trust Keystore: (Windows example)

      C:\agile-keystore-934\agile-trust-store.jks

    • Custom Trust Keystore Type: JKS

    • Custom Trust Keystore Passphrase: <password>

  12. Activate the changes in the WebLogic Console.

  13. Connect to the Agile PLM system.

After you have configured SSL on the Agile PLM system, you must make the Integration Server trust the Agile Server.

To make the Integration server trust the Agile Server:

  1. Open a command prompt window and change to the %MW_HOME%/wlserver/server/lib directory.

  2. Copy the agile-ssl-cert.cer file from the Agile PLM server to the Integration server.

  3. Run the following command to import agile-ssl-cert.cer in the Integration server's key store using the DemoTrust keystore:

    keytool -import -file agile-ssl-cert.cer -alias a9-ssl-cert -keystore DemoTrust.jks -storepass DemoTrustKeyStorePassPhrase

  4. In a web browser, go to http://<Weblogic_hostname:portnumber>/console to open the WebLogic Console.

  5. In the left pane of the Console, select Environment>Servers, then click the Server name on the right pane.

  6. Select Configuration>Keystores, choose Custom Identity and Custom Trust.

  7. In the Trust section, define the following properties for the trust keystore:

    • Custom Trust Keystore:%MW_Home%/wlserver/server/lib/DemoTrust.jks

    • Custom Trust Keystore Type: JKS

    • Custom Trust Keystore Passphrase: DemoTrustKeyStorePassPhrase

  8. Save changes.

3.1.5 Restoring Web Services Security Policy

If there is a need to restore the default web services security policy (oracle/wss_http_token_client_policy), enter option 3 on the Web Services Security Configurator. After entering the required information, the default policy is attached and the endpoint address is updated for the related web services.

Figure 3-3 Sample output when restoring the default security policy

Surrounding text describes Figure 3-3 .

3.2 Performing Predeployment Configurations

Configure https enabled Ebiz (Optional)

  1. Obtain the Ebiz environment certificate from the following path: $ORACLE_HOME/appsutil/wallet

  2. Import this Ebiz certificate to the WebLogic server. To import this Ebiz certificate, follow these steps:

    1. Add the keytool to classpath as export CLASSPATH=/slot/ems3486/oracle/Middleware/jrockit-jdk1.6.0_37-R28.2.5-4.1.0/bin:$CLASSPATH

    2. Copy the Ebiz certificate to FMW server.

    3. Import the certificate to WebLogic keystore as

      keytool -import -noprompt -trustcacerts -alias rws3221070 -file /slot/ems3486/oracle/EBSCertificate/ca.cer -keystore /slot/ems3486/oracle/Middleware/jrockit-jdk1.6.0_37-R28.2.5-4.1.0/jre/lib/security/cacerts -storepass changeit

      For example, keytool -import -noprompt -trustcacerts -alias <name> -file <path of fmw where you copied ebiz certificate> -keystore $MW_HOME/jrockit-jdk1.6.0_37-R28.2.5-4.1.0/jre/lib/security/cacerts -storepass <wls store password>

    4. Verify this by listing the certificates in keystore as keytool -list -keystore /slot/ems3486/oracle/Middleware/jrockit-jdk1.6.0_37-R28.2.5-4.1.0/jre/lib/security/cacerts

Modify transaction values

You must modify transaction properties to complete the integration deployment. To modify transaction values:

  1. Log in 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.

    4. Click link More BPEL Configuration Properties.

    5. Change the value of SyncMaxWaitTime from 45 to 120.

    6. Click Apply.

3.3 Installing and Deploying Design to Release: Agile - EBS Pre-Built Integration

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

  1. Install Design to Release: Agile - EBA Pre-built Integration using the Oracle Agile PLM PIP Installer.

  2. Deploy the integration to the Fusion Middleware server.

3.3.1 Installing the Design to Release: Agile - EBS Pre-Built Integration

The screens that appear prompt you to enter the data that is required for successful configuration of the Design to Release: Agile - EBS Pre-Built Integration. Keep the completed worksheet of the Design to Release: Agile - EBS Pre-Built Integration screens ready before you launch the Oracle Agile PLM PIP Installer.


Note:

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

To install the Design to Release: Agile - EBS Pre-Built Integration:

  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. In the setDomainEnv.sh (or .bat) file, replace the following line:

    WLS_JDBC_REMOTE_ENABLED="-Dweblogic.jdbc.remoteEnabled=false"

    with the following changes

    WLS_JDBC_REMOTE_ENABLED="-Dweblogic.jdbc.remoteEnabled=true".


    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.

  3. Restart the server.

  4. Follow the instructions in "Downloading and Starting the Agile PLM for Oracle E-Business Suite: Design to Release Installer" to launch the PIP 3.4 Installer.

  5. Click Next.

3.3.1.1 Specify SOA Admin Server Details

To specify SOA Admin server details:

  1. Enter information related to your integration server in the SOA Admin Server Details screen as described in Section 2.3.1, "SOA Admin Server Details Screen."

  2. Click Next.

3.3.1.2 Specify SOA Server Details

To specify SOA Server details:

  1. Enter information about your SOA Server in the SOA Server Details screen as described in Section 2.3.2, "SOA Server Details Screen."

  2. Click Next.

3.3.1.3 Specify SOA Server Cluster Details (Optional)

To specify SOA Server Cluster details:

  1. Enter information about your SOA Server Cluster, if installed, in the SOA Server Cluster Details screen as described in Section 2.3.3, "SOA Server Cluster Details.".

  2. Click Next.

3.3.1.4 Specify EBS Server Connect Details

To specify EBS Server Connect details:

  1. Enter information about your Oracle E-Business Suite Server installation in the EBS Server Connect Details screen as described in Section 2.3.4, "EBS Server Connect Details Screen."

  2. Click Next.

3.3.1.5 Specify EBS Server Details

To specify EBS Server details:

  1. Enter information about your Oracle E-Business Suite Server in the EBS Server Details screen as described in Section 2.3.5, "EBS Server Details Screen."

  2. Click Next.

3.3.1.6 Specify EBS Database Details

To specify EBS Database details:

  1. Enter information about your Oracle E-Business Suite Database installation in the EBS Database Details screen as described in Section 2.3.6, "EBS Database Details Screen."

  2. Click Next.

3.3.1.7 Specify Agile PLM Server Connect Details

To specify Agile PLM Server Connect details:

  1. Enter information about your Agile PLM installation in the Agile PLM Server Connect Details screen as described in Section 2.3.7, "Agile PLM Server Connect Details Screen."

  2. Click Next.

3.3.1.8 Specify Agile PLM Server Details

To specify Agile PLM Server details:

  1. Enter information about your Agile PLM server version in the Agile PLM Server Details screen as described in Section 2.3.8, "Agile PLM Server Details Screen."

  2. Click Next.

3.3.1.9 Specify PIP Database Connect Details

To specify PIP Database details:

  1. Enter information about your pre-built integration database instance in the PIP Database Connect Details screen as described in Section 2.3.9, "PIP Database Connect Details Screen."

  2. Click Next.

3.3.1.10 Specify PIP Schema Details

To specify PIP Schema details:

  1. Enter information about your PIP Schema details in the PIP Schema Details screen as described in Section 2.3.10, "PIP Schema Details Screen."

  2. Click Next.

3.3.1.11 Specify PIP Item Initial Load Data Location Details

To specify PIP Item Initial Load Data Location details:

  1. Enter information about your initial load instance in the PIP Item Initial Load Data Location Details screen as described in Section 2.3.11, "PIP Item Initial Load Data Location Details Screen."

  2. Click Next.

3.3.1.12 Complete Installation

To complete installation:

  1. Review the configuration information on the Pre-Installation Summary screen.


    Note:

    If you want to make changes to the configuration, click the Back button to go to the screen you want to edit. You can create a response file based on the input provided in the Installer and use it in future when you want to deploy the integration.

    Start the Installer with the -r option to create a response file. On Windows: setup_win.exe -r <response file path and name>. On Linux: ./setup_lin.bin -r <response file path and name>.

    You can install using the steps described in Section 3.3.2, "Installing using the Response File."


  2. Click Install to start the installation.

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

    The system displays any warnings or errors as necessary. You can review the configuration log for additional details.

  3. When the configuration process completes without errors, the Installer displays the Install Complete screen.

  4. Click Done to close the Installer.

3.3.2 Installing using the Response File

To install using the response file:

  1. Navigate to $DOMAIN_LOCATION/soa/aia/bin and run the command source aiaenv.sh for Linux based systems and aiaenv.bat for Microsoft Windows to configure the environment.

  2. Navigate to PIP 3.4 Installer folder and run the command./setup_lin.bin-f <Response File Location and Name> for Linux based systems and ./setup_win.exe -f <Response File Location and Name> for Microsoft Windows.

3.3.3 Prerequisite for E-Business Suite version 12.2.2 or later

To install Design to Release: Agile - EBS Pre-Built Integration PIP 3.4 with E-Business Suite version 12.2.2 or later, you must perform the following steps before installing the PIP:

  1. Navigate to $DOMAIN_LOCATION/soa/aia/bin/AIAInstallProperties.xml

  2. Add the following property for the endpoint URI under properties/participatingapplications/ebiz

    • generateitemnumberservicewsdlurl - WSDL URL for the Generate Item Number service on the EBS ISG server. For example, http://rws3220107.example.com:16043/soa-infra/services/default/XZ1ST222_BSO_inv_ebi_item_GenerateItemNumberService/GenerateItemNumberService_Service?wsdl

    • generateitemnumberserviceendpointuri Endpoint URI of the Genenerate Item Number service on the the EBS ISG server. For example, http://rws3220107.example.com:16043/soa-infra/services/default/XZ1ST222_BSO_inv_ebi_item_GenerateItemNumberService/GenerateItemNumberService_Service

3.3.4 Deploying the Design to Release: Agile - EBS Pre-Built Integration

To deploy the integration to Fusion Middleware server:

  1. Navigate to $DOMAIN_LOCATION/soa/aia/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 3-1 Deployment Command for the Design to Release: Agile - EBS Pre-Built Integration

    Platform Deployment Command

    Linux x86-64

    sh $SERVICES_LOCATION/pips/AgileToEbiz/DeploymentPlans/AgileToEbizDP.sh
    

    Microsoft Windows x64 (64-bit)

    %SERVICES_LOCATION%\pips\AgileToEbiz\DeploymentPlans\AgileToEbizDP.bat
    


    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.

  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 SOA Core Extension 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 integration 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".

3.4 Performing Postdeployment Configuration

This sections describes the postdeployment tasks you must perform after configuring the Design to Release: Agile - EBS pre-built integration. This section includes the following topics:

3.4.1 Cluster Installation

To install the Design to Release: Agile - EBS pre-built integration in a cluster, follow these steps to update the proxy configuration file:

  1. Open the $DOMAIN_LOCATION/config/fmwconfig/components/OHS/ohs1 file.

  2. Add the following code:

    Example 3-1 Queue

    <Location /queue> 
     SetHandler weblogic-handler 
     WebLogicCluster <<PrimaryHost>>:<PrimaryHost 
     Port>>,<<SecondaryHost>>:<SecondaryHost Port>> 
     WLLogFile /tmp/web_log.log 
     </Location> 
    

    Example 3-2 EBIBOMConfigurator

    <Location /EBIBOMConfigurator/ebibomconfigreturnservlet > 
     SetHandler weblogic-handler 
     WebLogicCluster 
     <<PrimaryHost>>:<PrimaryHostPort>>,<<SecondaryHost>>:<SecondaryHost Port>> 
     WLLogFile /tmp/web_log.log 
     </Location>
    

3.4.2 Enabling EBS Security


Note:

There is a known issue regarding deployment. A workaround must be performed before deploying, or deployment will fail. Fore more information on this known issue, see the Release Notes for Agile Product Lifecycle Management Integration Pack for Oracle E-Business Suite: Design to Release, Release 3.4

After configuration of the EBS is complete, you must enable security in the three concurrent programs of the Design to Release: Agile - EBS Pre-Built Integration. To complete this task, perform the following steps:

  1. Set EBS Integration: SOA SERVER USER system profile to Weblogic user.

  2. Set the SOA Password using the SQL script: inveipwd.sql.

    The file is located in EBS APPLICATION_TOP in the following folder: APPL_TOP/inv/12.0.0/patch/115/sql/inveipwd.sql.

    You are prompted to enter the password for the SOA user to be encoded and stored. (This is used by Business Event to invoke RequestorABCS.) The password is stored in FND_VAULT under the module EBI and Vault Key INV_EBI_SOA_PASSWORD.

3.4.3 Configuring Initial Load

To configure the Agile Initial Load for the Design to Release: Agile - EBS Pre-Built Integration, perform the following steps:


Note:

These steps are required to use the Initial Load for the Design to Release: Agile - EBS Pre-Built Integration.

  1. Apply patch 8313714:R12.EGO.C for EBS R12.1.2

  2. Login to the EBS database

  3. Locate and open the EGO_EBI_ITEM_LOAD package

  4. Perform the following changes:

    1. In the GENERATE_EVENTS procedure, replace the following query:

      INSERT INTO EGO_EBI_ITEM_LOAD_LOG (INVENTORY_ITEM_ID,ORGANIZATION_ID, EVENT_ID)
      SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID, NULL
      FROM MTL_SYSTEM_ITEMS_B
      WHERE ORGANIZATION_ID = p_organization_id
      AND bom_item_type in (1, 2, 4)
      AND customer_order_flag = 'Y'
      AND customer_order_enabled_flag = 'Y';
      

      With the following query:

      INSERT INTO EGO_EBI_ITEM_LOAD_LOG (INVENTORY_ITEM_ID,ORGANIZATION_ID, EVENT_ID)
      SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID, NULL
      FROM MTL_SYSTEM_ITEMS_B
      WHERE ORGANIZATION_ID = p_organization_id;
      
    2. In the REGENERATE_FAILED_EVENT procedure, replace the following query:

      DELETE FROM  EGO_EBI_ITEM_LOAD_LOG
      WHERE ORGANIZATION_ID = p_organization_id AND
      EVENT_ID = p_event_id AND
      INVENTORY_ITEM_ID NOT IN(
      SELECT INVENTORY_ITEM_ID
      FROM MTL_SYSTEM_ITEMS_B
      WHERE ORGANIZATION_ID = p_organization_id
      AND bom_item_type in (1, 2, 4)
      AND customer_order_flag = 'Y'
      AND customer_order_enabled_flag = 'Y');
      

      With the following query:

      DELETE FROM  EGO_EBI_ITEM_LOAD_LOG
      WHERE ORGANIZATION_ID = p_organization_id AND
      EVENT_ID = p_event_id AND
      INVENTORY_ITEM_ID NOT IN(
      SELECT INVENTORY_ITEM_ID
      FROM MTL_SYSTEM_ITEMS_B
      WHERE ORGANIZATION_ID = p_organization_id);
      
  5. Recompile the EGO_EBI_ITEM_LOAD package

3.4.4 Enabling the NPR & SYNC Flows

To enable the NPR & SYNC flows in the Design to Release: Agile - EBS Pre-Built Integration, you must update the config.properties file located in NPRpx.jar:


Note:

Before performing any changes, back up the NPRpx.jar file.

  1. In the Agile server, navigate to <AgileHome>/integration/sdk/extensions.

  2. Unzip NPRpx.jar.

  3. Open config.properties file.

  4. Update Host and Port values for the following variables:

    1. WS_LOCATION_CRETEITEMFLOW=http://<<FMWHost>>:<<ManagedPort>>/soa-infra/services/default/SyncItemListAgileReqABCS/client

    2. WS_LOCATION_SYNCITEMFLOW=http://<<FMWHost>>:<<ManagedPort>>/soa-infra/services/default/SyncItemListAgileReqABCS/client

  5. Check that the value for NPR_PX_TIMEOUT is 90000000. This is the recommended value.

  6. Update the SOA_LOGIN_USERNAME and SOA_LOGIN_PASSWORD values with your username and password.

    The password must be encrypted. To encrypt the password:

    1. In the Agile Server, navigate to <AgileHome>/agileDomain/bin

    2. Run the encryption script ./encryptPwdUtil.sh with parameters -algorithm <encryption algorithm>. For example, ./encryptPwdUtil.sh -algorithm {AES:128} -encrypt weblogic#1

  7. Save your changes and rezip NPRpx.jar.

  8. Restart the Agile Server.

3.5 Verifying Deployment

To verify the Design to Release: Agile - EBS Pre-Built Integration deployment:

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

    • For Linux Based Systems: Review the install log located at <DOMAIN_LOCATION>/soa/aia/logs to verify that the integration is successfully installed.

    • For Microsoft Windows: Review the install log located at <DOMAIN_LOCATION>\soa\aia\logs to verify that the integration is successfully installed.

  2. Confirm that the Design to Release: Agile - EBS Pre-Built Integration queue was installed.

    1. Navigate to the PLM integration Queue Management console (http://<server name>:<port number>/queue).

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

  3. Confirm that the Design to Release: Agile - EBS / PIM Pre-Built Integration processes 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:


      Note:

      Services marked as x are not available.

    Table 3-2 Design to Release: Agile - EBS Pre-Built Integration ESB Services

    Mediator Services EBS with PIM + Agile with VM EBS with PIM + Agile EBS + Agile with VM EBS + Agile

    EBS

    BillOfMaterialsConfigurationEBS

    x

    x

    x

    x

    ItemEBSV2





    EngineeringChangeOrderEBS

    EngineeringChangeOrderResponseEBS

    ItemBalanceEBS

    ItemBalanceResponseEBS

    ItemResponseEBSV2

    Adapter Services

    UpdateEngineeringChangeOrderStatusEbizEventConsumer





    CreateEngineeringChangeOrderListEbizAdapter





    GetConfiguratorURLEbizAdapter





    ProcessEbizItemBatchLoadEventConsumer





    QueryEngineeringChangeOrderListEbizAdapter

    QueryItemBalanceListEbizAdapter

    QueryItemListEbizAdapter

    QueryResponsibilityEbizAdapter

    SyncBillOfMaterialsConfigurationEbizJMSConsumer

    x

    x

    SyncBillOfMaterialsConfigurationEbizJMSProducer

    x

    x

    SyncItemListEbizAdapter

    ValidateEngineeringChangeOrderListEbizAdapter

    ACSAXMLJMSConsumer

    Utility Service





    CreateQueueControlService





    QueueProcessorService






    Also check for the items in Table 3-3.


    Note:

    Processes marked as x are not available.

    Table 3-3 Design to Release: Agile - EBS Pre-Built Integration processes

    BPEL Processes EBS with PIM + Agile with VM EBS with PIM + Agile EBS+ Agile with VM EBS+ Agile

    CreateEngineeringChangeOrderListEbizProvABCSImpl

    CreateQueueService

    GenerateItemNumberService

    x

    x

    GetConfiguratorURLEbizProvABCSImpl


    x

    x

    GetConfiguratorURLAgileReqABCSImpl

    x

    x

    ProcessItemListInitialLoadAgileABF





    ProcessItemListInitialLoadEbizABF





    ProcessEngineeringChangeOrderAgileReqABCSImpl

    QueueProcessorServiceImpl

    SyncBillOfMaterialsConfigurationAgileProvABCSImpl

    x

    x

    SyncBillOfMaterialsConfigurationListEbizReqABCSImpl

    x

    x

    SyncItemListAgileReqABCS

    SyncItemListAgileReqABCSImpl

    SyncItemListEbizProvABCSImpl

    UpdateEngineeringChangeOrderListAgileProvABCSImpl

    UpdateEngineeringChangeOrderListEbizReqABCSImpl

    UpdateItemBalanceListAgileProvABCSImpl

    UpdateItemBalanceListEbizReqABCSImpl

    UpdateItemListAgileProvABCSImpl

    UpdateItemListEbizReqABCSImpl

    ValidateEngineeringChangeOrderListAgileReqABCSImpl

    ValidateEngineeringChangeOrderListEbizProvABCSImpl

    TransformAppContextEbizService





    UpdateEngineeringChangeOrderListEbizReqABCS





    UpdateItemBalanceListEbizReqABCS





    UpdateItemListEbizReqABCS







    Note:

    After deploying on Windows and restarting the SOA Server, two composites, ACSAXMLJMSConsumer and SyncBillofMaterialsConfigurationEbizJMSConsumer, cannot be started. For more information, refer to the Release Notes for Agile Product Lifecycle Management Integration Pack for Oracle E-Business Suite: Design to Release.


    Note:

    IF EBS is down, the GenerateItemNumberService does not deploy. An error is generated for the deployment of this service.

  4. Confirm that the SOA Core Extension Manager components were successfully installed.

    1. Navigate to the AIA Console URL: http://<server name>:<port number>/sce.

    2. Log in with server admin user name.

    3. Navigate to Setup, System to access the Application Registry page.

  5. Check the rows for the following sets of values:

    Table 3-4 Application Registry Values for Agile

    Field Value

    Internal ID

    AGILE_01

    System Code

    AGILE_01

    System Description

    Agile PLM Instance 01

    IP Address

    IP address of the Agile PLM system

    URL

    URL of the Agile PLM system

    System Type

    Agile

    Application Type

    PLM

    Version

    9.3.4 (Out of the Box)

    This can be edited to appropriate version of Agile PLM.


Table 3-5 Application Registry Values for EBS Agile

Field Value

Internal ID

Database SID (Example: M00MQ102)

System Code

EBIZ_01

System Description

Oracle E-Business Suite Instance 01

IP Address

IP address of the EBS system

URL

URL of the EBS system

System Type

Ebiz

Application Type

EBIZ_01

Version

Oracle E-Business Suite Version (Example: 12.1.x, 12.1.x with PIM)


3.5.1 Validating Security Policies

For information on validating security policies for the Design to Release: Agile - EBS Pre-Built Integration, see Oracle Application Integration Architecture Design to Release: Agile - EBS Implementation Guide, "Security Policies Validation".

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

For integration implementation, see Oracle Application Integration Architecture Design to Release: Agile - EBS Implementation Guide.

3.6 Undeploying the Design to Release: Agile - EBS Pre-Built Integration

To undeploy the integration from Fusion Middleware Server:

  1. Navigate to $DOMAIN_LOCATION/soa/aia/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 3-6 Un-deployment Command for the Design to Release: Agile - EBS Pre-Built Integration

    Platform Un-deployment Command

    Linux

    ant Uninstall -f $SOA_HOME/aiafp/Install/AID/AIAInstallDriver.xml
    -DPropertiesFile=$DOMAIN_LOCATION/soa/aia/bin/AIAInstallProperties.xml   
    -DDeploymentPlan=$SERVICES_LOCATION/pips/AgileToEbiz/DeploymentPlans/AgileToEbizDPUndeployDP.xml 
    -DDeploymentPolicyFile=$SERVICES_LOCATION/pips/AgileToEbiz/DeploymentPlans/AgileToEbizConditionalPolicyUndeploy.xml 
    -DSupplementaryDeploymentPlan=$SERVICES_LOCATION/pips/AgileToEbiz/DeploymentPlans/AgileToEbizSupplementaryUndeployDP.xml 
    -l $SERVICES_LOCATION/pips/AgileToEbiz/DeploymentPlans/AgileToEbizUndeployDP.log
    

    Microsoft Windows

    ant Uninstall -f %SOA_HOME%\aiafp\Install\AID\AIAInstallDriver.xml 
    -DPropertiesFile=%DOMAIN_LOCATION%\soa\aia\bin\AIAInstallProperties.xml   
    -DDeploymentPlan=%SERVICES_LOCATION%\pips\AgileToEbiz\DeploymentPlans\AgileToEbizDPUndeployDP.xml 
    -DDeploymentPolicyFile=%SERVICES_LOCATION%\pips\AgileToEbiz\DeploymentPlans\AgileToEbizConditionalPolicyUndeploy.xml 
    -DSupplementaryDeploymentPlan=%SERVICES_LOCATION%\pips\AgileToEbiz\DeploymentPlans\AgileToEbizSupplementaryUndeployDP.xml 
    -l %SERVICES_LOCATION%\pips\AgileToEbiz\DeploymentPlans\AgileToEbizUndeployDP.log
    


    Note:

    The log file may show that undeploying has failed. Actually, all deployed composites and applications are removed successfully. To avoid the failure, see the Release Notes for Agile Product Lifecycle Management Integration Pack for Oracle E-Business Suite: Design to Release for more information on how to apply the workaround.

  3. Restart the SOA server.

  4. Uninstall the integration.