Results for “xdp_fe_attribute_def_vl”

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

Overview

XDP_FE_ATTRIBUTE_DEF_VL is a validation-level (VL) view in the APPS schema belonging to the XDP – Provisioning product module. In Oracle EBS 12.1.1 and 12.2.2, the view exposes the definition metadata for Fulfillment Element Attribute Definitions — the configuration records that describe which attributes a Fulfillment Element can surface, how those attributes are presented, and how they behave when data is captured or generated during a provisioning transaction. Fulfillment Elements are the reusable building blocks used by Oracle Provisioning to assemble service requests, so their attribute definitions determine the behaviour of the generated provisioning flows.

The view is a translated view: it joins the base definition table with its translation table so that the display name and description are returned in the session's active language. This makes it suitable for reporting, integration, and UI-driven queries where users must see attribute labels in their own language. Because it is a VL view rather than a _TL or base table, it is the recommended entry point for any read operation requiring both attribute configuration and user-facing text.

The specific column CONCEAL_DATA, the term the user searched for, indicates whether the value held by the attribute should be masked or concealed when displayed, for example for sensitive fields such as passwords or keys.

Underlying Base Objects

The view is defined over two documented base objects, both referenced as synonyms in the APPS schema:

• XDP_FE_ATTRIBUTE_DEF — the base table holding the untranslated attribute definition records, including the concealment flag, default value, and sequence.
• XDP_FE_ATTRIBUTE_DEF_TL — the translation table holding DISPLAY_NAME and DESCRIPTION for each FE_ATTRIBUTE_ID in each supported language.

The view text joins the two tables on FE_ATTRIBUTE_ID and restricts the translation row to the language returned by USERENV('LANG'), ensuring a single, session-appropriate row per attribute. The join is a simple equality with no outer join, so an attribute definition appears only where a translation exists for the current language.

Key Columns

• ROW_ID — the ROWID of the base table row, available for row-level addressing.
• FE_ATTRIBUTE_ID — primary identifier of the attribute definition; the join key between base and translation tables.
• FE_SW_GEN_LOOKUP_ID — foreign reference to the lookup or generated value mechanism associated with the attribute.
• FE_ATTRIBUTE_NAME — the internal (untranslated) name of the attribute.
• CONCEAL_DATA — flag indicating whether the attribute value must be concealed when presented.
• DEFAULT_VALUE — value pre-populated when the attribute is instantiated.
• DISPLAY_SEQ — ordering sequence controlling attribute presentation.
• CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns.
• DISPLAY_NAME, DESCRIPTION — translated, user-facing label and description sourced from the _TL table.

Common Use Cases and Queries

Typical uses include auditing which attributes conceal data, reconciling attribute ordering against service definitions, and driving integration extracts that must map internal attribute names to translated labels.

SELECT fe_attribute_id,
       fe_attribute_name,
       display_name,
       conceal_data,
       display_seq
FROM   apps.xdp_fe_attribute_def_vl
WHERE  conceal_data = 'Y'
ORDER  BY display_seq;

SELECT fe_attribute_id, display_name
FROM   apps.xdp_fe_attribute_def_vl
ORDER  BY display_seq, display_name;

The first query isolates concealed attributes for security review; the second produces a language-aware listing suitable for reporting. Both rely solely on documented columns and the translated join behaviour described above.