EBS Object Types - Integrated SOA Gateway

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 Support For ISG

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



NameCodeDescriptionDefault ValueSupported Values
SourceSOURCEObject SourceSCMSCM
ProductPRODUCTEBS Product NameDefaults to value provided in @rep:product <product> annotationAny EBS product name
Service AliasSERVICE_ALIASService AliasDefaults to value provide in @flexdeploy-rep:alias <alias> annotation.Any alias name
Service TypeSERVICE_TYPEService Type

Defaults to value provide in @flexdeploy-rep:type <type> annotation. If not specified, the service type defaults to REST.


REST services are only supported for EBS 12.2.x.

Related Project Properties

NameCodeDescriptionDefault ValueSupported Values
Integrated SOA Gateway Version PrefixFDEBS_ISG_VERSION_PREFIXThe version number prefix to use when generating 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.0Any 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.


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


  • 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. 
The following macros are not currently supported in the footer:
  • style