Search Results key_type_id




Overview
Explore in AI Chat

Overview

APPS.HR_SUMMARY_KEY_TYPE2 is a seeded Oracle E-Business Suite database view owned by the APPS schema and registered in FND Design Data under the application short name PER (Human Resources). It is documented in ETRM for releases 12.1.1 and 12.2.2 and carries a status of VALID. The view is classified in the ETRM metadata as a "supplementary view used to simplify forms coding," which identifies it as a forms-support construct rather than a general-purpose reporting interface. ETRM explicitly warns that Oracle does not recommend querying or altering data through this view and that its definition may change dramatically in subsequent minor or major releases.

In practice, HR_SUMMARY_KEY_TYPE2 exposes the key-type metadata that drives the summarization framework used by Oracle HRMS. Because the object is seeded and shipped by Oracle, it falls within the category of seeded data that customers reference for configuration and validation purposes but should not modify. The presence of a SEEDED_DATA column is directly relevant to that distinction: it allows the forms layer to identify records delivered by Oracle as opposed to records created by a customer or localization team.

Underlying Base Objects

The ETRM dependency information records a single referenced base object: the synonym HR_SUMMARY in the APPS schema. The view is not referenced by any other database object, confirming that it functions as a terminal, presentation-oriented layer rather than a building block for other database constructs. Column-level lineage is not documented in the ETRM excerpt, but the naming and structure indicate that HR_SUMMARY_KEY_TYPE2 selects from the key-type portion of the HR_SUMMARY synonym, translating internal identifiers and audit columns into a form-friendly projection.

The view is delivered as part of the PER product family and is therefore upgraded and patched alongside Oracle HRMS. Because it is a synonym-backed view rather than a base table, its contents are derived at query time and inherit the security and business-group partitioning applied by the underlying HR_SUMMARY object.

Key Columns

  • ROW_ID (ROWID) — The physical row identifier of the underlying record, used by Oracle Forms for row-level operations.
  • KEY_TYPE_ID (NUMBER, 15) — Primary identifier for the summary key type.
  • BUSINESS_GROUP_ID (NUMBER, 15) — The business group that owns the key type, enforcing multi-tenant partitioning within HRMS.
  • OBJECT_VERSION_NUMBER (NUMBER) — Optimistic locking column used by the forms layer to detect concurrent updates.
  • NAME (VARCHAR2, 240) — The user-visible name of the key type.
  • KEY_FUNCTION (VARCHAR2, 4000) — The function or expression associated with the key type, used to derive the summarized value.
  • SEEDED_DATA (VARCHAR2, 240) — Flag or descriptor indicating whether the record is Oracle-seeded, which governs whether the configuration may be edited.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard audit columns populated by the HRMS audit framework.

Common Use Cases and Queries

Because ETRM advises against direct querying, the primary use case is diagnostic: administrators and technical consultants query the view to confirm which summary key types are seeded, which are customer-defined, and how key functions are configured. The SEEDED_DATA column is typically the filter of interest.

A representative query lists all key types for a business group:

SELECT key_type_id, name, key_function, seeded_data
FROM apps.hr_summary_key_type2
WHERE business_group_id = :p_business_group_id;

To isolate Oracle-seeded definitions only:

SELECT name, key_function
FROM apps.hr_summary_key_type2
WHERE seeded_data = 'Y';

Traceability queries join KEY_TYPE_ID and BUSINESS_GROUP_ID back to the HR_SUMMARY synonym. Analysts should treat results as read-only, avoid building permanent interfaces on this view, and validate any dependency against the target release, since Oracle reserves the right to restructure the definition between 12.1.1, 12.2.2, and later upgrades.