Search Results hxc_pref_hierarchies




Overview
Explore in AI Chat

Overview

The HXC.HXC_PREF_HIERARCHIES table is a core configuration object within the Oracle E-Business Suite Time and Labor Engine (HXC) module. It stores the definitional structure of preference hierarchies, which are the ordered trees used by Time and Labor to resolve default values, processing rules, and behavioral settings for timecards, resources, and related transactions. Each row represents a node in a preference hierarchy, allowing Oracle EBS to cascade preference lookups from a top-level parent down through intermediate levels to leaf-level assignments.

Because the table records hierarchical relationships and links rows to preference definitions, it serves as the structural backbone for how Time and Labor preferences are organized and inherited. The ETRM metadata classifies this object, via a heuristic mined from its foreign key structure, as satellite-leaning in Data Vault terms. In practice it behaves as a satellite attached to the preference definition and hierarchy business keys, with a self-referencing recursive parent link that models the tree rather than a simple hub or link.

Key Information Stored

The table contains 51 documented columns. The most significant are:

Common Use Cases and Queries

Typical usage includes tracing inheritance paths, validating that a resource's preference resolves to the expected node, and reporting on hierarchy configuration. A common pattern retrieves a node and its parent:

SELECT p.name, p.parent_pref_hierarchy_id, c.name AS parent_name FROM hxc.hxc_pref_hierarchies p LEFT JOIN hxc.hxc_pref_hierarchies c ON p.parent_pref_hierarchy_id = c.pref_hierarchy_id WHERE p.pref_hierarchy_id = :id;

A recursive CONNECT BY query can render the full tree from a top-level parent using TOP_LEVEL_PARENT_ID or PARENT_PREF_HIERARCHY_ID. Reporting use cases include auditing nodes where EDIT_ALLOWED = 'N', verifying displayed hierarchy entries, and checking editioning via ZD_EDITION_NAME.

Related Objects

  • HXC_PREF_DEFINITIONS — referenced via PREF_DEFINITION_ID; supplies the preference definition behind each node.
  • HXC_PREF_HIERARCHIES (self) — PARENT_PREF_HIERARCHY_ID provides the recursive tree structure.
  • HXC_RESOURCE_RULES — references this table through PREF_HIERARCHY_ID, associating resource rules with hierarchy nodes.

These relationships confirm that HXC_PREF_HIERARCHIES sits between preference definitions and resource rules, acting as the inheritance engine for Time and Labor preference resolution.