4 Oracle Application Adapter for PeopleSoft Upgrade Guidelines

This chapter lists and describes upgrade guidelines that are specific to the Oracle Application Adapter for SAP R/3. It contains the following topics:

Upgrading a 10.1.3.x ESB J2CA Outbound Process to 11g

Selecting a WSDL From the Local File System

You can follow the same procedure in "Selecting a WSDL From the Local File System".

Selecting a WSDL Using Service Explorer

You can follow the same procedure in "Selecting a WSDL Using Service Explorer".

Upgrading a 10.1.3.x ESB J2CA Inbound Process to 11g

Selecting a WSDL From the Local File System

  1. On the 10.1.3.4 system, create a new target for Oracle Application Adapter for SAP R/3 using Application Explorer and connect to the target.

  2. Create a new channel for Oracle Application Adapter for SAP R/3.

  3. Browse to a specific business object and generate an inbound WSDL for this object.

  4. Restart the server.

  5. Start Oracle JDeveloper 10.1.3.4 and create a JCA inbound ESB Project.

  6. In the Custom Adapter service, select the inbound WSDL from the local file system.

  7. Deploy the ESB project successfully and ensure the registration of the ESB project is successful.

  8. On the 11g system, create a target and channel using the same name that was provided on the 10.1.3.4 system.

  9. Copy the deployed ESB project into the 11g system.

  10. Start Oracle JDeveloper 11g and migrate the 10.1.3.4 ESB project.

  11. Once the project is migrated, a successful message is received in Oracle JDeveloper.

  12. Expand the migrated project and double-click the composite.xml file to ensure that the project opens without any errors.

  13. Double-click the J2CA properties file under the migrated project in Oracle JDeveloper and remove the following line:

    <record-converter className="com.iwaysoftware.afjca15.oracle.InboundXMLRecordConverterImpl"/>

    For example:

    <adapter-config name="DEPT_SYNC_VERSION_1" adapter="iWay ERP Adapter" wsdlLocation="isdsrv14_DEPT_SYNC_receive.wsdl" xmlns="http://platform.integration.oracle/blocks/adapter/fw/metadata"><resource-adapter className="com.iwaysoftware.afjca15.IWAFOracleResourceAdapter"/><record-converter className="com.iwaysoftware.afjca15.oracle.InboundXMLRecordConverterImpl"/>

  14. Save and then deploy the migrated ESB project.

  15. Ensure that there are no error or warning messages during the deployment process.

  16. Trigger the event messages from the ERP system (for example, PeopleTools) and verify that successful response XML files are received in the specified output folder.

Selecting a WSDL Using Service Explorer

  1. On the 10.1.3.4 system, create a new target for Oracle Application Adapter for SAP R/3 using Application Explorer and connect to the target.

  2. Create a new channel for Oracle Application Adapter for SAP R/3.

  3. Browse to a specific business object and generate an inbound WSDL for this object.

  4. Restart the server.

  5. Start Oracle JDeveloper 10.1.3.4 and create a JCA inbound ESB Project.

  6. In the Custom Adapter service, select the inbound WSDL using Service Explorer.

  7. Deploy the ESB project successfully and ensure the registration of the ESB project is successful.

  8. On the 11g system, create a target and channel using the same name that was provided on the 10.1.3.4 system.

  9. Copy the deployed ESB project into the 11g system.

  10. Open the project folder and edit the DefaultSystem_CustomAdapterServiceName.esbsvc file (for example, DefaultSystem_dept_sync_wsdl_brows.esbsvc) and DefaultSystem_CustomAdapterServiceName_RS.esbsvc file (for example, DefaultSystem_dept_sync_wsdl_brows_RS.esbsvc) by providing the system IP address and port number (for example, 192.168.128.122:80) of the 10.1.3.4 WSDL generated system in the <wsdlURL> sections. For example:

    1. Original (DefaultSystem_dept_sync_wsdl_brows.esbsvc)

    <interface> <wsdlURL>http://127.0.0.1:80/orainfra/wsil/adapters/applications/isdsrv14_DEPT_SYNC_receive_esb.wsdl?wsdl</wsdlURL>------------------</interface>

    Modified (DefaultSystem_dept_sync_wsdl_brows.esbsvc)

    <interface> <wsdlURL>http://192.168.128.122:80/orainfra/wsil/adapters/applications/isdsrv14_DEPT_SYNC_receive_esb.wsdl?wsdl</wsdlURL>------------------</interface>

    2. Original (DefaultSystem_dept_sync_wsdl_brows_RS.esbsvc)

    <serviceDefinition><wsdlURL>http://127.0.0.1:80/orainfra/wsil/adapters/applications/ isdsrv14_DEPT_SYNC_receive_esb.wsdl?wsdl</wsdlURL>--------------------------</endpointDefinition></serviceDefinition>

    Modified (DefaultSystem_dept_sync_wsdl_brows_RS.esbsvc)

    <serviceDefinition><wsdlURL>http://192.168.128.122:80/orainfra/wsil/adapters/applications/ isdsrv14_DEPT_SYNC_receive_esb.wsdl?wsdl</wsdlURL>--------------------------</endpointDefinition></serviceDefinition>

  11. Start Oracle JDeveloper 11g and migrate the 10.1.3.4 ESB project.

  12. Once the project is migrated, a successful message is received in Oracle JDeveloper.

  13. Expand the migrated project and double-click the composite.xml file to ensure that the project opens without any errors.

  14. Double-click the J2CA properties file under the migrated project in Oracle JDeveloper and remove the following line:

    <record-converter className="com.iwaysoftware.afjca15.oracle.InboundXMLRecordConverterImpl"/>

    For example:

    <adapter-config name="DEPT_SYNC_VERSION_1" adapter="iWay ERP Adapter" wsdlLocation="isdsrv14_DEPT_SYNC_receive.wsdl" xmlns="http://platform.integration.oracle/blocks/adapter/fw/metadata"><resource-adapter className="com.iwaysoftware.afjca15.IWAFOracleResourceAdapter"/><record-converter className="com.iwaysoftware.afjca15.oracle.InboundXMLRecordConverterImpl"/>

  15. Save and then deploy the migrated ESB project.

  16. Ensure that there are no error or warning messages during the deployment process.

  17. Trigger the event messages from the ERP system (for example, PeopleTools) and verify that successful response XML files are received in the specified output folder.

