Search Results hxc_alias_definitions_uk1

Overview

HXC_ALIAS_DEFINITIONS is a table within the HXC schema, the Time and Labor Engine product of Oracle E-Business Suite. It stores alternate name definitions — the metadata that controls how timecard fields, contexts, and legislative variations are labeled and mapped within the Time and Labor Engine. Each row defines a named alias that downstream tables and concurrent processes use to resolve timecard field meanings consistently across business groups and legislations.

Under a heuristic Data Vault classification derived from its foreign key structure, this table presents hub-leaning characteristics. The surrogate primary key ALIAS_DEFINITION_ID anchors each definition as a distinct business concept, while the foreign key to HXC_ALIAS_TYPES behaves like a link to a parent classification. This is a modeling suggestion, not a prescriptive design constraint; treat the hub-leaning signal as guidance when building integration or staging layers rather than as a normative source model.

The table is validated and available in both Oracle EBS 12.1.1 and 12.2.2. The documented physical schema for 12.2.2 spans 15 columns and carries two unique indexes and a primary key, reflecting the standard EBS audit-column and editioning pattern.

Key Information Stored

• ALIAS_DEFINITION_ID — the surrogate primary key, populated from the HXC_ALIAS_DEFINITIONS_PK sequence and referenced by child tables.
• ALIAS_DEFINITION_NAME — the business-facing name of the alias; combined with BUSINESS_GROUP_ID it forms the business-key candidate HXC_ALIAS_DEFINITIONS_UK1.
• BUSINESS_GROUP_ID — scopes the definition to a single business group, enabling multi-tenant separation of alias configurations.
• ALIAS_TYPE_ID — the foreign key to HXC_ALIAS_TYPES, classifying the definition into a category of aliases.
• ALIAS_CONTEXT_CODE — the context or usage boundary within which the alias applies.
• TIMECARD_FIELD — the specific timecard element the alias maps to or overrides.
• LEGISLATION_CODE — restricts the definition to a jurisdiction where statutory rules differ.
• DESCRIPTION — free-text explanation of the alias purpose.
• OBJECT_VERSION_NUMBER — the optimistic locking token used by the OAF/BC4J layers.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard EBS audit columns for change tracking and support diagnostics.
• ZD_EDITION_NAME — the editioning column present in 12.2.x online patching, part of both unique indexes.

The primary key (ALIAS_DEFINITION_ID, ZD_EDITION_NAME) and the unique business key (ALIAS_DEFINITION_NAME, BUSINESS_GROUP_ID, ZD_EDITION_NAME) together enforce uniqueness after accounting for the 12.2 edition dimension.

Common Use Cases and Queries

Typical uses include resolving how a timecard field is displayed or interpreted for a given business group and legislation, auditing which aliases are active across groups, and feeding downstream reporting that must translate alias IDs into readable names.

SELECT ad.alias_definition_id,
       ad.alias_definition_name,
       ad.timecard_field,
       at.alias_type_name
FROM   hxc_alias_definitions ad,
       hxc_alias_types at
WHERE  ad.alias_type_id = at.alias_type_id
AND    ad.business_group_id = :p_bg_id;

To find definitions with resolved alias values:

SELECT ad.alias_definition_name, av.alias_value
FROM   hxc_alias_definitions ad,
       hxc_alias_values av
WHERE  av.alias_definition_id = ad.alias_definition_id;

Additional patterns include filtering by LEGISLATION_CODE for statutory reporting, joining to business group lookups for tenant-level dashboards, and detecting duplicates across the business key where definitions have been recreated after data migration.

Related Objects

• HXC_ALIAS_TYPES — parent classification; join on ALIAS_TYPE_ID.
• HXC_ALIAS_VALUES — child table holding concrete alias values; join on ALIAS_DEFINITION_ID.
• HXC_RPT_TC_RESOURCE_TEMP — reporting staging table referencing ALIAS_DEFINITION_ID for timecard resource extracts.
• HXC_ALIAS_DEFINITIONS_PK and HXC_ALIAS_DEFINITIONS_UK1 — the primary and unique indexes enforcing identity and business-key uniqueness.
• Business group and legislation lookup objects referenced by BUSINESS_GROUP_ID and LEGISLATION_CODE.

Together these objects form the alias configuration chain that the Time and Labor Engine consults when interpreting timecard field definitions.