Home › Discussions › Questions & Answers › Configuring Oracle EBS Integrated SOA Gateway (ISG) REST services in 12.2

Configuring Oracle EBS Integrated SOA Gateway (ISG) REST services in 12.2

Avatar photoCustomer Questions & Answers 11 replies

We need to configure and enable Oracle E-Business Suite Integrated SOA Gateway (ISG) REST services in our 12.2 instance to allow custom application communication. Can you outline the critical prerequisites, particularly concerning patches, to enable ISG successfully?

11 replies

  • Support Enginatics

    The ISG component is included in the Oracle E-Business installation but requires configuration to be enabled. A critical prerequisite is ensuring you have applied the appropriate ISG Consolidated Patch for your 12.2 version. You should run a specific SQL query against `ad_bugs` to determine which consolidated patch (e.g., 31764501, 35629149, or 36828728 for recent versions) is applied.

  • Avatar photoCustomer

    What is the recommended method for verifying the applied ISG Consolidated Patch and its version (e.g., 24_3_5)? We need a quick, reliable check.

  • Support Enginatics

    You can execute this query as APPS: `select decode(ab.bug_number, ‘31764501’,’31764501: ISG Consolidated Patch for 12.2 (20_3_5)’,…, ‘36828728’,’36828728: ISG Consolidated Patch for 12.2 (24_3_5)’ ) ‘ISG Patch’ from ad_bugs ab where ab.bug_number in (‘31764501′,’33168402′,’34766982′,’35629149′,’36828728′) and ab.language=’US’;` This checks for various known ISG patch numbers and returns their descriptive title.

  • Avatar photoCustomer

    Security is critical. We must ensure that ISG communication uses secure protocols. How do we configure TLS/HTTPS for ISG REST services in EBS 12.2?

  • Support Enginatics

    Configuring TLS/HTTPS for ISG REST services in 12.2 involves detailed steps, typically related to setting up the SSL certificates and enabling HTTPS communication on the required server ports. Proper setup secures data transmission between custom applications and EBS via the REST endpoints.

  • Avatar photoCustomer

    If we encounter errors during configuration or post-implementation, can we use Blitz Report to pull diagnostic logs or configuration details for faster troubleshooting?

  • Support Enginatics

    Yes, DBAs and support teams use Blitz Report to simplify tasks by running internal diagnostic queries directly from the EBS interface, avoiding manual database logins. You can create custom Blitz Reports to extract configuration values, check FND tables, or analyze application logs quickly, aiding in troubleshooting complex ISG setup issues.

  • Avatar photoCustomer

    If we were still on EBS 12.1, would the ISG configuration steps and TLS process be substantially different?

  • Support Enginatics

    Yes, the configuration details differ between 12.1 and 12.2, particularly concerning the web server structure and security implementation. Separate procedures exist for Configuring TLS/HTTPS for Oracle EBS Integrated SOA Gateway (ISG) in 12.1. Similarly, enabling `mod_plsql` is also version-dependent (11i, 12.1.3, 12.2).

  • Avatar photoCustomer

    We need to integrate custom applications using ISG for transactional data transfer. Is data integrity maintained during this integration?

  • Support Enginatics

    Data integrity is managed by the underlying EBS database and ISG services. For auditing and verifying data changes resulting from integration activity, you can use Blitz Report alongside the EBS audit function to track master data changes and ensure compliance.

  • You must be logged in to reply to this post.