Search Results gl_je_batches_headers_v




DeepSeek eTRM - SQLGL Tables and Views in Oracle EBS 12.1.1/12.2.2

The Oracle E-Business Suite (EBS) General Ledger (GL) module relies on a structured database schema comprising core tables and views to manage financial data. DeepSeek eTRM (Electronic Technical Reference Manual) provides comprehensive documentation on these database objects for versions 12.1.1 and 12.2.2. Below is a detailed analysis of key SQLGL components:

Core SQLGL Tables

  • GL_JE_HEADERS - Stores journal entry header information including batch ID, period, currency, and status. Primary key is JE_HEADER_ID.
  • GL_JE_LINES - Contains journal line items with account combinations, amounts, and references. Linked to GL_JE_HEADERS via JE_HEADER_ID.
  • GL_JE_BATCHES - Maintains batch details for grouping journal entries with attributes like batch name and status.
  • GL_BALANCES - Stores period-end account balances by currency with columns for actual, budget, and encumbrance amounts.
  • GL_CODE_COMBINATIONS - Central reference table for all valid accounting flexfield combinations with segment values.

Critical SQLGL Views

  • GL_JE_HEADERS_V - Enhanced view of journal headers with additional descriptive columns from related tables.
  • GL_JE_LINES_V - Comprehensive view of journal lines with account segment descriptions and currency information.
  • GL_BALANCES_V - Balance reporting view incorporating account descriptions and translated segment values.
  • GL_CODE_COMBINATIONS_V - Flexfield combination view with concatenated segments and validation logic.

Technical Architecture

The SQLGL schema follows Oracle's application-tiered architecture:

  1. Base Tables - Physical storage of transactional data with constraints and indexes
  2. API Tables - Intermediate tables for data validation during import processes
  3. Summary Tables - Aggregated data structures for reporting performance
  4. Public Views - Application-facing objects with business logic and security

Version-Specific Considerations

Between 12.1.1 and 12.2.2, key changes include:

  • Enhanced partitioning strategies in 12.2.2 for GL_BALANCES
  • Additional columns in GL_JE_HEADERS for subledger accounting
  • New indexes for SOB (Set of Books) ID in transaction tables
  • Optimized views for Financial Reporting compliance

Integration Points

SQLGL tables integrate with:

  • AP_INVOICES for payables accounting
  • AR_CASH_RECEIPTS for receivables postings
  • FA_DEPRN_DETAIL for asset depreciation
  • XLA_AE_LINES for subledger accounting

DeepSeek eTRM provides complete data dictionaries including column definitions, constraints, indexes, and relationships for all SQLGL objects. The documentation enables technical teams to develop custom reports, troubleshoot issues, and optimize GL-related processes while maintaining data integrity.