Results for “fe_id”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

XDP_ADAPTER_TYPE_V is a reporting view owned by the APPS schema within the XDP – Provisioning product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It provides a summarized, denormalized representation of the adapters that have been defined for each Fulfillment Element. Rather than exposing adapter definition detail row by row, the view aggregates adapter records so that consumers can quickly determine which adapter usage types exist for a given Fulfillment Element, along with how many adapters fall into each usage category. This makes the view well suited to configuration audits, provisioning diagnostics, and integration dashboards where a high-level census of adapter usage is required.

The view is registered in EBS as a VALID database object and is documented in the ETRM repository. Its central reporting concept is the usage_code, which classifies each adapter into a category of use, and the corresponding USAGE_COUNT, which reports the number of adapters sharing that classification for a given Fulfillment Element.

Underlying Base Objects

The documented dependencies for XDP_ADAPTER_TYPE_V are FND_GLOBAL (package), FND_LOOKUPS (view), and XDP_ADAPTER_REG (synonym). The view text joins XDP_ADAPTER_REG (aliased XAR in the definition) with FND_LOOKUPS (aliased FL) on the condition that XAR.USAGE_CODE equals FL.LOOKUP_CODE, restricted to LOOKUP_TYPE = 'XDP_ADAPTER_USAGE_CODE'.

XDP_ADAPTER_REG supplies the adapter registration data, including the Fulfillment Element identifier (FE_ID) and the usage classification (USAGE_CODE). FND_LOOKUPS supplies the human-readable meaning for each usage code, drawn from the XDP_ADAPTER_USAGE_CODE lookup type, and is surfaced in the view as DISPLAY_NAME / MEANING. Dependence on FND_GLOBAL is consistent with standard EBS view definitions that resolve application context, such as language or user environment, when decoding lookup meanings. The synonym XDP_ADAPTER_REG provides the APPS-level access path to the underlying registration data.

Key Columns

  • FE_ID – Fulfillment Element identifier. Identifies the Fulfillment Element to which the grouped adapters belong and is the primary grouping dimension of the view.
  • USAGE_CODE – The usage classification of the adapter. Sourced from XDP_ADAPTER_REG and validated against the XDP_ADAPTER_USAGE_CODE lookup type.
  • MEANING (DISPLAY_NAME) – The translated, user-facing description of the usage code, retrieved from FND_LOOKUPS. This is the column a user searched for under the term "usage_code," since it expresses the readable form of the code.
  • USAGE_COUNT – The result of COUNT(*) grouped by FE_ID and USAGE_CODE, indicating how many adapters of that usage type exist for the Fulfillment Element.

Common Use Cases and Queries

Typical uses include verifying that all required adapter usage types are configured for a Fulfillment Element, identifying elements with no adapters of a given type, and producing configuration reports for provisioning administrators. Because the view is pre-aggregated, it avoids the need for ad hoc grouping against XDP_ADAPTER_REG in custom reports.

Sample query listing all adapter usage types and counts for a specific Fulfillment Element:

  • SELECT fe_id, usage_code, display_name, usage_count FROM apps.xdp_adapter_type_v WHERE fe_id = :p_fe_id ORDER BY usage_code;

Sample query finding Fulfillment Elements that lack a particular adapter usage type:

  • SELECT fe_id FROM apps.xdp_adapter_type_v WHERE usage_code = :p_usage_code AND usage_count = 0;

A summary of all usage types across the environment can be produced by grouping on USAGE_CODE and DISPLAY_NAME:

  • SELECT usage_code, display_name, SUM(usage_count) FROM apps.xdp_adapter_type_v GROUP BY usage_code, display_name;