Results for “building_block_category”

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

Overview

HXC_MAPPING_COMPONENTS_V is an APPS-owned view in the Oracle E-Business Suite Time and Labor Engine (HXC) product. It exposes mapping component configuration used by the Time and Labor building block framework, joining descriptive flexfield column usage metadata to HXC building block information types. The view presents the mapping between HXC mapping components and the descriptive flexfield segments defined under the "OTC INFORMATION TYPES" descriptive flexfield in application 809 (HXC). It is validated and available in both 12.1.1 and 12.2.2.

The view is most relevant to reporting and integration scenarios where a developer or administrator needs to understand which OTC information type building block attributes map to which underlying descriptive flexfield columns. Because the view resolves the flexfield segment to an end-user column name and an enabled flag, it provides a human-readable representation of an otherwise cryptic mapping between logical HXC components and physical DFF columns.

Underlying Base Objects

The ETRM metadata documents four referenced base objects, all exposed as synonyms in APPS:

• HXC_MAPPING_COMPONENTS — the primary driving table containing mapping component definitions, including name, field name, segment, and building block info type.
• HXC_BLD_BLK_INFO_TYPES — provides the building block info type identifier and BLD_BLK_INFO_TYPE code.
• HXC_BLD_BLK_INFO_TYPE_USAGES — supplies the BUILDING_BLOCK_CATEGORY for each info type.
• FND_DESCR_FLEX_COLUMN_USAGES — the descriptive flexfield column usage table; here it is filtered to APPLICATION_ID = 809 and DESCRIPTIVE_FLEXFIELD_NAME = 'OTC INFORMATION TYPES'.

The join condition links MPC.BLD_BLK_INFO_TYPE_ID to BBIT.BLD_BLK_INFO_TYPE_ID, and BBITU to BBIT on the same identifier. FND_DESCR_FLEX_COLUMN_USAGES joins on DESCRIPTIVE_FLEX_CONTEXT_CODE = BBIT.BLD_BLK_INFO_TYPE and on APPLICATION_COLUMN_NAME = MPC.SEGMENT. A special branch handles the pseudo-segment 'ATTRIBUTE_CATEGORY', which has no direct column usage and is resolved via a correlated subquery or the absence of any column usage row.

Key Columns

• ROW_ID — the ROWID of the underlying HXC_MAPPING_COMPONENTS row, useful as a unique row identifier.
• MAPPING_COMPONENT_ID — primary key of the mapping component.
• NAME, FIELD_NAME — business name and field identifier of the component.
• BLD_BLK_INFO_TYPE_ID, BLD_BLK_INFO_TYPE — identifier and code of the associated building block information type.
• BUILDING_BLOCK_CATEGORY — category supplied by HXC_BLD_BLK_INFO_TYPE_USAGES.
• SEGMENT — the flexfield segment or attribute name; may be 'ATTRIBUTE_CATEGORY'.
• END_USER_COLUMN_NAME — the DFF end-user column name, decoded to 'ATTRIBUTE CATEGORY' when SEGMENT is 'ATTRIBUTE_CATEGORY'.
• ENABLED_FLAG — the DFF enabled flag, forced to 'Y' for the attribute category pseudo-segment.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Who columns.

Common Use Cases and Queries

A frequent requirement is to list all mapping components for a given OTC information type together with the resolved end-user column name and enabled status. For example:

• SELECT NAME, FIELD_NAME, BLD_BLK_INFO_TYPE, SEGMENT, END_USER_COLUMN_NAME, ENABLED_FLAG FROM HXC_MAPPING_COMPONENTS_V WHERE BLD_BLK_INFO_TYPE = :info_type;
• SELECT BUILDING_BLOCK_CATEGORY, COUNT(*) FROM HXC_MAPPING_COMPONENTS_V GROUP BY BUILDING_BLOCK_CATEGORY;
• SELECT * FROM HXC_MAPPING_COMPONENTS_V WHERE SEGMENT = 'ATTRIBUTE_CATEGORY';

These queries are typically used during Time and Labor configuration validation, when verifying that the flexfield segments referenced by mapping components remain enabled, or when diagnosing discrepancies between the DFF definition and HXC building block setup. The search term fnd_descr_flex_column_usages reflects the user's interest in how this view leverages the DFF column usage table to resolve segments to end-user columns.