Search Results hr_owner_definitions_pk

Overview

HR.HR_OWNER_DEFINITIONS is a seed data table within the Oracle E-Business Suite Human Resources (HR) schema. It is designated as an Oracle Internal Use Only object, meaning Oracle Corporation does not support direct customer access to its data except through standard Oracle Applications programs. The table resides in the APPS_TS_SEED tablespace, which is characteristic of reference and setup data rather than transactional data. Its FND Design Data identifier is PAY.HR_OWNER_DEFINITIONS, reflecting its association with the Payroll (PAY) product family and its delivery as part of the application's seed data layer.

The object is classified as VALID and exhibits a standalone structural profile, with no foreign-key references to other database objects documented in the ETRM metadata. Under a heuristic Data Vault modeling assessment, this object would best be represented as a hub, since it holds a distinct business key (the combination of SESSION_ID and PRODUCT_SHORT_NAME) without satellite-style descriptive attributes or link-style associations to other hubs. This classification is a modeling suggestion only; the physical table is a conventional Oracle relational table.

Key Information Stored

The table is deliberately narrow, with only three documented columns in the 12.2.2 physical schema. The most significant columns are:

• SESSION_ID (NUMBER, length 15) — A numeric identifier representing the session context under which the owner definition is registered. It forms the first component of the primary key and is mandatory.
• PRODUCT_SHORT_NAME (VARCHAR2, length 30) — The short name of the product or application owning the definition. This value is the second component of the primary key and the primary business-key candidate.
• ZD_EDITION_NAME — An editioning column introduced with the Oracle EBS 12.2.2 edition-based redefinition architecture. It is included in the unique index HR_OWNER_DEFINITIONS_PK as the third component.

The primary key, HR_OWNER_DEFINITIONS_PK, is a UNIQUE NORMAL index built on (SESSION_ID, PRODUCT_SHORT_NAME) in the 12.1.1 documentation and extended to (SESSION_ID, PRODUCT_SHORT_NAME, ZD_EDITION_NAME) in the 12.2.2 schema. The index resides in the APPS_TS_SEED tablespace, mirroring the table's own storage placement with PCT Free of 10. The SESSION_ID and PRODUCT_SHORT_NAME pairing constitutes the business-key candidate surfaced by the unique index; there is no separate surrogate key column distinct from SESSION_ID in the documented metadata.

Common Use Cases and Queries

Because the table is seeded and internally scoped, its practical use is confined to diagnostics, data validation, and EBS upgrade or patching investigations. A baseline query retrieves the full owner definition set:

• Session validation — Confirming which products are registered under a given SESSION_ID during concurrent processing or session-scoped operations.
• Product coverage checks — Enumerating distinct PRODUCT_SHORT_NAME values to verify that all expected application owners are present after patching or cloning.
• Seed-data integrity audits — Detecting duplicate or missing primary-key combinations that would indicate an incomplete seed load.

The canonical query documented in ETRM is: SELECT SESSION_ID, PRODUCT_SHORT_NAME FROM HR.HR_OWNER_DEFINITIONS; In 12.2.2 environments this should be extended to include ZD_EDITION_NAME where edition-aware logic is required. Because the object is flagged Oracle Internal Use Only, queries should be treated as read-only diagnostics rather than integration points, and direct DML should never be performed outside standard Oracle Applications programs.

Related Objects

The dependency metadata for HR.HR_OWNER_DEFINITIONS is notably sparse: the table does not reference any other database object, and it is referenced only by its own synonyms. The documented relationships are:

• APPS.HR_OWNER_DEFINITIONS — The APPS-schema synonym through which application code and SQL sessions normally resolve the object, joined implicitly on SESSION_ID and PRODUCT_SHORT_NAME.
• PUBLIC.HR_OWNER_DEFINITIONS — A public synonym providing global name resolution for the same underlying table.

No foreign-key or view dependencies beyond these synonyms are documented in the ETRM metadata. Consumers seeking related HR and PAY objects should consult the parent PRODUCT_SHORT_NAME values to identify the owning application modules, but the table itself participates in no documented referential network. Its isolation reinforces its role as a lightweight session-to-product ownership registry rather than a transactional or associative entity.