---
schema_version: "1"
id: 92ac93be716b994f5b6ce3658862892239ab2e077c02fc03a8ce6beb09fcd0af
title: Oracle E-Business Suite 12.2 Connector 2.3
collection: mulesoft
version: current
locale: en-us
portal_url: https://docs.salesforce.com/mulesoft/current/en-us/oracle-ebs-122-connector/latest/index.md
canonical_url: https://docs.mulesoft.com/oracle-ebs-122-connector/latest/
source_site: docs.mulesoft.com
content_type: documentation
content_hash: e3ce867edc9f5148117e9c8d51559999fbd16b1a8c9827a16e7e143404bb8866
description: MuleSoft Documentation Site
release: "2.3"
latest: true
---
---
product: Oracle EBS 12.2 Connector
version: 2.3
is-latest-version: true
---

# Oracle E-Business Suite 12.2 Connector 2.3

> For the full documentation index, see: https://docs.mulesoft.com/llms.txt

Oracle EBS 12.2 Connector v2.3

Anypoint Connector for Oracle E-Business Suite 12.2 (EBS 12.2 Connector) facilitates connections
between Mule runtime engine (Mule) integration and Oracle E-Business Suite 12.2 applications.

## About the Connector Architecture

Oracle EBS offers different technologies or products to address various types of integrations. The
most widely used integrations for enterprise applications are:

- Data-centric integration

- Integration through Web Services using Oracle E-Business Suite Integrated SOA Gateway (ISG)

The following illustration shows the integration architecture of the MuleSoft Oracle EBS connector:

![Oracle EBS 12.2 Connector Architecture](/mulesoft/current/en-us/oracle-ebs-122-connector/latest/_images/oracle-ebs122-architecture.png)

## Before You Begin

To use this connector, you must be familiar with:

- Oracle E-Business Suite

- Web services and integration scenarios for your Oracle EBS version

- Anypoint Connectors

- Anypoint Studio

- Mule concepts

- Elements in a Mule flow and global elements

You must also have:

- Oracle EBS login credentials to test your connection to your target resource

- Anypoint Studio

