Search Results hz_select_data_sources_u1




Overview
Explore in AI Chat

Overview

The AR.HZ_SELECT_DATA_SOURCES table is a seed data configuration table within the Oracle E-Business Suite Trading Community Architecture (TCA). It stores information about the data sources selected during Third Party Data Integration setup, specifically governing how data sources populate attributes and entities defined in the HZ_ENTITY_ATTRIBUTES table. Its principal function is to record the ranking of data sources for each attribute associated with the HZ_ORGANIZATION_PROFILES and HZ_PERSON_PROFILES entities, enabling the application to determine source precedence when consolidating party information from multiple third-party providers.

From a Data Vault modeling perspective, the mined foreign key structure suggests this object leans toward a satellite classification. It carries descriptive ranking attributes keyed to a parent entity attribute rather than acting as an independent hub or a many-to-many link. The table resides in the APPS_TS_SEED tablespace, reflecting its role as a seeded configuration object rather than a high-volume transactional store, and its status is VALID in both Oracle EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's primary key is defined by the composite constraint HZ_SELECT_DATA_SOURCES_PK, comprising ENTITY_ATTR_ID and CONTENT_SOURCE_TYPE. A separate unique index, HZ_SELECT_DATA_SOURCES_U1, exists with the same leading columns. In 12.2.2 the documented index also includes the ZD_EDITION_NAME column as a trailing component, reflecting edition-based redefinition support. This establishes ENTITY_ATTR_ID and CONTENT_SOURCE_TYPE together as the business-key candidate, distinct from any single surrogate identifier.

  • ENTITY_ATTR_ID — Foreign key to HZ_ENTITY_ATTRIBUTES; identifies the specific entity attribute being configured.
  • CONTENT_SOURCE_TYPE — The source of data content, providing the second half of the composite business key.
  • RANKING — Numeric ranking of the data source, determining precedence for the associated attribute.
  • CREATED_BY, CREATION_DATE — Standard WHO columns capturing row creation audit information.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard WHO columns capturing the last update audit trail.
  • LAST_UPDATE_LOGIN — Operating system login identifier of the last updater.
  • REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Concurrent program WHO columns identifying the concurrent request and program that last modified the row.
  • ZD_EDITION_NAME — Edition identifier supporting edition-based redefinition in 12.2.2.

Common Use Cases and Queries

Administrators and technical consultants query this table to audit third-party data integration configuration, verify ranking precedence, and troubleshoot attribute population behavior for person and organization profiles. A typical query joins to HZ_ENTITY_ATTRIBUTES to resolve the attribute context:

  • Listing configured rankings: SELECT entity_attr_id, content_source_type, ranking FROM hz_select_data_sources ORDER BY entity_attr_id, ranking;
  • Resolving attribute names: SELECT s.entity_attr_id, a.attribute_name, s.content_source_type, s.ranking FROM hz_select_data_sources s, hz_entity_attributes a WHERE s.entity_attr_id = a.entity_attr_id;
  • Identifying highest-precedence sources per attribute using RANK() or MIN(ranking) aggregation.
  • Auditing recent configuration changes through LAST_UPDATE_DATE and LAST_UPDATED_BY.

Related Objects

The most significant dependent object is the parent attribute definition table, joined via the documented foreign key. Other related objects include profile and entity tables referenced in the data-source population model:

  • HZ_ENTITY_ATTRIBUTES — Parent table; join on ENTITY_ATTR_ID = HZ_ENTITY_ATTRIBUTES.ENTITY_ATTR_ID.
  • HZ_ORGANIZATION_PROFILES — Organization profile data populated by ranked sources.
  • HZ_PERSON_PROFILES — Person profile data populated by ranked sources.
  • FND_USER — Referenced by CREATED_BY and LAST_UPDATED_BY.
  • FND_LOGINS — Referenced by LAST_UPDATE_LOGIN.
  • FND_CONCURRENT_REQUESTS — Referenced by REQUEST_ID.
  • FND_APPLICATION — Referenced by PROGRAM_APPLICATION_ID.