Search Results inbound_agent_name

Overview

FND_SVC_COMPONENTS_V is a reporting and inquiry view in the APPS schema belonging to the FND — Application Object Library product. It presents the configuration and runtime state of Oracle EBS Service Components, which are the managed, container-hosted services registered with the Service Component Container framework. Each row represents a single service component, combining its identity, type, status, container binding, agent routing, and queue assignment into a single denormalized result set.

The view exists to provide a human-readable, display-ready projection of the underlying FND_SVC_COMPONENTS synonym. Rather than requiring callers to resolve lookup codes and join to agent, queue, and component-type metadata manually, the view performs those joins internally and exposes paired code/display columns. This design makes it suitable for concurrent program output, OAF-based administrative pages, diagnostic queries, and integration extracts that need component state without embedding lookup-resolution logic. The user search term "startup_mode" maps directly to the STARTUP_MODE column and its companion STARTUP_MODE_DISPLAY_NAME, which resolves the code against the WF_SVC_COMP_STARTUP_MODE lookup type.

Underlying Base Objects

The view is defined over the following documented base objects:

• FND_SVC_COMPONENTS (SYNONYM) — the driving table, aliased C, holding the authoritative component rows.
• FND_SVC_COMP_TYPES_VL (VIEW) — aliased CTV, joined on COMPONENT_TYPE to supply the component class and type display name.
• FND_CONCURRENT_QUEUES_VL (VIEW) — aliased CQV, joined on CONCURRENT_QUEUE_ID and APPLICATION_ID with outer-join (+) syntax, supplying concurrent queue names.
• WF_LOOKUPS (VIEW) — used via scalar subqueries to resolve COMPONENT_STATUS, CONTAINER_TYPE, and STARTUP_MODE into their MEANING values.
• WF_AGENTS (SYNONYM) — used via scalar subqueries to resolve inbound and outbound agent display names.
• WF_CORE (PACKAGE) — invoked as WF_CORE.TRANSLATE('WF_SYSTEM_GUID') to constrain agent lookups to the local system GUID.

Because the joins to queue and type metadata are outer where noted, components that are not yet bound to a concurrent queue still appear, with queue columns null.

Key Columns

• COMPONENT_ID / COMPONENT_NAME — primary identifier and logical name of the service component.
• COMPONENT_TYPE / COMPONENT_TYPE_DISPLAY_NAME — the service type code and its translated label.
• COMPONENT_STATUS / COMPONENT_STATUS_DISPLAY_NAME / COMPONENT_STATUS_INFO — current state code, its WF_SVC_COMP_STATUS meaning, and any supplementary status detail.
• STARTUP_MODE / STARTUP_MODE_DISPLAY_NAME — the component's startup behavior code and its WF_SVC_COMP_STARTUP_MODE meaning; this is the column pair relevant to the "startup_mode" search.
• CONTAINER_TYPE / CONTAINER_TYPE_DISPLAY_NAME — container classification, resolved through WF_SVC_CONTAINER_TYPE.
• CONCURRENT_QUEUE_ID / CONCURRENT_QUEUE_NAME / CONCURRENT_QUEUE_DISPLAY_NAME — the associated concurrent queue and its user-facing label.
• INBOUND_AGENT_NAME / INBOUND_AGENT_DISPLAY_NAME and OUTBOUND_AGENT_NAME / OUTBOUND_AGENT_DISPLAY_NAME — agent routing endpoints, resolved against WF_AGENTS.
• APPLICATION_ID, CORRELATION_ID, MAX_IDLE_TIME, STANDALONE_CONTAINER_NAME, CUSTOMIZATION_LEVEL, CREATED_BY, OBJECT_VERSION_NUMBER — ownership, correlation, timeout, and concurrency-control attributes.

Common Use Cases and Queries

Typical uses include auditing component startup configuration, monitoring component health, and reporting queue-to-component mappings.

• Review startup modes across components:

  SELECT component_name, component_type_display_name,
         startup_mode, startup_mode_display_name
    FROM fnd_svc_components_v
   WHERE startup_mode = 'AUTOMATIC';

• List components by status with queue and agent detail:

  SELECT component_name, component_status_display_name,
         concurrent_queue_name, inbound_agent_display_name
    FROM fnd_svc_components_v
   WHERE component_status <> 'RUNNING';

• Identify components with no queue binding (outer-join nulls):

  SELECT component_id, component_name
    FROM fnd_svc_components_v
   WHERE concurrent_queue_id IS NULL;