Results for “xdp_fe_types_vl”

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

Overview

XDP_FE_TYPES_VL is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the XDP – Provisioning product family. It presents the definition of Fulfillment Element Types, the configuration entities that describe the kinds of elements a provisioning or fulfillment engine may process. Because the view is a "_VL" (view with translation) object, it exposes both the base definition attributes of a fulfillment element type and the language-specific display name and description translated for the session language of the querying user.

The view is a query-only construct and carries no data of its own; it is a convenience layer that joins the base definition table to its translation table and filters the translation rows to the language returned by USERENV('LANG'). Its status is documented as VALID in the ETRM metadata for both Oracle EBS 12.1.1 and 12.2.2, and the object is treated as an Oracle proprietary, confidential component. In practice it supports reporting, validation, and integration logic that must present fulfillment element types in the user's own language without requiring the caller to assemble the join manually.

Underlying Base Objects

XDP_FE_TYPES_VL is defined over two documented base objects, both exposed through APPS-owned synonyms:

• XDP_FE_TYPES – the base definition table holding the fulfillment element type record, its identifier, and the standard Oracle EBS audit columns.
• XDP_FE_TYPES_TL – the translation table holding the language-specific DISPLAY_NAME and DESCRIPTION for each fulfillment element type.

The view joins the two on FETYPE_ID and restricts the translation side to the language of the current session. The documented view text is:

SELECT B.ROWID ROW_ID, B.FETYPE_ID, B.FULFILLMENT_ELEMENT_TYPE, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, T.DISPLAY_NAME, T.DESCRIPTION FROM XDP_FE_TYPES_TL T, XDP_FE_TYPES B WHERE B.FETYPE_ID = T.FETYPE_ID AND T.LANGUAGE = USERENV('LANG')

Consequently, one row is returned per fulfillment element type for which a translation exists in the session language. Because the join is an inner join on the translation table, base definitions lacking a translation row in the current language are not surfaced by the view.

Key Columns

• ROW_ID – the ROWID of the base XDP_FE_TYPES row, exposed for identification and row-level access.
• FETYPE_ID – the primary identifier of the fulfillment element type and the join key between the base and translation tables.
• FULFILLMENT_ELEMENT_TYPE – the internal, language-independent code or name for the element type.
• CREATION_DATE, CREATED_BY, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – standard Oracle EBS audit columns recording creation and last modification context.
• DISPLAY_NAME – the translated, user-facing name of the fulfillment element type.
• DESCRIPTION – the translated, user-facing description of the fulfillment element type.

Common Use Cases and Queries

Typical scenarios include building multilingual lookup lists, validating that a requested fulfillment element type exists, and producing reports that describe provisioning configuration in the user's language.

List all fulfillment element types in the session language:

SELECT FETYPE_ID, FULFILLMENT_ELEMENT_TYPE, DISPLAY_NAME FROM APPS.XDP_FE_TYPES_VL ORDER BY DISPLAY_NAME;

Retrieve the description of a specific type by code:

SELECT FETYPE_ID, DISPLAY_NAME, DESCRIPTION FROM APPS.XDP_FE_TYPES_VL WHERE FULFILLMENT_ELEMENT_TYPE = :p_type;

Join to other XDP objects on FETYPE_ID to associate element types with their provisioning configuration, or compare the view against XDP_FE_TYPES to detect definitions that lack a translation in the current session language. Because the view filters on USERENV('LANG'), results depend on the environment of the calling session; applications requiring all languages should query XDP_FE_TYPES_TL directly.