Search Results jty_dea_values_idx_header




Overview
Explore in AI Chat

Overview

The JTY_DEA_VALUES_IDX_HEADER table is a repository object in the Oracle E-Business Suite CRM Foundation module (product code JTF). It stores index header records used for date effectivity assignment — the mechanism by which EBS governs the temporal validity of resource, qualification, and assignment data. Each row represents a header-level index entry that ties a source record to a named index, optionally scoped by a qualification usage and a security group. The table resides in the JTF schema and is marked VALID in both Oracle EBS 12.1.1 and 12.2.2.

From a data-modeling perspective, the ETRM heuristic classification places this object as standalone — that is, it does not behave as a pure hub, link, or satellite in Data Vault terms, but instead carries its own surrogate key while holding foreign-key references outward to qualification usage and security group master data. This classification should be read as a modeling suggestion: the table functions as a lightweight reference/index registry rather than a transactional fact or a dependent satellite.

Key Information Stored

The table comprises 14 documented columns. The surrogate primary key is DEA_VALUES_IDX_HEADER_ID, which is also the sole unique index (JTY_DEA_VALUES_IDX_HEADER_U1) and therefore the documented business-key candidate. Key columns include:

Common Use Cases and Queries

Typical reporting and diagnostic scenarios include identifying all indexes registered for a given qualification usage or security group, auditing which headers lack a built index, and reconciling soft-deleted records. A representative query joining to qualification usage master data:

  • Index inventory by qualification usage: SELECT h.dea_values_idx_header_id, h.index_name, h.build_index_flag FROM jtf.jty_dea_values_idx_header h, jtf.jtf_qual_usgs_all q WHERE h.qual_usg_id = q.qual_usg_id AND h.delete_flag = 'N';
  • Security-scoped listing: join SECURITY_GROUP_ID to FND_SECURITY_GROUPS to validate row-level access.
  • Pending index builds: filter on BUILD_INDEX_FLAG to locate headers awaiting index construction.

Related Objects

  • JTF_QUAL_USGS_ALL — referenced via QUAL_USG_ID; qualification usage master defining the semantics of the index.
  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; governs row-level security.
  • JTY_DEA_VALUES_IDX_* child tables — likely detail/value tables linked by DEA_VALUES_IDX_HEADER_ID (unconfirmed in provided metadata).
  • JTF date-effectivity packages — PL/SQL APIs consuming this header during assignment processing.