Search Results fnd_svc_comp_requests




Overview
Explore in AI Chat

Overview

The FND_SVC_COMP_REQUESTS table is a core Application Object Library (FND) table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, owned by the APPLSYS schema. It functions as the central repository for managing scheduled service component events. These events are typically background operations or service requests initiated by the system's internal service management framework, such as the Service Component Framework (SCF). The table's role is to track the lifecycle of these scheduled requests, providing a persistent record for monitoring, auditing, and execution control within the EBS architecture.

Key Information Stored

The table's primary purpose is to log metadata for scheduled service events. Its primary key is the COMPONENT_REQUEST_ID, a unique identifier for each scheduled request. While the full column list is proprietary, based on its description and standard patterns, the table likely stores critical scheduling and status information. This typically includes the service component name, the type of event or action requested, the scheduled start time, the current status (e.g., PENDING, RUNNING, COMPLETED, ERRORED), parameters for the request, and timestamps for creation, last update, and completion. It serves as the system of record for the queue of pending and historical service component executions.

Common Use Cases and Queries

This table is primarily accessed for administrative monitoring and troubleshooting of background service processes. Common use cases include reviewing the queue of pending service requests, diagnosing failed or stalled components, and analyzing the execution history of system services. Sample SQL patterns often involve filtering by status and time to isolate current issues or audit past activity.

  • Monitoring pending requests: SELECT * FROM apps.fnd_svc_component_requests WHERE status = 'PENDING' ORDER BY scheduled_start_time;
  • Investigating recent errors: SELECT component_request_id, component_name, status, error_message FROM apps.fnd_svc_component_requests WHERE status = 'ERROR' AND last_update_date > SYSDATE - 1;
  • Checking long-running processes: SELECT * FROM apps.fnd_svc_component_requests WHERE status = 'RUNNING' AND scheduled_start_time < SYSDATE - INTERVAL '1' HOUR;

Related Objects

As a foundational FND table, FND_SVC_COMP_REQUESTS is intrinsically linked to the Oracle EBS service management infrastructure. It is directly referenced by the Service Component Framework's internal APIs and managers that process the queued requests. The primary key constraint, FND_SVC_COMP_REQUESTS_P1, enforces data integrity. While specific dependent views or public APIs are not detailed in the provided metadata, it is common for such a table to have associated V$ or FND_* views (e.g., FND_SVC_COMP_REQUESTS_VL) for reporting purposes. It may also be referenced by workflow or concurrent processing subsystems that integrate with service components.