Search Results gl_archive_headers_pk




Overview
Explore in AI Chat

Overview

The GL_ARCHIVE_HEADERS table is a core data structure within the Oracle E-Business Suite (EBS) General Ledger (GL) module, specifically designed for the archival of journal entry headers. Its primary role is to serve as a historical repository, preserving the header-level metadata of journal entries that have been posted and subsequently archived from the primary transactional tables. This archival process is critical for maintaining database performance by managing data volume in active tables while ensuring compliance and auditability through the permanent retention of financial transaction history. The documentation note "Not implemented in this database" indicates this table's structure is predefined by the application but may not be populated in all implementations, depending on the archival policies and procedures configured by the organization.

Key Information Stored

The table stores a comprehensive set of attributes that define a journal entry's context. The primary identifier is the JE_HEADER_ID, which forms the table's primary key (GL_ARCHIVE_HEADERS_PK) and links back to the original entry in GL_JE_HEADERS. A unique key (GL_ARCHIVE_HEADERS_UK1) also exists on the combination of JE_BATCH_ID and NAME, enforcing data integrity for archived batch and journal names. Other critical columns include SET_OF_BOOKS_ID for the ledger context, CURRENCY_CODE, ENCUMBRANCE_TYPE_ID for tracking commitments, BUDGET_VERSION_ID for budgetary control, and ACCRUAL_REV_JE_HEADER_ID for managing reversing entries. These fields collectively capture the essential financial and organizational dimensions of the archived journal.

Common Use Cases and Queries

The primary use case is historical reporting and audit inquiry for journal entries that are no longer resident in the live GL_JE_HEADERS table. Financial auditors may query this table to verify the completeness and integrity of the journal archive. A common reporting pattern involves joining this table to its related archive detail table (typically GL_ARCHIVE_LINES) to reconstruct full journal entries for period-end reconciliations or long-term trend analysis. A sample query to retrieve archived journal headers for a specific ledger and period might follow this pattern:

  • SELECT archive_hdr.name, archive_hdr.je_category, archive_hdr.period_name, archive_hdr.status FROM gl_archive_headers archive_hdr WHERE archive_hdr.set_of_books_id = :ledger_id AND archive_hdr.period_name = :period_name;

Technical administrators may also reference this table when executing or validating data purge processes for the General Ledger module.

Related Objects

The GL_ARCHIVE_HEADERS table maintains extensive foreign key relationships with fundamental GL setup and transactional tables, ensuring referential integrity for archived data. As documented in the ETRM metadata, key relationships include:

This table is the header-level counterpart to the GL_ARCHIVE_LINES table, with which it would share a key relationship (typically JE_HEADER_ID) to form complete archived journals.