Search Results gl_archive_lines




Overview
Explore in AI Chat

Overview

The GL_ARCHIVE_LINES table is a specialized data object within the Oracle E-Business Suite (EBS) General Ledger (GL) module, specifically designed for version 12.1.1 and 12.2.2. As its name indicates, this table serves as an archive repository for journal entry line details. Its primary role is to support data retention and historical reporting by storing a copy of journal line information, potentially after the original records have been purged from the primary transaction tables for performance or data management purposes. This facilitates compliance and audit requirements while maintaining the integrity of the active transactional environment.

Key Information Stored

Based on the provided ETRM metadata, the table's structure is anchored by a composite primary key consisting of JE_HEADER_ID and JE_LINE_NUM. This key structure directly mirrors the primary key of the live GL_JE_LINES table, ensuring a one-to-one archival mapping for each journal line. The table holds critical financial data, including the accounting code combination (CODE_COMBINATION_ID) and the ledger context (SET_OF_BOOKS_ID). While the full column list is not detailed in the excerpt, the foreign key relationships confirm it stores the essential identifiers to maintain relational integrity with core General Ledger entities, preserving the archived journal line's accounting flexfield, ledger assignment, and link to its parent journal header.

Common Use Cases and Queries

The primary use case for GL_ARCHIVE_LINES is historical financial analysis and audit reporting on journal entries that are no longer resident in the active GL_JE_LINES table. A typical query would join this archive table to its referenced code combinations and sets of books to reconstruct historical journal entries. For instance, to retrieve archived journal lines for a specific ledger and accounting period, a report might use a SQL pattern such as: SELECT gal.*, gcc.segment1, gcc.segment2 FROM gl_archive_lines gal, gl_code_combinations gcc, gl_sets_of_books gsob WHERE gal.code_combination_id = gcc.code_combination_id AND gal.set_of_books_id = gsob.set_of_books_id AND gsob.name = '&LEDGER_NAME'. It is crucial to note the ETRM metadata states this table is "Not implemented in this database," indicating it may not be populated in a standard installation and its use would be contingent on specific archival processes being enabled and executed.

Related Objects

The GL_ARCHIVE_LINES table maintains strict foreign key relationships with several fundamental GL tables, as documented in the ETRM. These relationships are essential for preserving data consistency in the archive.

  • GL_JE_LINES: Linked via JE_HEADER_ID and JE_LINE_NUM. This is the most critical relationship, as the archive line is a direct copy of a record from this primary transaction table.
  • GL_SETS_OF_BOOKS: Linked via SET_OF_BOOKS_ID. This ties the archived line to its specific ledger, preserving the legal entity and accounting calendar context.
  • GL_CODE_COMBINATIONS: Linked via CODE_COMBINATION_ID. This preserves the accounting flexfield assignment (e.g., Company, Account, Cost Center) for the archived journal line.

These relationships ensure that archived data remains a coherent subset of the General Ledger's chart of accounts and ledger structure.