8 Upgrading to Oracle AIA 12.2.1

After upgrading to Oracle AIA 12.2.1, the Siebel CRM administrator must perform the following tasks for Siebel CRM:

1. Set up the Oracle WebLogic Server thin client for Siebel CRM:

   1. On the SOA 12.2.1.4 host, navigate to the following directory:

      MW_home/wlserver/server/lib

   2. Copy the wlthint3client.jar file to the JMS directory on the Siebel CRM host. This is the directory containing the JNDI properties, siebel.jar, and siebelUI_enu.jar files.

   3. If the wlfullclient.jar file also appears in the JMS directory on the Siebel CRM host, back the file up to another location and remove it from the JMS directory.

2. In Siebel CRM, from the site map, select Administration - Server Configuration and then select Profile Configuration.

3. In the Enterprise Profiles list, select the row with JAVA in the Alias column.

4. In the Profile Parameters list, select the JVM DLL Name row.

5. In the value column, update the value to the path to the JVM library file for Java Development Kit (JDK) version 1.8.

   For example:

   Oracle_home/Java/jdk1.8.0_102/jre/lib/i386/client/libjvm.so
   

6. Select the JVM Classpath row.

7. In the value column, add the path to the newly-copied wlthint3client.jar file.

   On UNIX, separate files in this field with a colon (:). On Windows, separate files in this field with a semicolon (;).

   For example, on UNIX:

   Oracle_home/jms/Siebel.jar:Oracle_home/jms/wlthint3client.jar
   

8. Restart the Siebel CRM services.

After installing Oracle AIA 12.2.1, you must manually migrate any customizations you made to the source data. There are no automated scripts or tools to assist in this task.

To migrate custom data:

1. For any of the Oracle AIA artifacts listed in Table 8-1, merge any customizations to ready-to-use artifacts and copy custom-created artifacts into the 12.2.1 directory. The artifacts listed in the 12.2.1 Directory and Modified Artifacts column have been updated for 12.2.1. When merging customizations to these artifacts, be careful not to overwrite the updated functionality.

   Table 8-1 Customized Oracle AIA Artifacts to Migrate

   Artifact	12.2.1 Directory and Modified Artifacts
   Enterprise Business Objects Enterprise Business Services WSDL schemas	Directory: The appropriate subdirectory under Comms_home/source/soainfra/apps/AIAMetaData/AIAComponents No modified artifacts.
   Cross reference files	Directory: Comms_home/source/soainfra/apps/AIAMetaData/xref Modified artifacts: CUSTOMERPARTY_PARTYLOCATIONID CUSTOMERPARTY_PAYPROFILEID CUSTOMERPARTY_LOCATIONREFID CUSTOMERPARTY_PARTYCONTACTID CUSTOMERPARTY_BILLPROFILEID SALESORDER_LINEID CUSTOMERPARTY_ACCOUNTID ITEM_ITEMID CUSTOMERPARTY_CONTACTID CUSTOMERPARTY_CONTACT_PHONECOMMID CUSTOMERPARTY_ADDRESSID CUSTOMERPARTY_HIERARCHYBILLINFO CUSTOMERPARTY_PARTYID INSTALLEDPRODUCT_ID CUSTOMERPARTY_DEFAULTBALANCEGROUPID SALESORDER_ID CUSTOMERPARTY_CONTACT_EMAILCOMMID
   Domain value maps	Directory: Comms_home/source/soainfra/apps/AIAMetaData/dvm Modified artifacts: SALESORDER_STATUS ADDRESS_COUNTRYID PRICE_OVERRIDETYPECODE CUSTOMERPARTY_ACCOUNTTYPECODE APPLIES_TO PRICECHARGETYPE SALESORDER_LINESTATUS CUSTOMERPARTY_PAYPROFILE_PAYMETHODCODE ITEM_BILLINGTYPECODE CURRENCY_CODE STATE
   XSLT files	Directory: Comms_home/source/soainfra/apps/services/…/service_name/SOA/Transformations No modified artifacts.

2. Upload any new or changed files to the Oracle Metadata Services repository as described in "Managing Oracle AIA Files in the MDS Repository".

3. For any custom-created source services:

   1. In Oracle JDeveloper version 12.2.1.4, open the .jpr file for the service.

      JDeveloper updates the composite.

   2. Save the project and files under the appropriate directories. For example, save .wsdl files in the WSDL directory.

   3. Deploy the custom services from the JDeveloper context menu. Use the composite.xml file in the service's SOA directory as the deployment descriptor file.

      For information about deploying applications using JDeveloper, see Oracle Fusion Middleware Developing Applications with Oracle JDeveloper.

4. For any ready-to-use source services that you have customized within customizable scopes:

   1. Copy the required composite from the AIA server COMMS_Home/comms_home/source/soainfra/apps or COMMS_Home/comms_home/pips to your local JDeveloper.

   2. Open the project in JDeveloper 12.2.1.4.

   3. Customize the customizable scopes.

   4. Copy the composite and files back to the AIA server location from where they were copied.

   5. Deploy the customized composite from the AIA server using PIP depolyment scripts.

5. For the Agent Assisted Billing Care pre-built integration, manually migrate any customizations made in the source Oracle Data Integrator integration projects to 12.2.1. See Oracle Fusion Middleware Developer's Guide for Oracle Data Integrator for information about customizing Oracle Data Integrator integration projects.

After migrating customizations, you must migrate the data in the following Oracle AIA database tables:

• Migrate the data in the source domainName_AIA schema to the 12.2.1 SOAINFRA schema for the following tables:

  • AIA_ERROR_MONITOR

  • AIA_ERROR_FLEX_FIELD

  Note:

  Because AIA_ERROR_FLEX_FIELD depends on AIA_ERROR_MONITOR, you must migrate the data in AIA_ERROR_MONITOR first.

• Migrate your Oracle AIA cross reference data from the source AIAInstanceName_XREF schema to the 12.2.1 domainName_COMMS_XREF schema created by the Oracle AIA Configuration Wizard (where AIAInstanceName is the name of the source Oracle AIA instance and domainName is the name of the 12.2.1.4 SOA domain). You must migrate one cross reference table at a time.

You can use Oracle SQL Developer to migrate the data as follows:

1. On the source environment in SQL Developer, in the Connections navigator, expand your source database connection, then expand Tables.

2. Right click the table you want to export and select Export.

3. Select the Export Data option, specify the SQL format, and complete the export.

4. Move the exported SQL file from the source environment to the AIA 12.2.1 environment and open it in a text editor.

5. Remove the schema name and keep the file open.

6. On the 12.2.1 environment in SQL Developer, open the SQL Worksheet for your 12.2.1 database connection.

7. From the exported SQL file, copy all SQL statements and paste them into the SQL Worksheet.

8. Click the Run Script icon.

   The data is imported.

Consult your database administrator for help migrating database data and see Oracle SQL Developer User's Guide for more details about using SQL Developer.