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.
Guide: Oracle EBS Connector - Mule 3
See also: Oracle EBS 12.2 Connector
4.0.4
4.0.3
4.0.2
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
, anddbSid
. -
You can also remove the
aqapi.jar
andojdbc6.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
andojdbc6.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
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.
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.
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 |
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.