Oracle EBS 12.2 Connector.

Additional Info

Requires Mule Enterprise License

Yes  

Requires Entitlement

Yes  

Mule Version

3.7.0 or higher

Configs

Configuration

<oracle-ebs122:config>

Configuration

Oracle E-Business Suite Integrated SOA Gateway supports HTTP Basic Authentication security to authenticate the users who invoke REST services over secure and non-secure transport protocols (HTTP / HTTPS).

When an HTTP client application tries to access an Oracle E-Business Suite REST service, user security credentials (username/password) should be provided as input data in HTTP header as part of the REST request message. The username and password will be routed to LoginModule for authentication and authorization.

Attributes

Name Java Type Description Default Value Required

name

String

The name of this configuration. With this name can be later referenced.

x 

host

String

Host name of the Oracle EBS instance.

x 

port

String

Port where the Oracle HTTP Server listens.

x 

sslEnabled

boolean

Enables SSL to securely communicate with Oracle EBS Web Services.

false

 

readTimeout

int

Read timeout interval, in milliseconds. A value of zero (0) is equivalent to an interval of infinity. The default value is infinity (0).

0

 

connectTimeout

int

Connect timeout interval, in milliseconds. A value of zero (0) is equivalent to an interval of infinity. The default value is infinity (0).

0

 

username

String

Username credential to access the Oracle EBS REST service.

x 

password

String

Password credential to access the Oracle EBS REST service.

x 

restServiceLocatorAlias

String

Alias assigned to the web service with Internal Name 'oracle.apps.fnd.rep.ws.service.EbsRestLocator' when deployed.

x 

fndWebSecAlias

String

Alias assigned to the PL/SQL web service with Internal Name 'FND_WEB_SEC' when deployed.

x 

responsibility

String

It is the Oracle E-Business Suite application responsibility information. It accepts responsibility_key (such as SYSTEM_ADMINISTRATOR) as its value.

 

respApplication

String

It is the responsibility application short name information. It accepts Application Short Name (such as FND) as its value.

 

securityGroup

String

It accepts Security Group Key (such as STANDARD) as its value.

 

nlsLanguage

String

Sets the language preferences (such as AMERICAN).

 

orgId

String

ID of the Operating Unit assigned to the specified responsibility. It is the only organization within which the user will be working.

 

Processors

Invoke PL/SQL REST Service

<oracle-ebs122:invoke-pl-sql-rest-service>

  DataSense enabled

Invokes a REST operation from a PL/SQL service based on a deployed WADL. DataSense discovers the structure of the entities in the system in Design time and uses it to perform the operation for the type selected.

XML Sample

<oracle-ebs122:invoke-pl-sql-rest-service config-ref="OracleEBS122__Configuration" wadlOperation="ar_adjust_pub||APPROVE_ADJUSTMENT" />

Attributes

Name Java Type Description Default Value Required

config-ref

String

Specify which config to use

x 

wadlOperation

String

The name of a WADL as determined by DataSense. Once all WADLs are gathered from the Oracle EBS instance, the WADL Operation is composed as {WADL}||{Operation}. E.g wadlOperation="hr_location_api||CREATE_LOCATION".

x 

payload

XMLStreamReader

The input parameters required by the specified operation, as described by its metadata.

#[payload]

 

Returns

Return Java Type Description

XMLStreamReader

The response of the REST operation in an XML format.