Release Notes for Version 2.5.0 of the IBM WebSphere Business Integration Adapter for Oracle Applications

These release notes cover release information for version 2.5.0 of the IBM(R) WebSphere(R) Business Integration Adapter for Oracle Applications. These release notes contain the following sections:
New in this release WebSphere Business Integration Adapters API and run time
Product fix history Known problems and workarounds
Hardware and software requirements Documentation
Installation, migration, upgrade, configuration

Note: Important information about this product may be available in Technical Support Flashes issued after these release notes were published. These can be found on the WebSphere Business Integration support Web site, http://www.ibm.com/websphere/integration/wbiserver/support. Select the component area of interest and search the flashes section.

New in this release

This release contains the following new features and improvements:

Refer to the Adapter for Oracle Applications User Guide for detailed information about the adapter and the new features.

Product fix history

Between release 2.4.0 and 2.5.0, the following CRs, based on customer-reported cases, were fixed.

Tracking
number
Description
32508/
14585
The connector uses the default value for polling if the object key uses a name-value pair.
30774 Performance improvements are needed for the adapter.
28588 Traceable SQL messages are built only if tracing is enabled.
28591 Improvements are needed in the tracing mechanism.
28868 Stored procedures should be supported for the DeltaUpdate verb.
30436 A null pointer exception occurs when the event or archive time is blank.
32484 The connector's treatment of date fields should be modified.
32390 Issues with SQL scripts in the dependencies subdirectory should be resolved.
32647 The sample needs to be changed, so that a NumberFormat exception does not occur.
29080 Adapter calls are not obeying the timeout.
31569 The adapter should return output parameters even when the result set is "true" and empty.
32392 When the database goes down, the polling connection is not refreshed in the Event Monitor.
29822 The connector generates an unsupported ObjectEventID format.
28594 DeltaUpdate verb support should be added in the ODA.
32473 The ODA should expose nicknames.
34612 A means to reduce the number of commits in the connector is needed.

Hardware and software requirements

Hardware and software requirements are included in the product documentation. See Installation, migration, upgrade, and configuration information for links to those guides.

Installation, migration, upgrade, and configuration

Whether you are installing the software from the CD or downloading it from Passport Advantage and installing it from a local directory, refer to the appropriate guide:

These guides also include general migration, upgrade, and configuration information.

For hardware and software requirements and configuration information specific to this adapter, refer to the Adapter for Oracle Applications User Guide.

Upgrade notes

WebSphere Business Integration Adapters API and run time

Make sure that you run this version of the adapter with WebSphere Business Integration Adapters run-time version 1.7.0 or later.

The WebSphere Business Integration Adapters API .jar files and the associated scripts (CWConnEnv.bat and CWODAEnv.bat for Windows(R); CWConnEnv.sh and CWODAEnv.sh for UNIX platforms) are installed by the WebSphere Business Integration Adapters API. Before installing the adapter, make sure that the WebSphere Business Integration Adapters run time is installed. If the version is not 1.7.0 or later, you must download the latest API. This section provides instructions for verifying the API version, downloading the latest version, and enabling the adapter to run on various versions of InterChange Server and Adapter Development Kit (ADK).

Verifying the run-time version

To check the version of the run time, locate the manifest file (ProductDir\lib\WBIA.jar) and open it in a suitable Java JAR editor. Look for the following lines:

Implementation-Title: "CWConnectorAPI"
Implementation-Version: 1.7.0

The line Implementation-version indicates the installed version of the API. If the version is not 1.7.0 or later, you must download the latest run time.

Downloading the run time

To download the latest version of the run time:

  1. Go to http://www.ibm.com.
  2. Click the Support & downloads tab.
  3. Under the Downloads heading, click Downloads & drivers.
  4. In the Enter search terms field, type "wbia api" and click Submit.

After you download and install the run time, you should see the following files:

lib\WBIA.jar
lib\WBIA\3.0.0\WBIA.jar
lib\WBIA\4.0.0\WBIA.jar
lib\WBIA\4.1.1\WBIA.jar
lib\WBIA\4.2.0\WBIA.jar
bin\CWConnEnv.bat (Windows)
bin/CWConnEnv.sh (UNIX)
bin\CWODAEnv.bat (Windows)
bin/CWODAEnv.sh (UNIX)
connectors\messages\CwConnectorAgentMessages.txt

Enabling adapters for earlier versions of Adapter Development Kit and InterChange Server

To enable an adapter to work with various versions of ADK or InterChange Server, follow the appropriate procedure below:

InterChange Server versions 4.1.x (except 4.1.0), ADK versions 2.1.x
InterChange Server versions 4.2.0 and 4.2.1, ADK versions 2.3.0 and 2.3.1
Running an Object Discovery Agent (ODA) against InterChange Server versions 4.1.x (except 4.1.0), ADK versions 2.1.x
Running an Object Discovery Agent (ODA) against InterChange Server versions 4.2.0 and 4.2.1, ADK versions 2.3.x

Known problems and workarounds

The following problems have been found in this release:

Tracking
number
Description
35033 The OracleApps connector places commas in integers of a retrieved business object. The WebSphere Business Integration Adapters components setInt method applies the default locale settings on the numbers before setting attributes on the business object. This applies default number formatting on the number and places the commas in the numbers.

Use WebSphere Business Integration Adapters API 1.6.2 Fix Pack and add or set the following adapter properties to "true:" DisableNumberFormatGrouping and DisableLocaleFormating. If set to "true," the DisableNumberFormatGrouping alone will handle the commas in the numbers. The DisableLocaleFormating is a master property which overrides all formatting. It can be used if any other problems are encountered due to formatting
41967 The framework cannot process more than 20,000 property values either when displaying the ODA configuration properties or when asking the user for business object definition-specific properties. Ensure that no more than 10,000 values are returned in the drop down list, or the ODA will hang.
46118 For a RetrieveByContent request that returns MULTIPLE_HITS, the following exception occurs: "An unexpected exception occurred during the construction of a business object. Reason: java.lang.IndexOutOfBoundsException: Index: 1, Size: 1." This will be fixed in Fix Pack 2.4.0.1 of the Adapter Runtime, scheduled to be published in early July, 2004.
41966 The OracleApps ODA cannot generate a business object from the nickname of a stored procedure when using the Oracle thin driver, because the driver does not support analysis of Synonyms to StoredProcedures. To work around this, either use the actual stored procedure name to generate the business object using the ODA, or construct the business object manually.
If you are using a DataDirect JDBC driver, you will see the following issues:
41977 When using the DataDirect SQL driver, the OracleApps ODA does not generate appropriate application-specific information for stored procedures that return result sets. The driver does not support analysis of the return type when the stored procedure returns a result set. For example, the stored procedure returns @RETURNVALUE, which the ODA cannot use to generate an attribute. To work around this, manually add the attribute in the business object definition.
The DataDirect Oracle driver does not provide information on keys when the business object is generated from the nickname of a table, and it does not support analysis of nicknames. To work around this, you will have to modify the business object after it is generated.

Documentation

Product documentation is not included as part of the product package, either by CD or by electronic product distribution. The documentation for this product can be found in the following InfoCenters:

To obtain the product documentation, visit the Web site and download the current documentation set for the release that you are using. Follow the instructions provided on the InfoCenter page to complete the installation.

Copyright IBM Corp. 1997, 2004