Search Results hr_dm_databases

Overview

HR_DM_DATABASES is a Human Resources (PER) module table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as a registry of database names participating in a "database farm" configuration, supporting the Data Migration / Data Management (DM) infrastructure used by Oracle HRMS to distribute and coordinate sequence ranges and sequence histories across multiple physical databases. In practical terms, it serves as the master list that other HR DM components reference when assigning or tracking data-migration work across a distributed environment.

From a Data Vault modeling perspective, the mined metadata classifies this table as hub-leaning. The presence of a surrogate primary key (DATABASE_ID), a business-key unique index (DATABASE_NAME), and multiple downstream foreign key dependents is consistent with a hub entity that anchors descriptive and transactional satellites. This classification is a heuristic modeling suggestion rather than an enforced design; in native EBS terms the table simply behaves as a reference/master code table.

Key Information Stored

The table contains ten documented columns. The most significant are:

DATABASE_ID — surrogate primary key defined by HR_DM_DATABASES_PK; the join key used by all dependent tables.
DATABASE_NAME — the database name; enforced by unique index HR_DM_DATABASES_UK1 and the natural business-key candidate.
SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, applying multi-tenant / business-group data partitioning.
DESCRIPTION — free-text descriptive label for the database entry.
USER_NAME — the database user name associated with the registered database.
LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard EBS audit/who columns tracking record creation and modification.

The distinction between the surrogate key (DATABASE_ID) and the business key (DATABASE_NAME) matters: integrations should resolve records via DATABASE_NAME on input, then persist DATABASE_ID on the dependent rows.

Common Use Cases and Queries

Typical scenarios include identifying the database associated with a sequence history row, resolving which databases host active sequence ranges, and validating database registration before migration jobs run. A representative join pattern:

Resolve sequence histories to database names:

SELECT h.*, d.database_name
FROM   hr_dm_sequence_histories h,
       hr_dm_databases d
WHERE  h.database_id = d.database_id;

List databases currently holding sequence ranges:

SELECT d.database_name, r.*
FROM   hr_dm_sequence_ranges r,
       hr_dm_databases d
WHERE  r.database_id = d.database_id;

Look up a database by business key:

SELECT database_id, description
FROM   hr_dm_databases
WHERE  database_name = :name;

Reporting uses include auditing database farm topology, confirming SECURITY_GROUP_ID partitioning, and tracing DM activity to its source database prior to reconciliation.

Related Objects

The following objects are documented as directly related through foreign key relationships:

HR_DM_SEQUENCE_HISTORIES — references HR_DM_DATABASES via DATABASE_ID; records sequence assignment history per database.
HR_DM_SEQUENCE_RANGES — references HR_DM_DATABASES via DATABASE_ID; records sequence ranges allocated per database.
BISM_DATABASE — references HR_DM_DATABASES via DATABASE_ID; a downstream dependent mapping databases to Business Intelligence/analytics configuration.
FND_SECURITY_GROUPS — referenced by HR_DM_DATABASES.SECURITY_GROUP_ID; provides the security group definition used for row-level partitioning.

These relationships confirm HR_DM_DATABASES' role as a stable hub for sequence-management and database-registry activities within the HRMS data-migration infrastructure.

Table: HR_DM_DATABASES 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PER.HR_DM_DATABASES, object_name:HR_DM_DATABASES, status:VALID, product: PER - Human Resources , description: Table containing names of all databases within database farm , implementation_dba_data: HR.HR_DM_DATABASES ,
Table: HR_DM_DATABASES 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PER.HR_DM_DATABASES, object_name:HR_DM_DATABASES, status:VALID, product: PER - Human Resources , description: Table containing names of all databases within database farm , implementation_dba_data: HR.HR_DM_DATABASES ,
Table: HR_DM_SEQUENCE_RANGES 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PER.HR_DM_SEQUENCE_RANGES, object_name:HR_DM_SEQUENCE_RANGES, status:VALID, product: PER - Human Resources , description: Table containing Sequence Ranges for particular Sequence and Database. This table can hold multiple Ranges for a given Sequence and Database. , implementation_dba_data: HR.HR_DM_SEQUENCE_RANGES ,
Table: HR_DM_SEQUENCE_RANGES 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PER.HR_DM_SEQUENCE_RANGES, object_name:HR_DM_SEQUENCE_RANGES, status:VALID, product: PER - Human Resources , description: Table containing Sequence Ranges for particular Sequence and Database. This table can hold multiple Ranges for a given Sequence and Database. , implementation_dba_data: HR.HR_DM_SEQUENCE_RANGES ,
Table: HR_DM_SEQUENCE_HISTORIES 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PER.HR_DM_SEQUENCE_HISTORIES, object_name:HR_DM_SEQUENCE_HISTORIES, status:VALID, product: PER - Human Resources , description: Table containing sequence information from the different Fidelity databases. To be updated before any changes to sequences are made to enable sequence history tracking. , implementation_dba_data: HR.HR_DM_SEQUENCE_HISTORIES ,
Table: HR_DM_SEQUENCE_HISTORIES 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PER.HR_DM_SEQUENCE_HISTORIES, object_name:HR_DM_SEQUENCE_HISTORIES, status:VALID, product: PER - Human Resources , description: Table containing sequence information from the different Fidelity databases. To be updated before any changes to sequences are made to enable sequence history tracking. , implementation_dba_data: HR.HR_DM_SEQUENCE_HISTORIES ,