View Source

Building on top of Oracle Fusion Middleware and service-oriented architecture (SOA) technology, Oracle E-Business Suite Integrated SOA Gateway (ISG) is a complete set of service infrastructure to provide, consume, and administer Oracle E-Business Suite Web services. With service enablement feature, integration interfaces published in the Oracle Integration Repository can be transformed into SOAP and REST based Web services.

FlexDeploy supports SOAP Services on EBS 12.1.3 and 12.2.x. REST services are supported on EBS 12.2.x only.

Object Type Identification

Any .pkh or .pls package spec sql files which contain Integrated SOA Gateway annotations.
Any .ildt file

File Extensions

.pls
.pkh
.ildt

Object Type Code

ISG

Attributes

Name

Code

Description

Default Value

Supported Values

Source

SOURCE

Object Source

SCM

Product

PRODUCT

EBS Product Name

Defaults to value provided in @rep:product <product> annotation

Any EBS product name

Service Alias

SERVICE_ALIAS

Service Alias

Defaults to value provide in @flexdeploy-rep:alias <alias> annotation. If not specified defaults to the name of the PLS/PKH package

Any alias name

Service Type

SERVICE_TYPE

Service Type

REST

Defaults to value provide in @flexdeploy-rep:type <type> annotation. If not specified defaults to the name of the PLS/PKH package. If not specified, the service type defaults to REST.

REST | SOAP | BOTH

REST services are only supported for EBS 12.2.x.

Related Project Properties

Name	Code	Description	Default Value	Supported Values
Integrated SOA Gateway Version Prefix	FDEBS_ISG_VERSION_PREFIX	The version number prefix to use when geneting ILDT from source files (e.g. 12.0). At deployment time a build sequence number is added to the prefix. The version number must be incremented with each deployment of the service.	12.0	Any value of the format #.#.

Sample Build Commands

N/A - Build commands not supported for this type.

Sample Deploy Commands

N/A - Deploy commands not supported for this type.

Details

The EBS deploy operation will generate the necessary commands based on the type of file and the metadata which is captured on the project objects.

ILDT
- Deploys the ILDT using FNDLOAD
- Deploys the web service using Ant
PKH, PLS
- Copies the SQL files to the <Product Top>/patch/115/sql directory
- Generates the ILDT using Perl
- Deploys the ILDT using FNDLOAD
- Deploys the web service (REST) using Oracle supplied Ant script

Limitations

Support for REST services is currently limited to EBS 12.2.x.
ILDTs can only be generated from PLS or PLH sql files which are annotated appropriately.
Due to lack of available Oracle APIs, grants performed to the deployed services remains a manual step. Existing grants are preserved across deployments, but new grants and revoked grants must be performed manually.
When redeploying an existing service, the version number must be incremented. If its not greater than the previous version, no errors occur, but it does not actually get deployed.
- The version number is generated by appending a build sequence number for the project to the Integrated SOA Gateway Version Prefix project property.
- To ensure the version gets auto-incremented with each deployment, all deployments should be initiated through the FlexDeploy project. Otherwise, you run the risk of the generated version being less than the current version.