Search Results otl_alt_ddf




Overview
Explore in AI Chat

Overview

APPS.HXC_ALIAS_TYPES_V is a reporting and integration view in Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2 that exposes alias type definitions used by the Time and Labor (HXC) module. It is owned by the APPS schema and presents a denormalized representation of the HXC_ALIAS_TYPES base table, resolving the generic REFERENCE_OBJECT column into a human-readable descriptive name. This resolution is achieved through a UNION of two branches that cater to different alias type families: value-set-based alias types and descriptive flexfield context alias types. The view is a key reference object for developers and analysts searching on "value_set_table," since the alias type VALUE_SET_TABLE is explicitly included in its filter predicate and represents one of the supported alias configurations. In Oracle EBS, alias types drive time entry, alternate name generation, and lookup behavior in Time and Labor, so this view is frequently joined to configuration queries and diagnostic reports.

Underlying Base Objects

The documented base objects referenced by this view are:

The join to FND_FLEX_VALUE_SETS is performed via TO_CHAR(FF.FLEX_VALUE_SET_ID) = HAT.REFERENCE_OBJECT, and the join to FND_DESCR_FLEX_CONTEXTS_VL via TO_CHAR(FDFC.DESCRIPTIVE_FLEX_CONTEXT_CODE) = HAT.REFERENCE_OBJECT. This string-based matching requires that REFERENCE_OBJECT store the numeric ID for value sets and the context code for DDF contexts, which is consistent with the alias type semantics.

Key Columns

  • ALIAS_TYPE_ID — unique identifier for the alias type record.
  • ALIAS_TYPE — the code identifying the alias type; documented values include VALUE_SET_NONE, VALUE_SET_TABLE, VALUE_SET_INDEPENDENT, and OTL_ALT_DDF.
  • REFERENCE_OBJECT — the raw reference used by the alias type; for value set types this holds the value set ID, and for OTL_ALT_DDF it holds the descriptive flexfield context code.
  • D_REFERENCE_OBJECT_NAME — the decoded, user-friendly name: FLEX_VALUE_SET_NAME for value set alias types or DESCRIPTIVE_FLEX_CONTEXT_NAME for OTL_ALT_DDF.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard EBS audit columns.
  • OBJECT_VERSION_NUMBER — optimistic locking version for the underlying row.
  • BIS_DECODE_LOOKUP('HXC_ALT_NAME_TYPE', ALIAS_TYPE) — the decoded lookup meaning of the alias type, returned as an unaliased expression.

Common Use Cases and Queries

The view is used to validate Time and Labor alias configuration, to report on which value sets or descriptive flexfield contexts are bound to alias types, and to support integrations that require readable alias type descriptions. A typical query listing value-set aliases is:

  • SELECT alias_type_id, alias_type, reference_object, d_reference_object_name FROM apps.hxc_alias_types_v WHERE alias_type = 'VALUE_SET_TABLE';
  • SELECT alias_type, d_reference_object_name FROM apps.hxc_alias_types_v WHERE alias_type IN ('VALUE_SET_NONE','VALUE_SET_INDEPENDENT');
  • SELECT alias_type_id, d_reference_object_name FROM apps.hxc_alias_types_v WHERE alias_type = 'OTL_ALT_DDF';

Because the lookup decode is included as a column expression, SELECT * returns both the raw ALIAS_TYPE and its decoded meaning, which is convenient for reports. When joining to value set definitions or flexfield context tables, always use ALIAS_TYPE_ID as the stable key rather than ALIAS_TYPE, since the same alias type code may appear on multiple rows with different reference objects.