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

Part Number E26495-05
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

34 Configuring and Deploying Value Chain Planning Base Pack Integration

This chapter discusses how to configure and deploy the Oracle Value Chain Planning Integration Base Pack (VCP Base Pack integration).

This chapter includes the following sections:

Note for PeopleSoft Users:

This information also covers the integration between PeopleSoft and Demantra. Unless specifically mentioned, references to JD Edwards or JDE should be interpreted as also referring to PeopleSoft.

34.1 Configuring Oracle Data Integrator

To run AIA Pre-Built Integrations Installer you must have Oracle Data Integrator (ODI) access with Supervisor privileges.

For installation purposes, the ODI software must reside at the same server where Foundation Pack is installed. Once the PIP installation is complete, the ODI software can be installed onto another server (if desired) connecting to the master and work repositories used during the PIP installation.

34.1.1 Creating Oracle Data Integrator Repositories

You can use an existing master repository if it exists on an Oracle database and its ID is not 0. If the ID is 0, AIA advises you to create another master repository.

You can use an existing work repository if it exists on an Oracle database and its ID is not 1 or 778. If the ID is 1 or 778, AIA advises you to create another repository and not to use 1 or 778 as the Work Repository ID.

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

AIA recommends that you make a backup copy of master and work repositories before you start the installation process.

For information about creating Oracle Data Integrator master and work repositories, see Oracle Fusion Middleware Developer's Guide for Oracle Data Integrator, "Administering the Oracle Data Integrator Repositories."

34.1.2 Performing Postinstallation Configurations for ODI

Perform the following steps to apply the required patches to your ODI 11.1.1.5.0.

