Search Results gl_sets_of_books




Overview
Explore in AI Chat

Overview

The GL_SETS_OF_BOOKS table is the central repository for the definition of a Set of Books (SOB) within Oracle E-Business Suite General Ledger. In releases 12.1.1 and 12.2.2, a Set of Books is a fundamental financial entity that defines a complete and independent accounting environment. It establishes the core accounting rules, including the chart of accounts, functional currency, accounting calendar, and retained earnings account, under which an organization records its transactions. This table is critical for the financial architecture of EBS, as nearly all transactional modules (e.g., AP, AR, FA) post accounting entries to a specific Set of Books. The metadata indicates it is a definitional table with extensive foreign key relationships to other core GL configuration tables.

Key Information Stored

The table stores the complete configuration for each ledger. Key columns, as indicated by the foreign key relationships, include SET_OF_BOOKS_ID (the primary key), NAME (a unique identifier), and CURRENCY_CODE (defining the functional currency). Crucially, it stores foreign keys to other defining entities: PERIOD_SET_NAME links to GL_PERIOD_SETS for the accounting calendar, ACCOUNTED_PERIOD_TYPE links to GL_PERIOD_TYPES, and TRANSACTION_CALENDAR_ID links to GL_TRANSACTION_CALENDAR. Furthermore, it holds references to specific code combinations (accounts) for critical purposes such as retained earnings (RET_EARN_CODE_COMBINATION_ID), rounding differences (ROUNDING_CODE_COMBINATION_ID), and net income (NET_INCOME_CODE_COMBINATION_ID). The DAILY_TRANSLATION_RATE_TYPE column links to GL_DAILY_CONVERSION_TYPES, governing currency translation.

Common Use Cases and Queries

This table is primarily referenced for reporting, integration, and data validation. Common use cases include generating a list of all configured ledgers for an implementation report, validating setup during month-end close, or identifying the specific accounting rules for a given transaction batch. A typical query retrieves the core setup for all active Sets of Books:

  • SELECT sob.name, sob.currency_code, ps.name period_set, pt.period_type
    FROM gl_sets_of_books sob,
    gl_period_sets ps,
    gl_period_types pt
    WHERE sob.period_set_name = ps.period_set_name
    AND sob.accounted_period_type = pt.period_type
    ORDER BY sob.name;

Another frequent pattern is joining to transactional tables from subledgers (like AP or AR) via the SET_OF_BOOKS_ID to report on or reconcile cross-module data within a single ledger context.

Related Objects

As the metadata extensively details, GL_SETS_OF_BOOKS has a vast network of dependencies. It is a parent table to numerous transactional tables across the application, particularly in the multicurrency (MC) tables of Receivables (AR_MC_%) and other modules (AP_CHECK_TRANSMISSIONS, etc.). Its primary relationships are definitional, serving as a child to key GL setup tables: GL_PERIOD_SETS, GL_PERIOD_TYPES, GL_TRANSACTION_CALENDAR, FND_CURRENCIES, GL_DAILY_CONVERSION_TYPES, and GL_CODE_COMBINATIONS (for various default accounts). In Oracle EBS R12, the concept of a Set of Books is largely synonymous with the "Ledger," and this table's logical equivalent in later documentation is often referenced in the context of the Accounting Setup Manager.