Upgrading a 10.1.3.x BPEL J2CA Outbound Process to 11g

Selecting a WSDL From the Local File System

  1. On the 10.1.3.4 system, create a new target for Oracle Application Adapter for SAP R/3 using Application Explorer and connect to the target.

  2. Browse to a specific business object and export the schemas into the default location.

  3. Generate the outbound WSDL for the specific business object.

  4. Modify the request and response schema that was exported from Application Explorer by changing the elementFormDefault value from unqualified to qualified.

  5. Restart the server.

  6. Start Oracle JDeveloper 10.1.3.4 and create a JCA outbound BPEL Project by uploading the request and response schema that is modified in step 4.

  7. In the Partner Link, select the outbound WSDL from the local file system.

  8. Deploy the BPEL project successfully and ensure that there are no error or warning messages during the deployment process.

  9. On the 11g system, create a target using the same name that was provided on the 10.1.3.4 system.

  10. Copy the deployed BPEL project into the 11g system.

  11. Start Oracle JDeveloper 11g and migrate the 10.1.3.4 BPEL project.

  12. Once the project is migrated, a successful message is received in Oracle JDeveloper.

  13. Expand the migrated project and double-click the composite.xml file to ensure that the project opens without any errors.

  14. Save and then deploy the migrated BPEL project.

  15. Ensure that there are no error or warning messages during the deployment process.

  16. Open the Oracle Enterprise Manager console and invoke the input XML in XML / Tree view to receive a successful response XML.

Selecting a WSDL Using Service Explorer

  1. On the 10.1.3.4 system, create a new target for Oracle Application Adapter for SAP R/3 using Application Explorer and connect to the target.

  2. Browse to a specific business object and export the schemas into the default location.

  3. Generate the outbound WSDL for the specific business object.

  4. Modify the request and response schema that was exported from Application Explorer by changing the elementFormDefault value from unqualified to qualified.

  5. Restart the server.

  6. Start Oracle JDeveloper 10.1.3.4 and create a JCA outbound BPEL Project by uploading the request and response schema that is modified in step 4.

  7. In the Partner Link, select the outbound WSDL from Service Explorer.

  8. Deploy the BPEL project successfully and ensure that there are no error or warning messages during the deployment process.

  9. On the 11g system, create a target using the same name that was provided on the 10.1.3.4 system.

  10. Copy the deployed BPEL project into the 11g system.

  11. Edit the bpel.xml file for the WSDL location in the 10.1.3.4 project folder (Project_Name\bpel):

    <partnerLinkBinding name="DEPT"><property name="wsdlLocation">http://192.168.128.125:80/orainfra/wsil/adapters/applications/isdsrv14_DEPT_invoke.wsdl?wsdl </property></partnerLinkBinding>

    Where the IP address and port number refer to the 10.1.3.4 system where the WSDL was generated.

  12. Ensure that the 10.1.3.4 server is up and running.

  13. Start Oracle JDeveloper 11g and migrate the 10.1.3.4 BPEL project.

  14. Once the project is migrated, a successful message is received in Oracle JDeveloper.

  15. Expand the migrated project and double-click the composite.xml file to ensure that the project opens without any errors.

  16. Save and then deploy the migrated BPEL project.

  17. Ensure that there are no error or warning messages during the deployment process.

  18. Open the Oracle Enterprise Manager console and invoke the input XML in XML / Tree view to receive a successful response XML.

Upgrading a 10.1.3.x BPEL J2CA Inbound Process to 11g

Selecting a WSDL From the Local File System

You can follow the same procedure in "Selecting a WSDL From the Local File System".

Selecting a WSDL Using Service Explorer

You can follow the same procedure in "Selecting a WSDL Using Service Explorer".