Oracle EBS Connector Release Notes - Mule 3

Support Category: Premium

Anypoint Connector for Oracle E-Business Suite (Oracle EBS Connector) provides real-time connectivity to query and update Oracle EBS using web services. Oracle EBS Connector requires an Enterprise license.

4.0.4

March 4, 2020

Compatibility

The Oracle EBS Connector is compatible with:

Application/Service

Version

Mule

3.7.0 and later

Anypoint Studio

5.2.1 and later

Oracle EBS

12.1.x

Java

7

Connector DevKit

3.9.7

Fixed Issues

Removed the connection exception that occurred when the connector was redeployed. (CONN-4368)

4.0.3

November 26, 2019

Release Notes for version 4.0.3 of the Oracle EBS Connector.

Compatibility

The Oracle EBS Connector is compatible with:

Application/Service

Version

Mule

3.7.0 and later

Anypoint Studio

5.2.1 and later

Oracle EBS

12.1.x

Java

7

Connector DevKit

3.9.7

Fixed Issues

Errors in operations no longer throw a NullPointerException.

4.0.2

October 29, 2019

Release Notes for version 4.0.2 of the Oracle EBS Connector.

Compatibility

The Oracle EBS Connector is compatible with:

Application/Service

Version

Mule

3.7 and later

Anypoint Studio

5.2.1 and later

Oracle EBS

12.1.x

Java

7

Connector DevKit

3.9.7

Features

Connector DevKit library was upgraded to version 3.9.7.

4.0.1

December 14, 2016

Release notes for version 4.0.1 of the Oracle EBS Connector.

Compatibility

The Oracle EBS Connector is compatible with:

Application/Service Version

Mule

3.7 and later

Anypoint Studio

5.2.1 and later

Oracle EBS

12.1.x

Java

7

Fixed Issues

XML External Entities (XXE) vulnerability - By default, XML parsers are weakly configured thus enabling XML external entity attack (for example, disclosure of confidential data, denial of service, server side request forgery) when the app parses XML input. To prevent XXE, DTDs (external entities) have been completely disabled in all the XML parsers used by the connector.

4.0.0

July 19, 2016

Release notes for version 4.0.0 of the Oracle EBS Connector.

Compatibility

The Oracle EBS Connector is compatible with:

Application/Service Version

Mule

3.7 and later

Anypoint Studio

5.2.1 and later

Oracle EBS

12.1.x

Java

7

Migrate from Older Versions of the Connector

If you’re currently using the 3.0.0 version of this connector, migrating to the current version implies the steps listed below depending on the use case:

If you are using the connector to consume web services:

  • Edit your global configuration element using the XML editor.

  • Remove the following parameters: dbUser, dbPassword, dbHost, dbPort, and dbSid.

  • You can also remove the aqapi.jar and ojdbc6.jar files from the classpath.

If you are using the connector to subscribe to Business Events or XML Gateway Outbound messages:

  • Create a new Oracle EBS: JMS Configuration element.

  • Add the database connection parameters: host, port, username, password and SID.

  • Add the required dependencies (aqapi.jar and ojdbc6.jar). You can find them in your EBS instance, under the following paths:

    • $ORACLE_HOME/rdbms/jlib/aqapi.jar

    • $ORACLE_HOME/jdbc/lib/ojdbc6.jar

  • Reference this new configuration in all references to the EBS Connector as a message source in your Mule app.

  • If you are not using the connector to consume web services, you can remove the old configuration as it is no longer needed.

Features

Durable subscriptions: when subscribing to Business Events, a durable subscription can be registered. This way, all messages sent to the topic while the client is offline will be retrieved as soon as it regains connectivity.

Fixed Issues

  • Business Events and XML Gateway Outbound: Fixed bug in which the Mule app would stop responding for a period of time when receiving a large number of messages.

  • User Permission: The connector used to require the ALL_USER permission in order for PL/SQL web services to be called in EBS, but this release supports a specific user permission.

3.0.0

January 26, 2016

Release notes for version 3.0.0 of the Oracle EBS Connector.

New Features

TrustStore support: the connector can now be configured with a custom Trust Store, which would prevent calls to web services from failing when using self-signed certificates.

Fixed Issues

Business Events: parsing messages from the Business Events topic is now done dynamically, meaning that all attributes, regardless of whether they are custom or not, will be present in the connector’s output.

2.0.1

October 2, 2015

Release Notes for version 2.0.1 of the Oracle EBS Connector.