- Web service configuration in Oracle EBS

  Configuring Oracle EBS 12.2 Connector requires configuring REST web services in Oracle EBS and
  exposing them via the Integration Repository. For more information about how to configure Oracle
  EBS, refer to [To Use the Connector](#to-use-the-connector).

- FND\_WEB\_SEC PL/SQL Service

  The connector requires Oracle EBS to have the FND\_WEB\_SEC PL/SQL service deployed.

- REST Service Locator

  The connector requires Oracle EBS to have the REST Service Locator deployed as a REST service.

- WADL names in lower case

  WADLs corresponding to deployed PL/SQLs must have their internal names in lower case as an alias.
  For example, to deploy `PLSQL Interface : Absence Attendance Type`, which has
  `HR_ABSENCE_TYPE_API` as the internal name, its service alias must be `hr_absence_type_api`.

For software requirements and compatibility information, see the Connector Release Notes.

## POM File Information

```xml
<dependency>
  <groupId>com.mulesoft.connectors</groupId>
  <artifactId>mule-oracle-ebs-122-connector</artifactId>
  <version>x.x.x</version>
  <classifier>mule-plugin</classifier>
</dependency>
```

Replace `x.x.x` with the version that corresponds to the connector you are using.

To obtain the most up-to-date `pom.xml` file information, access the connector in
[Anypoint Exchange](https://www.mulesoft.com/exchange/) and click **Dependency Snippets**.

## Add the Connector to a Studio Project

Anypoint Studio provides two ways to add the connector to your Studio project:

- From the Exchange button in the Studio taskbar

- From the Mule Palette view

### Add the Connector Using Exchange

1.  In Studio, create a Mule project.

2.  Click the Exchange icon **(X)** in the upper-left of the Studio task bar.

3.  In Exchange, click **Login** and supply your Anypoint Platform username and password.

4.  In Exchange, search for "ebs".

5.  Select the connector and click **Add to project**.

6.  Follow the prompts to install the connector.

### Add the Connector in Studio

1.  In Studio, create a Mule project.

2.  In the Mule Palette view, click **(X) Search in Exchange**.

3.  In **Add Modules to Project**, type "ebs" in the search field.

4.  Click this connector’s name in **Available modules**.

5.  Click **Add**.

6.  Click **Finish**.

## To Use the Connector

1.  Deploy the REST Service location so that you can later expose your PL/SQL services for the
    connector to consume. See the Oracle Developer’s Guide Tutorial link in the See Also section.

    The following steps describe the procedure to deploy the PL/SQL Adjustment API as a REST
    service. The same guide applies to any PL/SQL.

2.  Log in to the Oracle E-Business Suite as a user who has the Integration Administrator role.

3.  Select the Integrated SOA Gateway responsibility and the Integration Repository link from the
    navigation menu.

4.  In the Integration Repository tab, click **Search** to access the main Search page.

5.  Click **Show More Search Options** to display more search fields.

6.  Enter the following key search values as the search criteria:

    - Category: `Interface Subtype`

    - Category Value: `PL/SQL`

    - Internal Name: `FA_ADJUSTMENT_PUB`

      ![Deploy PL/SQL Search page](/mulesoft/current/en-us/oracle-ebs-122-connector/latest/_images/oracle-ebs122-deploy-plsql-1.png)

7.  Click **Go** to execute the search.

8.  Click the **Adjustments API** link to see the interface details.

    ![Deploy PL/SQL Adjustment API page](/mulesoft/current/en-us/oracle-ebs-122-connector/latest/_images/oracle-ebs122-deploy-plsql-2.png)

9.  Click the REST Service Locator interface name link to open the interface details page.

10. In the REST Web Service tab, enter the following information:

    ![Deploy PL/SQL Adjustment API configuration](/mulesoft/current/en-us/oracle-ebs-122-connector/latest/_images/oracle-ebs122-deploy-plsql-3.png)

    **Important:** The alias of the deployed Web Service MUST be:
    1.  The internal name.
    2.  In lowercase. The alias information can be found under the Service Alias label. In this
        example, it is fa\_adjustment\_pub.

11. Click **Deploy** to deploy the service to an Oracle E-Business Suite WebLogic environment.

    After the REST service successfully deploys, `Deployed` appears in the REST Service Status field
    along with the View WADL link.

12. Click the **View WADL** link to view the deployed service WADL description.

    ![Deploy PL/SQL Adjustment API deployed](/mulesoft/current/en-us/oracle-ebs-122-connector/latest/_images/oracle-ebs122-deploy-plsql-4.png)

## To Configure in Studio

1.  Drag a connector operation to the Anypoint Studio canvas.

2.  Configure the Global element for the connector.

    ![Global elements properties window](/mulesoft/current/en-us/oracle-ebs-122-connector/latest/_images/oracle-ebs122-config-studio11.png)

    <table><colgroup><col> <col></colgroup><thead><tr><th>Field</th><th>Description</th></tr></thead><tbody><tr><td><p><strong>Host</strong></p></td><td><div><div><p>Host of the Oracle EBS instance</p></div></div></td></tr><tr><td><p><strong>Port</strong></p></td><td><div><div><p>Port of the Oracle EBS Web Services</p></div></div></td></tr><tr><td><p><strong>SSL enabled</strong></p></td><td><div><div><p>If checked, the connector makes Web Services calls using HTTPS instead of HTTP</p></div></div></td></tr><tr><td><p><strong>Username</strong></p></td><td><div><div><p>Username to log in to Oracle EBS Web Services</p></div></div></td></tr><tr><td><p><strong>Password</strong></p></td><td><div><div><p>Password for the username</p></div></div></td></tr><tr><td><p><strong>Rest Service Locator alias</strong></p></td><td><div><div><p>Name assigned to the Web Service with the internal name <code>oracle.apps.fnd.rep.ws.service.EbsRestLocator</code> when deployed</p></div></div></td></tr><tr><td><p><strong>FND Web Sec alias</strong></p></td><td><div><div><p>Name assigned to the PL/SQL Web Service with the internal name <code>FND_WEB_SEC</code> when deployed</p></div></div></td></tr><tr><td><p><strong>Responsibility name</strong></p></td><td><div><div><p>Oracle EBS responsibility name that is needed to execute the operation. This field accepts <code>responsibility_key</code>.</p></div></div></td></tr><tr><td><p><strong>Responsibility application name</strong></p></td><td><div><div><p>Application short name that is needed to execute the operation</p></div></div></td></tr><tr><td><p><strong>Security group name</strong></p></td><td><div><div><p>(Optional) Security group key of the Oracle EBS instance (<code>STANDARD</code> by default)</p></div></div></td></tr><tr><td><p><strong>NLS language</strong></p></td><td><div><div><p>(Optional) NLS language of the Oracle EBS instance (<code>AMERICAN</code> by default)</p></div></div></td></tr><tr><td><p><strong>Org. ID</strong></p></td><td><div><div><p>(Optional) Organization ID of the Oracle EBS instance</p></div></div></td></tr></tbody></table>

## Log Requests and Responses

To log requests and responses when using the connector, configure a logger by adding this line to
the `Loggers` element of the `log4j2.xml` configuration file for the Mule app:

```xml
<AsyncLogger name="name="org.mule.service.http.impl.service.HttpMessageLogger" level="DEBUG"/>
```

The following example shows the `Loggers` element with the `AsyncLogger` line added:

```xml
<?xml version="1.0" encoding="UTF-8"?>
<Configuration status="WARN">
	<Appenders>
	    <Console name="Console" target="SYSTEM_OUT">
	    	<PatternLayout pattern="%d{HH:mm:ss.SSS} [%t] %-5level %logger{36} - %msg%n"/>
		</Console>
	</Appenders>
	<Loggers>
		<AsyncLogger name="org.mule.service.http.impl.service.HttpMessageLogger" level="DEBUG" additivity="false">
			<appender-ref ref="Console" level="debug"/>
		</AsyncLogger>
	</Loggers>
</Configuration>
```

You can view the app log in the following ways:

- If you’re running the app from the Anypoint Platform, the output is visible in the Anypoint Studio
  console window.

- If you’re running the app using Mule from the command line:

  - The app log is visible in your OS console.

  - Unless the log file path was customized in the app’s log file (`log4j2.xml`), you can also view
    the app log in this default location:

`MULE_HOME/logs/<app-name>.log`

For more information about the app log, see
[Configuring Logging](https://docs.mulesoft.com/mule-runtime/latest/logging-in-mule).

## Use Case: Create an Oracle EBS 12.2 Global Element

Follow the steps below to create an Oracle EBS 12.2 global element for Web Services and PL/SQL
invocation:

![Studio flow with Listener, Transform Message, and Invoke PL/SQL REST Service](/mulesoft/current/en-us/oracle-ebs-122-connector/latest/_images/oracle-ebs122-flow.png)

1.  Create a new Mule Project in Studio and select an HTTP Listener as a source in the new flow.

2.  Add a new HTTP Listener global element configuration.

    1.  Specify the **Host** and **Port** parameters with the following values:

        <table><colgroup><col> <col></colgroup><thead><tr><th>Parameter</th><th>Value</th></tr></thead><tbody><tr><td><p><strong>Host</strong></p></td><td><div><div><p>0.0.0.0</p></div></div></td></tr><tr><td><p><strong>Port</strong></p></td><td><div><div><p>8081</p></div></div></td></tr></tbody></table>

    2.  Click **Save**.

3.  Assign the new global configuration to your HTTP Listener.

4.  Specify the HTTP Listener path as the `/start` value.

5.  Drag a **Transform Message** element and add it the following code:

    ```dataweave
    %dw 2.0
    output application/xml
    ns ns0 http://xmlns.oracle.com/apps/per/rest/hr_location_api/create_location/
    ---
    {
      ns0#InputParameters: {
        ns0#P_VALIDATE: 0,
        ns0#P_EFFECTIVE_DATE: now,
        ns0#P_LOCATION_CODE: "HR- MuleSoft Office",
        ns0#P_DESCRIPTION: "Description Office"
      }
    }
    ```

6.  Drag a new Oracle E-Business Suite 12.2 component into the flow.

7.  In the **General** tab, configure the Oracle E-Business Suite 12.2 connector global element with
    its environment values.

8.  In the properties editor of Oracle E-Business Suite 12.2 connector, set **PL/SQL** to
    `hr_location_api` and **Operation** to `CREATE_LOCATION`:

    ![Oracle Create Location operation properties window](/mulesoft/current/en-us/oracle-ebs-122-connector/latest/_images/oracle-ebs122-operation1.png)

9.  Copy the following content under the **Message > Body** section:

    #\[payload\]

10. Save and run the project as a Mule application.

11. Navigate to `http://127.0.0.1:8081/start` to test the application.

## Use Case: XML

```xml
<?xml version="1.0" encoding="UTF-8"?>

<mule xmlns:oracle-ebs122="http://www.mulesoft.org/schema/mule/oracle-ebs122"
xmlns:ee="http://www.mulesoft.org/schema/mule/ee/core"
xmlns:http="http://www.mulesoft.org/schema/mule/http"
xmlns="http://www.mulesoft.org/schema/mule/core"
xmlns:doc="http://www.mulesoft.org/schema/mule/documentation"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://www.mulesoft.org/schema/mule/core
http://www.mulesoft.org/schema/mule/core/current/mule.xsd
http://www.mulesoft.org/schema/mule/http
http://www.mulesoft.org/schema/mule/http/current/mule-http.xsd
http://www.mulesoft.org/schema/mule/ee/core
http://www.mulesoft.org/schema/mule/ee/core/current/mule-ee.xsd
http://www.mulesoft.org/schema/mule/oracle-ebs122
http://www.mulesoft.org/schema/mule/oracle-ebs122/current/mule-oracle-ebs122.xsd">
		<configuration-properties file="mule-app.properties"/>

	<http:listener-config name="HTTP_Listener_config" doc:name="HTTP Listener config" basePath="/" >
		<http:listener-connection host="0.0.0.0" port="8081" />
	</http:listener-config>
	<oracle-ebs122:config name="Oracle_ebs122_Config" doc:name="Oracle-ebs122 Config" >
		<oracle-ebs122:plsql-connection host="${config.host}"
		port="${config.port}" username="${config.username}"
		password="${config.password}"
		restServiceLocatorAlias="${config.restServiceLocatorAlias}"
		fndWebSecAlias="${config.fndWebSecAlias}"
		responsibility="${config.responsibility}"
		respApplication="${config.respApplication}"
		securityGroup="${config.securityGroup}"
		nlsLanguage="${config.nlsLanguage}"
		orgId="${config.orgId}"/>
	</oracle-ebs122:config>
	<flow name="oracle-ebs122Flow">
		<http:listener doc:name="Listener" config-ref="HTTP_Listener_config"
		path=“/start”/>
		<ee:transform doc:name="Transform Message" >
			<ee:message >
				<ee:set-payload ><![CDATA[%dw 2.0
output application/xml
ns ns0 http://xmlns.oracle.com/apps/per/rest/hr_location_api/create_location/
---
{
	ns0#InputParameters: {
		ns0#P_VALIDATE: 0,
		ns0#P_EFFECTIVE_DATE: now,
		ns0#P_LOCATION_CODE: "HR- MuleSoft BA",
		ns0#P_DESCRIPTION: "Buenos Aires Office"
	}
}]]></ee:set-payload>
			</ee:message>
			<ee:variables >
				<ee:set-variable variableName="payload" ><![CDATA[%dw 2.0
output application/xml
ns ns0 http://xmlns.oracle.com/apps/per/rest/hr_location_api/create_location/
---
{
	    ns0#InputParameters: {
        ns0#P_VALIDATE: 0,
        ns0#P_EFFECTIVE_DATE: now,
        ns0#P_LOCATION_CODE: 'LocCode001’,
        ns0#P_DESCRIPTION: 'Location 001’
    }
}]]></ee:set-variable>
			</ee:variables>
		</ee:transform>
		<oracle-ebs122:invoke-pl-sql-rest-service
		doc:name="Invoke PL/SQL REST Service"
		config-ref="Oracle_ebs122_Config"
		operation="CREATE_LOCATION" plSql="hr_location_api">
			<oracle-ebs122:input ><![CDATA[#[payload]]]></oracle-ebs122:input>
		</oracle-ebs122:invoke-pl-sql-rest-service>
	</flow>
</mule>
```

## See Also

- [Oracle EBS 12.2 Connector Release Notes](https://docs.mulesoft.com/release-notes/connector/oracle-ebs-122-connector-release-notes-mule-4)

- [Oracle EBS 12.2 Connector](https://www.mulesoft.com/exchange/com.mulesoft.connectors/mule-oracle-ebs-122-connector/)

- Oracle’s Developer’s Guide tutorial in the
  [Deploying a REST Service](https://docs.oracle.com/cd/E26401_01/doc.122/e20927/T511473T634173.htm)
  section

- [Oracle E-Business Suite Documentation Web Library](https://docs.oracle.com/cd/E26401_01/index.htm)

- [Salesforce Help](https://help.salesforce.com)