Search Results inbound_required_flag




Overview
Explore in AI Chat

Overview

The XDP_FE_SUMMARY_V view resides in the APPS schema and belongs to the XDP – Provisioning product module. It presents consolidated summary information for all Fulfillment Elements defined within an Oracle E-Business Suite environment running 12.1.1 or 12.2.2. A Fulfillment Element represents a logical unit of provisioning capability to which one or more adapters are bound. This view answers the recurring operational question of how each Fulfillment Element is configured: its identifier and name, the application mode shared by its adapters, whether inbound processing is required, and how many adapters are registered against it.

Because it consolidates data that otherwise spans three related objects, the view is a natural entry point for reporting, diagnostics, and integration health checks. Users searching for "fe_name" typically reach this object because FE_NAME is the most human-readable column it exposes, making it convenient for lookup screens, seeded diagnostics, and custom reports that must resolve a Fulfillment Element name to its internal identifier and adapter footprint.

Underlying Base Objects

The view is documented as being defined over three referenced objects in the APPS schema:

  • XDP_FES_VL (VIEW) — the Fulfillment Element definition source, supplying the element identifier, name, and display name. The _VL suffix indicates it is a translation-enabled view, so the fulfillment element name and display name may be returned in the session's language.
  • XDP_ADAPTER_REG (SYNONYM) — the adapter registration table, linking each Fulfillment Element to its registered adapter types.
  • XDP_ADAPTER_TYPES_B (SYNONYM) — the adapter type definitions, supplying the application mode and inbound-required flag associated with each adapter type.

These are joined on XAR.ADAPTER_TYPE = XAT.ADAPTER_TYPE and XFE.FE_ID = XAR.FE_ID, with aggregation applied so that one row is produced per Fulfillment Element and adapter attribute combination. The COUNT of XAR.FE_ID yields the number of adapters associated with each group.

Key Columns

  • FE_ID — the unique internal identifier of the Fulfillment Element; the primary key for correlation with other XDP tables.
  • FE_NAME — the Fulfillment Element name, sourced from XDP_FES_VL.FULFILLMENT_ELEMENT_NAME; the primary search and display attribute.
  • APPL_MODE — the application mode configured on the adapter type, indicating how the provisioning adapter operates.
  • INBOUND_REQUIRED_FLAG — indicates whether inbound processing is required for the adapter type.
  • DISPLAY_NAME — the user-facing translated display name of the Fulfillment Element.
  • NUM_OF_ADAPTERS — the count of adapters registered for the Fulfillment Element, useful for identifying unconfigured or over-subscribed elements.

Common Use Cases and Queries

The view is used to validate provisioning configuration, audit adapter coverage, and resolve Fulfillment Element names in custom reports. A typical lookup by name:

SELECT fe_id, fe_name, display_name, appl_mode, num_of_adapters
FROM apps.xdp_fe_summary_v
WHERE fe_name = :p_fe_name;

A coverage report identifying elements with no adapters or multiple adapters:

SELECT fe_name, display_name, num_of_adapters
FROM apps.xdp_fe_summary_v
WHERE num_of_adapters = 1
ORDER BY fe_name;

Because grouping is applied across adapter types, an element with adapters of differing application modes returns multiple rows for the same FE_ID. Queries intended to return one row per element should therefore aggregate the view's output or filter on APPL_MODE. Seeded diagnostics and user-facing lookups generally filter by FE_NAME or DISPLAY_NAME, leveraging the translation-aware XDP_FES_VL source.

  • View: XDP_FE_SUMMARY_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_FE_SUMMARY_V,  object_name:XDP_FE_SUMMARY_V,  status:VALID,  product: XDP - Provisioning ,  description: View representing summary information of all Fulfillment Elements. Indicates the Fulfillment Element name, the application mode for all adapters defined for the Fulfillment Element, the number of adapters defined for the Fulfillment Eleme ,  implementation_dba_data: APPS.XDP_FE_SUMMARY_V , 

  • View: XDP_FE_SUMMARY_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_FE_SUMMARY_V,  object_name:XDP_FE_SUMMARY_V,  status:VALID,  product: XDP - Provisioning ,  description: View representing summary information of all Fulfillment Elements. Indicates the Fulfillment Element name, the application mode for all adapters defined for the Fulfillment Element, the number of adapters defined for the Fulfillment Eleme ,  implementation_dba_data: APPS.XDP_FE_SUMMARY_V , 

  • View: XDP_ADAPTER_TYPES_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_ADAPTER_TYPES_VL,  object_name:XDP_ADAPTER_TYPES_VL,  status:VALID,  product: XDP - Provisioning ,  description: Shows all seeded and user defined Adapter Types ,  implementation_dba_data: APPS.XDP_ADAPTER_TYPES_VL , 

  • View: XDP_ADAPTER_TYPES_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:XDP.XDP_ADAPTER_TYPES_VL,  object_name:XDP_ADAPTER_TYPES_VL,  status:VALID,  product: XDP - Provisioning ,  description: Shows all seeded and user defined Adapter Types ,  implementation_dba_data: APPS.XDP_ADAPTER_TYPES_VL ,