This is a minor release, including only bug fixes since the release of 2.0.0.

Fixed Issues

Test Connection button in Global Element Properties screen had not been working. After entering host details and credentials when creating the configuration for Oracle EBS, clicking the Test Connection button produced an error. It has been fixed to check whether the connection to Oracle EBS can be established or not.

Known Issues

None

2.0.0

September 30, 2015

Release notes for version 2.0.0 of the Oracle EBS Connector. These Release Notes accompany the Oracle E-Business Suite Connector guide.

Compatibility

The Oracle EBS Connector is compatible with:

Application/Service Version

Mule

3.6 and later

Anypoint Studio

5.2.1 and later

Oracle EBS

12.1.x

Java

7

Migrate from Older Versions of the Connector

If you’re currently using connector 1.1.0 to migrate to this connector you need to:

  • Edit the Connector Configuration.

  • Add the database connection configuration.

  • Add the required dependencies (aqapi.jar and ojdbc6.jar). You can find them in your EBS instance, under the following paths:

    • $ORACLE_HOME/rdbms/jlib/aqapi.jar

    • $ORACLE_HOME/jdbc/lib/ojdbc6.jar

Features

  • XML Gateway Inbound - The ability to send messages to the XML Gateway Inbound queue in your EBS instance

  • XML Gateway Outbound - You can subscribe to the XML Gateway Outbound queue and receive any messages that are sent to it

  • Business Events - You can subscribe to the Business Events topic to receive messages every time an event is fired

  • New PL/SQL modules

Supported Web Service Operations

The connector supports create/read/save/update operations for the entities listed below through SOA Gateway.

  • DQM Search Service

  • Organization Business Object Service

  • Organization Customer Business Object Service

  • Organization Contact Business Object Service

  • Person Business Object Service

  • Person Customer Business Object Service

  • Location Business Object Service

  • Email Business Object Service

  • Phone Business Object Service

  • Relationship Business Object Service

  • Web Business Object Service

Supported PL/SQL Modules

  • Custom PL/SQL operations

  • Invoice Creation (AR_INVOICE_API_PUB)

  • Location (HZ_LOCATION_V2PUB)

  • Manage Item Instances (CSI_ITEM_INSTANCE_PUB)

  • Party Contact (HZ_PARTY_CONTACT_V2PUB)

  • Process Order API (OE_ORDER_PUB)

  • Purchase Order Acknowledgments Extension Columns API (EC_POAO_EXT)

  • Purchase Order Change Acknowledgments Extension Columns API (EC_POCAO_EXT)

  • Sales Agreement API (OE_BLANKET_PUB)

  • Ship Confirmation (OE_SHIP_CONFIRMATION_PUB)

  • Suppliers Package (AP_VENDOR_PUB_PKG)

  • XXGet Party Details (XXONT_XOA_PARTY)

Fixed Issues

  • Improve error descriptions on Test Connection: previously, when testing connectivity via the Test Connection button, error messages were not helpful. Now, not only does this feature show clearer messages, but it also verifies that the version of EBS is supported by the connector.

  • Date fields on web service responses are mapped to the java.util.Calendar class.

Known Issues

Test connectivity button in Oracle EBS Global Element Config screen is not working. It shows an error message like "Test connection failed: No suitable driver found for jdbc:oracle:thin@…​", even if the required JARs have been supplied.

1.1.0

April 17, 2015

Compatibility

The Oracle EBS connector 1.1.0 is compatible with:

Application/Service Version

Mule

3.6.0 and later

Oracle EBS

v12.1.x

Java

1.7.0_x

Features

  • Renamed invokePLSQL method to invokePlSql.

  • Migrated CXF to 2.7.15.

  • Removed the mule- prefix from the names of all demo projects.

  • Added @RequiresEntitlement annotation to the connector’s main class.

Known Issues

Quarantined the following test cases from the Regression Test Suite because of intermittent failure of the service:

  • GetOrganizationCustomerTestCases

  • GetPersonCustomerTestCases

1.0

March 31, 2015

Compatibility

The Oracle EBS connector 1.0 is compatible with:

Application/Service Version

Mule

3.6.0 and later

Oracle EBS

v12.1.x

Java

1.7.0_x

Features

This release of the Oracle EBS connector provides integration to the following Oracle EBS Suite components:

  • Financial Management and Order Management Modules: Full API coverage for Financials and Order Management services

  • PL/SQL Integration: Standard PL/SQL and user defined PL/SQL can be invoked.