To install prerequisite installer patch #10288265:

  1. Access My Oracle Support [https://support.oracle.com]

  2. Navigate to the Patches & Updates tab

  3. In the Patch Name or Number field, write 10288265

  4. Select your platform

  5. Click Search

  6. Download and install patch #10288265

To install patch #12837214:

  1. Access My Oracle Support [https://support.oracle.com]

  2. Navigate to the Patches & Updates tab

  3. In the Patch Name or Number field, write 12837214

  4. Select your platform

  5. Click Search

  6. Download and install patch #12837214

After applying the patches, launch the ODI Installer:

  1. Go to Topology.

  2. Go to Physical Architecture.

  3. Find the XML technologies and expand it.

    You should see data sources for all DVM's used in your ODI flows.

  4. Select each DVM data source.

  5. Go to the JDBC tab.

  6. Append this to the end of the URL "&back_compat_specific_keywords=true"

  7. Test the data source to make sure the connection is successful.

  8. Save your changes.

For a screenshot of this screen in ODI Installer, see Appendix B, "Oracle Data Integrator Screen".

34.2 Deployment Configuration Wizard

The DCW screens prompt you to enter the data required for successful configuration of VCP Base Pack Integration. Enter the details of VCP Base Pack Integration screens below, take a printout and keep it ready when you run the DCW. This action enables faster and error free configuration.

34.2.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 34-1 PIP Server Details Screen Fields

Field Description

Admin Host Name

Specifies where 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.


34.2.2 JD Edwards EnterpriseOne Inbound Path

Table 34-2 JD Edwards EnterpriseOne Inbound Path Screen

Field Description

JD Edwards EnterpriseOne Inbound Path

The location where files from ODI/APS into JD Edwards are placed. This location can be on the same system or on a shared folder on a remote system.

JD Edwards EnterpriseOne Inbound Path is _________________________


34.2.3 JD Edwards EnterpriseOne Outbound Path

Table 34-3 JD Edwards EnterpriseOne Outbound Path Screen

Field Description

JD Edwards EnterpriseOne Outbound Path

The location where files from JDE into ODI/APS are placed. This location can be on the same system or on a shared folder on a remote system.

JD Edwards EnterpriseOne Outbound Path is _________________________


For more information on directory structures, see the Oracle Value Chain Planning Integration Base Pack Implementation Guide, "ODI Directory Structure".

34.2.4 Demantra Inbound Path

Table 34-4 Demantra Inbound Path Screen

Field Description

Demantra Inbound Path

The location where files from APS into Demantra are placed. This location can be on the same system or on a shared folder on a remote system.

Demantra Inbound Path is __________________________


34.2.5 Demantra Outbound Path

Table 34-5 Demantra Outbound Path Screen

Field Description

Demantra Outbound Path

The location where files from Demantra to APS are placed. This location can be on the same system or on a shared folder on a remote system.

Demantra Outbound Path is __________________________


34.2.6 APS Database Connection Details

Table 34-6 APS Database Connection Details

Field Description

APS Database Host

Specifies the system name. To determine this value, contact the database administrator. Example: server1.oracle.com

APS Database Host is ________________________________

APS Database Port

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

APS Database Port is ________________________________

APS Database Username

This parameter must be set to: msc

APS Database Password

To determine this value, contact the database administrator.

APS Database Password is _____________________________

APS Database SID

To determine this value, contact the database administrator. Example: orcl.

APS Database SID is __________________________________


34.2.7 APS Inbound Path

Table 34-7 APS Inbound Path

Field Description

APS Inbound Path

The location where files from ODI into APS are placed. This location can be on the same system or on a shared folder on a remote system.

The location must be the same as the system where the APS database is hosted.

APS Inbound Path is _______________________________


34.2.8 APS Outbound Path

Table 34-8 APS Outbound Path

Field Description

APS Outbound Path

The location where files from APS into ODI are placed. This location can be on the same system or on a shared folder on a remote system.

The location must be the same as the system where the APS database is hosted.

APS Outbound Path is _______________________________


34.2.9 Oracle Data Integrator Access Details Screen

Use this screen to enter details to access Oracle Data Integrator.

The screen contains the following fields:

Table 34-9 Oracle Data Integrator Access Details Screen Fields

Field Description

Path to Oracle Data Integrator

Provide the path to the ODI HOME.

To find this value, contact your administrator. Example: D:\Oracle\Middleware\Oracle_ODI1\oracledi\agent

Path to Oracle Data Integrator is ___________________________

Path for Exported DVMs

Enter the path to directory to export Domain Value Mappings (DVM).

Path for Exported DVM is _______________________

ODI Username

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

ODI User is ____________________________________

ODI Password

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

ODI Password is _________________________________


34.2.10 Oracle Data Integrator Master Repository Details

You must set up an ODI Master Repository before installing the VCP Base Pack Integration. This master repository must be created in an Oracle database.

The install process appends PIP 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 populate automatically.

The screen contains the following fields:

Table 34-10 Oracle Data Integrator Master Repository Details

Field Description

ODI Master Repository Database Host

To find this value, contact your database administrator. Example: sdc600089seems.compay.com

ODI Master Database Host ___________________________

ODI Master Repository Database Port

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

ODI Master Database Port is__________________________

ODI Master Repository Database Username

To find this value, contact your database administrator. Example: master. This field is also known as the Master Repository Schema Name.

ODI Master Database Username is_______________________

ODI Master Repository Database Password

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

ODI Master Database Password is________________________

ODI Master Repository Database SID

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

ODI Master Database SID is_____________________________


34.2.11 Oracle Data Integrator Work Repository Details

The install process imports the VCP Base Pack Integration 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.

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

The screen contains the following fields:

Table 34-11 Oracle Data Integrator Work Repository Details

Field Description

ODI Work Repository Name

Enter the name you give to the ODI Work Repository for PIP Artifacts. Example: WORK(case sensitive)

ODI Work Repository Name is ___________________________

ODI Work Repository ID

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

ODI Work Repository Password is_________________________________

ODI Work Repository Database Host

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

Database Host is_______________________________

ODI Work Repository Database Port

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

Database Port is________________________________

ODI Work Repository Database Username

To find this value, contact your database administrator. Example: master. This field is also known as the Master Repository Schema Name.

Database Username is_______________________________

ODI Work Repository Database Password

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

Database Password is_________________________________

ODI Work Repository Database SID

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

Database SID is__________________________________


34.3 Configuring and Deploying VCP Base Pack Integration

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

  1. Configure your integration using the deployment DCW.

  2. Deploy the integration to the Fusion Middleware server.

34.3.1 Configuring VCP Base Pack Integration

The screens that appear prompt you to enter the data that is required for successful configuration of VCP Base Pack Integration. Keep the completed worksheets of VCP Base Pack Integration 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 VCP Base Pack Integration:

  1. Navigate to <Middleware Home>/user_projects/domains/soa_domain/bin/ and open setDomainEnv.sh for Linux based systems and setDomainEnv.bat for Microsoft Windows.

    Middleware Home is the directory where Oracle middleware is installed.

  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 VCP Base Pack Integration

  8. Click Next.

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

34.3.1.2 Specify JD Edwards EnterpriseOne Inbound Path

To specify the location of JD Edwards EnterpriseOne Inbound Path:

  1. Enter information about the location of your JD Edwards EnterpriseOne inbound files in the JD Edwards EnterpriseOne Inbound Path screen.

  2. Click Next.

34.3.1.3 Specify JD Edwards EnterpriseOne Outbound Path

To specify the location of JD Edwards EnterpriseOne Outbound Path:

  1. Enter information about the location of your JD Edwards EnterpriseOne outbound files in the JD Edwards EnterpriseOne Outbound Path screen.

  2. Click Next.

34.3.1.4 Specify Demantra Inbound Path

To specify the location of Demantra inbound files details:

  1. Enter information about the location of your Demantra inbound files details in the Demantra Inbound Path screen.

  2. Click Next.

34.3.1.5 Specify Demantra Outbound Path

To specify the location of Demantra outbound files details:

  1. Enter information about the location of your Demantra outbound files details in the Demantra Outbound Path screen.

  2. Click Next.

34.3.1.6 Specify APS Database Connection Details

To specify Advanced Planning and Scheduling Connection details:

  1. Enter information about your APS Database Connection instance in the APS Database Connection Details screen.

  2. Click Next.

34.3.1.7 Specify APS Inbound Path

To specify APS inbound files location:

  1. Enter information about your APS inbound files location in the APS Inbound Path Screen.

  2. Click Next.

34.3.1.8 Specify APS Outbound Path

To specify APS outbound files location:

  1. Enter information about your APS outbound files location in the APS Outbound Path Screen.

  2. Click Next.

34.3.1.9 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 two screens. Enter the following information in the screens.

  2. Specify ODI Home.

  3. Click Next.

  4. Enter ODI User and ODI Password.

  5. Specify the Path to JDK.

  6. Click Next.

34.3.1.10 Oracle Data Integrator Path for Exported DVMs Details

The path for Exported DVMs is not applicable for Oracle Value Chain Planning Integration Pack for JD Edwards EnterpriseOne.

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

34.3.1.12 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 screen.

  2. Click Next.

34.3.1.13 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 34.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.

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

34.3.3 Deploying the VCP Base Pack Integration

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 34-12 Deployment Commands for the VCP Base Pack Integration

    Platform Deployment Command

    Linux

    Solaris SPARC

    IBM AIX Based Systems.

    HP-UX

    ant -f <AIA_HOME>/Infrastructure/Install/AID/AIAInstallDriver.xml 
    -DDeploymentPlan=<AIA_HOME>/pips/VCPJDE/DeploymentPlans/VCPJDEDP.xml 
    -DPropertiesFile=<AIA_HOME>/aia_instances/<aia_instance>/config/AIAInstallProperties.xml 
    -l <AIA_HOME>/pips/VCPJDE/DeploymentPlans/VCPJDE.log
    

    Microsoft Windows

    ant -f <AIA_HOME>\Infrastructure\Install\AID\AIAInstallDriver.xml 
    -DDeploymentPlan=<AIA_HOME>\pips\VCPJDE\DeploymentPlans\VCPJDEDP.xml 
    -DPropertiesFile=<AIA_HOME>\aia_instances\<aia_instance>\config\AIAInstallProperties.xml 
    -l <AIA_HOME>\pips\VCPJDE\DeploymentPlans\VCPJDE.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".

34.4 Performing Postdeployment Configurations

This section discusses postdeployment configurations for the VCP Base Pack Integration. This section includes:

34.4.1 Configuring Environment Variables

Configure the following environment variable:

Table 34-13 Environment Variable Configuration

Environment Variable Description

ODI_BIN_DIR

The location of the ODI program. The recommended location is as follows:

<ODIHOME>/bin

VCPJDE_PIP_HOME

The location of the PIP program. The recommended location is as follows:

<PIP_HOME>/VCPJDE


For more information, see the Oracle Value Chain Planning Integration Base Pack Implementation Guide, "Configuring ODI Variables ".

34.4.2 Verifying Directory Structure

Before using VCP Base Pack Integration, a system administrator must verify if the directories exist according to the directory structure.

For more information, see the Oracle Value Chain Planning Integration Base Pack Implementation Guide, " Setting Up VCP Base Pack Integration".

34.4.3 Launching the VCP Base Pack Integration Agent

Before running a scenario from ODI or a collection from APS, ensure that the VCP Base Pack Java EE agent is running. The name of this agent is OracleDIAgent.

To ensure that OracleDIAgent is running properly:

  1. Log in to the ODI Topology Manager.

  2. Create a new agent called OracleDIAgent.

  3. In the Host field, enter the name of the host where the Java EE agent deploys.

    This is the same host where the Weblogic server runs.

  4. In the Port field, enter the port number of the Admin server in Weblogic server.

  5. Install and configure the Java EE agent.

    For more information on installing and deploying the Java EE agent, see Oracle Fusion Middleware Installation Guide for Oracle Data Integrator, "Installing Oracle Data Integrator". Follow the installation instructions for Java EE.

  6. Return to the OracleDIAgent screen in the Topology Manager and click Test.

34.4.4 Enabling AIA Error Handling (Optional)

The procedure for logging these error messages is provided in each package of the PIP with a six step process grouped in each package. These steps are:

  1. PVV_ERR_MSG: This step stores the error message.

  2. PVV_ERR_STEP: This step stores the step name where scenario has failed.

  3. PVV_ERROR_FLOW_INSTANCE_ID: This step stores the flow name where scenario has failed.

  4. PVV_ERROR_SOURCE_ID: This step stores the source from where data is coming.

  5. ODI Invoke Web Service: This step invokes the web service. All credential like WSDL url, user name, password and so on are to be provided here.

  6. Failure: This step is to purposefully fail the Scenario (APS depends on the actual failure and success of Scenario to show if a request is successful or errored out).

To enable AIA error handling:

  1. Open the package.

  2. Go to diagram tab and select ko step from toolbar.

  3. Connect InsertScenName Step to PVV_ERR_MSG using the ko step.

    Only exception to this step is in Synchronize_XML package where ko step is to be inserted between Synchronize_Xml and OdiInvokeWebService1.

  4. Select the step OdiInvokeWebService1 and view the properties.

  5. Change WSDL URL, HTTP User, and HTTP Password values.

  6. Repeat steps 1 through 5 in each of the package.

  7. Regenerate all the scenarios.

After completing these steps, the AIA error logging can be viewed using BPEL-Console.

34.4.5 Updating the DTD files

DTD files are located at <AIA_HOME>\services\core\BulkDataProcess\VCPJDE\VCP\ODI\Oracle\V1\DTD

  1. Copy Base.dtd, BeginningInventory.dtd, Customer.dtd, Distribution.dtd, Manufacturing.dtd, PurchaseOrders.dtd, SalesOrders.dtd, Supplier.dtd, TimeSeries.dtd, TransferOrders.dtd and WorkOrders.dtd to the directory where the XML files from JDE E1 or PeopleSoft are placed; the JDE E1 Output directory.

  2. Copy DeploymentPlan.dtd, DetailedProductionPlan.dtd, MasterProductionPlan.dtd, PurchasePlan.dtd to the APS Output Directory.

    You must copy and populate the spreadsheet contained in the self extracting file E1VCPUDD.exe. E1VCPUDD.exe resides in <PIP install directory>/html/supplychain/US/.

    It is a self-extracting file that extracts the zip file containing the Excel template for user-defined parameters. The spreadsheet in this file should be copied into the JDE E1 Output directory. Once the data is populated in the spreadsheet, run the Export to File macro to export the spreadsheet data.

Note:

You can check the Physical Topology under Files and XML to see the directory names where the DTDs should be available.

34.5 Verifying Deployment

To verify the VCP Base Pack Integration 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. Confirm that the VCP Base Pack Integration artifacts are installed:

    1. Open the ODI Designer Console.

    2. Verify that you can see the E1APSProject project.

    3. Verify that you can see the following models in the model tab:

      APSToE1ModelFolder

      DemantraToE1ModelFolder

      E1ToAPSModelFolder

      E1ToDemantraModelFolder

    4. Open the ODI Topology Manager console.

    5. Verify that you can see the following Physical Architecture:

      File

      APSFlatFileInDS

      DemantraFlatFileOutDS

      DemantraFlatFileInDS

      E1FlatFileInDS

      E1FlatFileOutDS

      FILE_GENERIC

      LogFileDS

      Datatypes

      Actions

      Caution:

      If you are reinstalling, do not delete the FILE_GENERIC connection. This is a default ODI connection.

      Oracle

      ASCPDS

      WorkRepoDS

      Datatypes

      Actions

      XML

      E1BaseDS

      E1BeginningInventoryDS

      E1CustomerDS

      E1DeploymentPlanDS

      E1DetailedProductionPlanDS

      E1DistributionDS

      E1ManufacturingDS

      E1MasterProductionPlanDS

      E1PurchaseOrdersDS

      E1PurchasePlanDS

      E1SalesOrderDS

      E1SupplierDS

      E1TimeSeriesDS

      E1TransferOrderDS

      E1WorkOrdersDS

      XML_GEO_DIM

      Datatypes

      Actions

      Caution:

      If you are reinstalling, do not delete the XML_GEO_DIM connection. This is a default ODI connection.

    6. Verify that you can see the following Logical Architecture:

      File

      APSFLATFILEIN

      DEMANTRAFLATFILEIN

      DEMANTRAFLATFILEOUT

      E1FLATFILEIN

      E1FLATFILEOUT

      FILE_DEMO_SRC

      LOGFILE

      Datatypes

      Actions

      Caution:

      If you are reinstalling, do not delete the FILE_DEMO_SRC logical connection. This is a default ODI connection.

      Oracle

      ASCP

      WORKREPO

      Datatypes

      Actions

      Xml

      E1BASE

      E1BEGINVENTORY

      E1CUSTOMER

      E1DEPLOYMENTPLAN

      E1DETAILEDPRODPLAN

      E1DISTRIBUTION

      E1MANUFACTURING

      E1MASTERPRODPLAN

      E1PURCHASEORDERS

      E1PURCHASEPLAN

      E1SALESORDERS

      E1SUPPLIER

      E1TIMESERIES

      E1TRANSFERORDERS

      E1WORKORDERS

      XML_DEMO_GEO

      Datatypes

      Actions

      Caution:

      If you are reinstalling, do not delete the XML_DEMO_GEO logical connection. This is a default ODI connection.

34.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 34-14 Service Policy Attachments for VCP Base Pack Integration

      Composite Service Policy

      AIAAsyncErrorHandlingBPELProcess

      aia_wss_saml_or_username_or_http_token_service_policy_OPT_ON


      Table 34-15 No Authentication Client Policy Attachments for VCP Base Pack Integration

      Composite Reference Client Policy

      AIAAsyncErrorHandlingBPELProcess

      OdiInvokeWebService 1

      oracle/no_authentication_client_policy


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 Value Chain Planning Integration Base Pack Implementation Guide.

34.6 Undeploying VCP Base Pack Integration

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 34-16 Undeployment Command for VCP Base Pack Integration

    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/VCPJDE/DeploymentPlans/VCPJDEUndeployDP.xml 
    -l <AIA_HOME>/pips/VCPJDE/DeploymentPlans/VCPJDEUndeployDP.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\VCPJDE\DeploymentPlans\VCPJDEUndeployDP.xml 
    -l <AIA_HOME>\pips\VCPJDE\DeploymentPlans\VCPJDEUndeployDP.log
    

  3. Restart the SOA server.

  4. Uninstall the PIP following the instructions in Chapter 39, "Uninstalling Oracle AIA".