Search Results ap_distribution_set_lines_all




Overview
Explore in AI Chat

Overview

The GL_SETS_OF_BOOKS_11I table is a core data repository within the Oracle E-Business Suite General Ledger (GL) module. It stores the fundamental definition of a Set of Books, which was the primary organizational unit for financial reporting and accounting in releases prior to Oracle EBS R12. In the context of Oracle EBS 12.1.1 and 12.2.2, this table remains a critical component for backward compatibility and data integrity, housing the original configuration for ledgers that have been upgraded from the 11i release. Its primary role is to define the accounting structure, including the chart of accounts, functional currency, accounting calendar, and retained earnings account, forming the backbone for all transactional accounting within the associated ledger.

Key Information Stored

The table's primary key is SET_OF_BOOKS_ID, a unique numeric identifier. The NAME column provides the unique descriptive name of the Set of Books and is also a unique key. Other critical columns define the accounting framework: CURRENCY_CODE (functional currency), CHART_OF_ACCOUNTS_ID (links to the flexfield structure), and TRANSACTION_CALENDAR_ID (accounting period calendar). The table also stores key code combination IDs for specific accounting purposes, such as RET_EARN_CODE_COMBINATION_ID (Retained Earnings), NET_INCOME_CODE_COMBINATION_ID (Net Income), and ROUNDING_CODE_COMBINATION_ID. Additional columns control translation and conversion rate types, like DAILY_TRANSLATION_RATE_TYPE.

Common Use Cases and Queries

This table is central to reporting, data validation, and upgrade analysis. Common use cases include generating a list of all upgraded ledgers for audit purposes, validating ledger configurations during financial integrations, and troubleshooting transactional posting errors by verifying key account combinations. A typical query retrieves the core definition of a Set of Books:

  • SELECT sob.name, sob.currency_code, cc.concatenated_segments ret_earnings_acct FROM gl_sets_of_books_11i sob, gl_code_combinations cc WHERE sob.ret_earn_code_combination_id = cc.code_combination_id AND sob.set_of_books_id = :ledger_id;

Another common pattern involves joining with the GL_LEDGERS table (the R12 successor) to map legacy Set of Books IDs to their modern ledger counterparts for cross-version reporting.

Related Objects

GL_SETS_OF_BOOKS_11I maintains extensive foreign key relationships, underscoring its foundational role. It references key configuration tables: FND_CURRENCIES (CURRENCY_CODE), GL_DAILY_CONVERSION_TYPES (DAILY_TRANSLATION_RATE_TYPE), GL_TRANSACTION_CALENDAR (TRANSACTION_CALENDAR_ID), and GL_CODE_COMBINATIONS for various key accounts (e.g., RET_EARN_CODE_COMBINATION_ID). Crucially, numerous transactional and setup tables in other modules reference it via the SET_OF_BOOKS_ID column, including:

These relationships ensure financial transactions are consistently posted to the correct accounting entity, even after an upgrade to the ledger architecture.