Search Results preference_name




Overview
Explore in AI Chat

Overview

HXC_PREF_HIERARCHIES_V is an APPS-owned database view in the Oracle E-Business Suite Time and Labor Engine (HXC) product family. It exposes preference hierarchy definitions used by Time and Labor and related modules to organize preference definitions into parent-child structures. Preference hierarchies control how preferences are grouped, inherited, and presented to end users, and they are central to the configuration of timecard, overtime, and rule-based preference processing. The view is documented as VALID and is available in both EBS 12.1.1 and 12.2.2.

Because the object is a view rather than a table, it is intended primarily for read-only reporting and integration. It denormalizes hierarchy rows from HXC_PREF_HIERARCHIES and enriches each row with the resolved preference name drawn from the Descriptive Flexfield context definitions, allowing report authors and interface developers to work with a single queryable source. The PREFERENCE_NAME column, which the user searched for, is a derived column in this view, not a preserved column of the base table.

Underlying Base Objects

Per the documented ETRM metadata, the view is defined over three referenced objects:

  • HXC_PREF_HIERARCHIES (synonym) — the driving table, aliased HPH in the view text. It supplies all hierarchy attributes, including identifiers, parent linkage, business group, legislation, and the 30 descriptive flexfield attribute columns.
  • HXC_PREF_DEFINITIONS (synonym) — joined to resolve the descriptive flexfield context code for each preference definition.
  • FND_DESCR_FLEX_CONTEXTS_VL (view) — the DFF context value set view, filtered to APPLICATION_ID = 809 and DESCRIPTIVE_FLEXFIELD_NAME = 'OTC PREFERENCES'. The context code is matched against HXC_PREF_DEFINITIONS.CODE to produce DESCRIPTIVE_FLEX_CONTEXT_NAME.

Two scalar subqueries are therefore embedded in the view: a self-referencing lookup for PARENT_PREF_HIERARCHY, and the DFF-based lookup for PREFERENCE_NAME. Both are correlated on the outer HPH row.

Key Columns

The view exposes the full column set of HXC_PREF_HIERARCHIES plus two derived columns.

Common Use Cases and Queries

The view is typically used to report or validate preference hierarchy configuration, to list hierarchies by legislation or business group, and to resolve the display name of a preference from its DFF context during integration. A representative query filters on the searched column:

SELECT PREF_HIERARCHY_ID, PREF_HIERARCHY, PREFERENCE_NAME, LEGISLATION_CODE
FROM APPS.HXC_PREF_HIERARCHIES_V
WHERE PREFERENCE_NAME IS NOT NULL
AND BUSINESS_GROUP_ID = :p_bg_id;

A second pattern walks the parent linkage to build the hierarchy tree by self-joining on PREF_HIERARCHY_ID and PARENT_PREF_HIERARCHY_ID, using PARENT_PREF_HIERARCHY for display. Because PREFERENCE_NAME depends on a DFF context match, feeds that require a guaranteed value should filter or coalesce accordingly, since the view returns NULL when no matching context exists.