Search Results pay_upgrade_definitions_uk2

Overview

HR.PAY_UPGRADE_DEFINITIONS is a seed-data repository within the Oracle E-Business Suite HR (Payroll) schema that stores the catalog of data upgrades that may need to be performed during patching, release application, or datamodel migration activities. Each row defines a single upgrade: its internal identity, its descriptive label, the legislation it applies to, and a set of control attributes that govern how, when, and whether the upgrade procedure executes. The table serves as the master definition registry for the Payroll upgrade framework; the accompanying parameter and status tables consume these definitions to drive and track actual upgrade runs.

From a heuristic Data Vault modeling perspective, this object behaves as a hub. Its primary key, UPGRADE_DEFINITION_ID, provides a stable surrogate business key for each upgrade, while descriptive attributes such as NAME, DESCRIPTION, and the procedural columns act as dependent descriptive data. The unique index PAY_UPGRADE_DEFINITIONS_UK2 on (SHORT_NAME, ZD_EDITION_NAME) further reinforces the hub role by establishing a natural composite business key that combines the internal upgrade name with the edition discriminator.

Key Information Stored

The table's 23 documented columns divide into identity, descriptive, control, and audit groups. The most significant include:

• UPGRADE_DEFINITION_ID — System-generated primary key (PAY_UPGRADE_DEFINITIONS_PK); the surrogate identifier referenced by all dependent tables.
• SHORT_NAME — Internal name for the upgrade (VARCHAR2 30); the first component of the PAY_UPGRADE_DEFINITIONS_UK2 business key.
• ZD_EDITION_NAME — Edition discriminator; the second component of the unique business key.
• NAME — Descriptive name of the upgrade (VARCHAR2 80).
• LEGISLATION_CODE — Legislation the upgrade targets.
• UPGRADE_LEVEL — Defines the scope of the upgrade.
• CRITICALITY — Advises the user on the importance of the data upgrade.
• THREADING_LEVEL — Determines how the upgrade process distributes work across parallel threads.
• FAILURE_POINT — Determines whether the system should error based on the upgrade outcome.
• LEGISLATIVELY_ENABLED — Determines whether legislations must enable a global upgrade.
• UPGRADE_METHOD — Indicates how the upgrade can be performed.
• UPGRADE_PROCEDURE — The actual procedure that performs the upgrade.
• QUALIFYING_PROCEDURE — Indicates whether the object defined by THREADING_LEVEL requires the upgrade to run.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE — Standard Who audit columns tracking row provenance.

Common Use Cases and Queries

Administrators and developers query this table to enumerate available upgrades, filter by legislation, or inspect execution control attributes. A typical listing retrieves the internal and descriptive identifiers:

SELECT short_name, name, legislation_code, upgrade_level, criticality
FROM   hr.pay_upgrade_definitions
ORDER BY legislation_code, short_name;

Because SHORT_NAME and ZD_EDITION_NAME form the unique business key, lookups by internal name are efficient:

SELECT upgrade_definition_id, name, upgrade_procedure
FROM   hr.pay_upgrade_definitions
WHERE  short_name = :p_short_name
AND    zd_edition_name = :p_edition;

Joining to PAY_UPGRADE_STATUS provides execution tracking for each defined upgrade, supporting monitoring and patch-validation reports. Filtering on CRITICALITY or FAILURE_POINT assists in prioritizing high-risk upgrades during release cycles.

Related Objects

Two dependent tables reference this object through foreign keys on UPGRADE_DEFINITION_ID:

• PAY_UPGRADE_PARAMETERS — Holds parameter rows bound to a given upgrade definition; join on UPGRADE_DEFINITION_ID.
• PAY_UPGRADE_STATUS — Records per-definition execution status; join on UPGRADE_DEFINITION_ID.

The FND Design Data identifier PAY.PAY_UPGRADE_DEFINITIONS confirms its registration under the Payroll application, and the standard Who columns relate the table to FND_USER and FND_LOGINS for audit attribution. Together these objects form the core of the Payroll upgrade control framework.