Search Results hr_dm_sequence_histories

Overview

The HR_DM_SEQUENCE_HISTORIES table resides in the HR schema and belongs to the PER (Human Resources) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. As documented in the ETRM repository, it stores sequence information originating from different Fidelity databases, and its stated purpose is to be updated before any change is made to a sequence, thereby enabling sequence history tracking. In practice the table functions as an audit-trail repository: each row captures the value of a tracked database sequence at a specific point in time, correlated to the sequence definition and the database on which it resides.

From a Data Vault modeling perspective, the mined foreign-key structure suggests classifying this object as a link. The table sits between two reference entities — sequence definitions and databases — and records the intersection of those two identifiers at a point in time, which is the classic shape of a link table. Modelers may prefer to treat it as a link with a satellite-like payload, since SEQUENCE_VALUE, TIMESTAMP, and the standard WHO columns behave as descriptive, time-stamped attributes rather than pure relationship keys.

Key Information Stored

The table carries 11 documented columns. The most important include:

SEQUENCE_HISTORY_ID — the surrogate primary key, defined by the HR_DM_SEQUENCE_HISTORIES_PK index. It uniquely identifies each history row.
SEQUENCE_ID — foreign key to HR_DM_SEQUENCE_DEFINITIONS, identifying which sequence is being tracked. Part of the business-key candidate.
DATABASE_ID — foreign key to HR_DM_DATABASES, identifying the source Fidelity database. Part of the business-key candidate.
TIMESTAMP — the point in time at which the sequence value was captured. Part of the business-key candidate.
SEQUENCE_VALUE — the recorded value of the sequence at that timestamp.
LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — the standard Oracle EBS audit columns (WHO columns).
SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting multi-tenant or business-group data segregation.

The unique index HR_DM_SEQUENCE_HISTORIES_UK1 on (SEQUENCE_ID, DATABASE_ID, TIMESTAMP) is the documented business-key candidate, confirming that a sequence/database/timestamp triplet must be unique.

Common Use Cases and Queries

Typical use cases revolve around auditing and reconciling sequence values across Fidelity databases. A common pattern is to retrieve the latest recorded value for a given sequence and database:

Reporting the most recent sequence value: SELECT SEQUENCE_VALUE FROM HR.HR_DM_SEQUENCE_HISTORIES WHERE SEQUENCE_ID = :seq AND DATABASE_ID = :db ORDER BY TIMESTAMP DESC.
Producing a full history for a sequence: join HR_DM_SEQUENCE_DEFINITIONS to HR_DM_SEQUENCE_HISTORIES on SEQUENCE_ID and filter by TIMESTAMP range.
Confirming that a history row was written before a sequence change — a compliance check by comparing CREATION_DATE to the sequence modification event.
Cross-database reconciliation: group by DATABASE_ID to compare SEQUENCE_VALUE across databases.

Related Objects

HR_DM_SEQUENCE_DEFINITIONS — joined via HR_DM_SEQUENCE_HISTORIES.SEQUENCE_ID; supplies the sequence definition.
HR_DM_DATABASES — joined via HR_DM_SEQUENCE_HISTORIES.DATABASE_ID; supplies the source database context.
FND_SECURITY_GROUPS — joined via HR_DM_SEQUENCE_HISTORIES.SECURITY_GROUP_ID; enforces data group security.

These three tables constitute the documented relationship footprint of HR_DM_SEQUENCE_HISTORIES and are the primary objects referenced when building audit or reconciliation reports against it.

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 ,
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_DEFINITIONS 12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PER.HR_DM_SEQUENCE_DEFINITIONS, object_name:HR_DM_SEQUENCE_DEFINITIONS, status:VALID, product: PER - Human Resources , description: Table containing Sequence Name information for the PER/PAY/DT/FF/OTA/SSP/GHR/HXT/BEN applications. , implementation_dba_data: HR.HR_DM_SEQUENCE_DEFINITIONS ,
Table: HR_DM_SEQUENCE_DEFINITIONS 12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PER.HR_DM_SEQUENCE_DEFINITIONS, object_name:HR_DM_SEQUENCE_DEFINITIONS, status:VALID, product: PER - Human Resources , description: Table containing Sequence Name information for the PER/PAY/DT/FF/OTA/SSP/GHR/HXT/BEN applications. , implementation_dba_data: HR.HR_DM_SEQUENCE_DEFINITIONS ,