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

Customer February 22, 2024 at 3:13 pm

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?

Viewing 10 reply threads

Author
Replies
- Support February 24, 2024 at 1:30 am
  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.
- Customer February 25, 2024 at 8:12 am
  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 February 25, 2024 at 11:51 am
  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.
- Customer February 26, 2024 at 5:01 am
  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 February 26, 2024 at 9:50 pm
  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.
- Customer February 29, 2024 at 12:36 am
  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 February 29, 2024 at 8:34 pm
  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.
- Customer March 1, 2024 at 8:11 pm
  If we were still on EBS 12.1, would the ISG configuration steps and TLS process be substantially different?
- Support March 2, 2024 at 6:27 am
  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).
- Customer March 3, 2024 at 3:25 pm
  We need to integrate custom applications using ISG for transactional data transfer. Is data integrity maintained during this integration?
- Support March 5, 2024 at 4:45 am
  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.
Author
Replies