FND Integrated SOA Gateway Requests – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Application Object Library · all Application Object Library reports

Overview

Integrated SOA Gateway (ISG) web service requests as logged for the SOA Monitor, one row per request, with execution time, status, HTTP and fault details.

Execution seconds is the time between the gateway receiving the request and sending the response, rounded to whole seconds. Time a request spends queued before it reaches the gateway (client, load balancer, web tier) is not included: compare the client’s send time with Request Received to measure it.

Show Requests in Process counts, for each request, the requests in process when it was received, itself included, to show how many calls the gateway handled in parallel. Use the template Throughput per Minute to see request volume and average execution time per minute.

Show Payload adds the request and response bodies, which ISG stores only for services with auditing enabled.

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Received within x Days, Received From, Received To, Interface, Operation, Status, User Name, Execution Seconds From, Show Requests in Process, Show Payload

Oracle EBS Tables Used

fnd_soa_request, fnd_irep_all_interfaces, fnd_responsibility_vl, fnd_application_vl

Report Categories

Enginatics

INV Kanban Cards, INV Material Account Distribution Detail, PPF_WP3_OM_DETAILS, WSH Shipping/Delivery Transactions, INV Lot Upload, CST Item Standard Cost Upload, ECC Admin - Concurrent Programs

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output FND Integrated SOA Gateway Requests 22-Oct-2026 184245.xlsx
Blitz Report™ XML Import FND_Integrated_SOA_Gateway_Requests.xml
SQL Source FND Integrated SOA Gateway Requests.sql
Full Report on Enginatics www.enginatics.com/reports/fnd-integrated-soa-gateway-requests/

© Enginatics GmbH