Search Results hr_dm_phase_rules

Overview

HR_DM_PHASE_RULES is a Human Resources (PER) module table in the Oracle E-Business Suite database, owned by the HR schema. It stores the configuration rules that govern which processing phases apply to which data migration activities. In effect, the table acts as a routing and sequencing map for the migration engine, determining the phase-to-migration relationships that drive the order and applicability of migration steps. The table is classified as VALID and contains 12 documented columns in the ETRM 12.2.2 physical schema, applicable to both 12.1.1 and 12.2.2 environments.

From a Data Vault modeling perspective, the heuristic classification mined from the foreign-key structure is standalone. This suggests the table be treated as a standalone reference or configuration entity rather than modeled as a hub, link, or satellite in a Data Vault design. Because it is essentially reference data controlling migration behavior, its primary value is as a lookup source for migration orchestration logic.

Key Information Stored

The table's primary key is the surrogate identifier PHASE_RULE_ID, enforced through the unique index HR_DM_PHASE_RULES_PK. This column uniquely identifies each phase rule record. The remaining columns capture the rule definition and standard EBS audit and security attributes.

• PHASE_RULE_ID — Surrogate primary key for each rule row.
• MIGRATION_TYPE — Identifies the migration category to which the rule applies.
• PHASE_NAME — The name of the phase being governed by the rule.
• PREVIOUS_PHASE — The phase that must precede the current phase in the sequence.
• NEXT_PHASE — The phase that follows, establishing forward ordering.
• DATABASE_LOCATION — Indicates the database location context for the phase.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, providing multi-tenant security grouping.
• LAST_UPDATE_DATE and LAST_UPDATED_BY — Standard audit tracking of the most recent change.
• CREATION_DATE and CREATED_BY — Audit attributes recording initial row creation.
• LAST_UPDATE_LOGIN — Login identifier associated with the last update.

The documented unique index is limited to the primary key on PHASE_RULE_ID; no separate business-key candidate is documented, though MIGRATION_TYPE combined with PHASE_NAME naturally forms a logical composite key for the rule definition.

Common Use Cases and Queries

Typical uses center on validating, reporting, and troubleshooting migration sequencing. DBAs and migration consultants query this table to confirm the phase order for a given migration type, to trace predecessor and successor phases, and to audit security group assignments.

A representative query to retrieve the phase sequence for a migration type:

• SELECT MIGRATION_TYPE, PHASE_NAME, PREVIOUS_PHASE, NEXT_PHASE, DATABASE_LOCATION FROM HR.HR_DM_PHASE_RULES WHERE MIGRATION_TYPE = :type ORDER BY PHASE_RULE_ID;
• SELECT r.PHASE_NAME, r.NEXT_PHASE FROM HR.HR_DM_PHASE_RULES r WHERE r.PREVIOUS_PHASE = :phase;
• SELECT r.PHASE_RULE_ID, g.SECURITY_GROUP_NAME FROM HR.HR_DM_PHASE_RULES r, FND_SECURITY_GROUPS g WHERE r.SECURITY_GROUP_ID = g.SECURITY_GROUP_ID;

These patterns support migration readiness assessments, change-control reviews, and validation that phase dependencies are correctly configured before a migration run.

Related Objects

The documented foreign-key relationship connects this table to the security model, while the table itself references migration and phase entities conceptually.

• FND_SECURITY_GROUPS — Joined on SECURITY_GROUP_ID; the only documented foreign-key reference.
• HR_DM_PHASE_RULES_PK — The primary key index referenced by dependent lookups.
• HR_DM_MIGRATION_RULES — Sibling migration-control table typically consulted alongside phase rules.
• FND_APPLICATION — Referenced indirectly through migration type context.
• FND_LOOKUP_VALUES — May define valid MIGRATION_TYPE or PHASE_NAME values.

Because the table is classified as standalone with a single documented foreign key, dependency analysis is comparatively simple, concentrating on the security group join and migration-orchestration consumers.