Search Results gl_sets_of_books_u1

Overview

GL.GL_SETS_OF_BOOKS_11I is the core General Ledger configuration table in Oracle E-Business Suite 12.1.1 and 12.2.2 that defines each accounting set of books (ledger) in the applications. It stores the fundamental accounting identity of an organization: the chart of accounts structure, the functional currency, the accounting calendar, and the period type against which all journal entries, balances, and reporting are maintained. Every subledger transaction ultimately resolves to a set of books, and this table supplies the context—currency, calendar, and chart of accounts—that governs how that transaction is accounted, converted, and reported.

The table is owned by the GL schema, resides in the APPS_TS_TX_DATA tablespace, and is registered under FND Design Data as SQLGL.GL_SETS_OF_BOOKS_11I. It carries the Oracle internal-use warning, meaning direct DML is unsupported outside standard Oracle Applications programs; supported maintenance is performed through the Accounting Setup Manager and related setup forms and APIs. In a Data Vault modeling sense, the metadata classifies the object heuristically as a hub: it holds the durable business key of each accounting book and serves as the reference point from which numerous dependent transactions and subledger records radiate.

Key Information Stored

The table is defined with 69 columns. The most operationally significant are listed below.

• SET_OF_BOOKS_ID (NUMBER, 15) — Surrogate primary key (GL_SETS_OF_BOOKS_PK) and the accounting books defining column referenced throughout the EBS data model.
• NAME (VARCHAR2, 30) — The accounting books name; the column enforced by the unique index GL_SETS_OF_BOOKS_U1.
• SHORT_NAME (VARCHAR2, 20) — Abbreviated identifier for the books, used in reports and display.
• CHART_OF_ACCOUNTS_ID (NUMBER, 15) — Key flexfield structure defining column that ties the books to their account structure.
• CURRENCY_CODE (VARCHAR2, 15) — Functional currency of the books, referencing FND_CURRENCIES.
• PERIOD_SET_NAME (VARCHAR2, 15) — The accounting calendar name governing the periods.
• ACCOUNTED_PERIOD_TYPE (VARCHAR2, 15) — The accounting period type (for example, Month) applied to the calendar.
• SUSPENSE_ALLOWED_FLAG and ALLOW_INTERCOMPANY_POST_FLAG — Control whether suspense posting and intercompany posting are permitted.
• ENABLE_BUDGETARY_CONTROL_FLAG, REQUIRE_BUDGET_JOURNALS_FLAG, and ENABLE_JE_APPROVAL_FLAG — Flags governing budgetary control, journal requirements, and journal approval within the books.
• RET_EARN_CODE_COMBINATION_ID, NET_INCOME_CODE_COMBINATION_ID, CUM_TRANS_CODE_COMBINATION_ID, and ROUNDING_CODE_COMBINATION_ID — Reserved account assignments used by closing, income statement, cumulative translation, and rounding processes, each referencing GL_CODE_COMBINATIONS.
• MRC_SOB_TYPE_CODE — Indicates the Multiple Reporting Currencies role of the books (Parent, Reporting, or None).
• LATEST_OPENED_PERIOD_NAME and FUTURE_ENTERABLE_PERIODS_LIMIT — Track the open period and the limits for forward-dated entry.

The surrogate primary key is SET_OF_BOOKS_ID. The unique indexes GL_SETS_OF_BOOKS_U1 (NAME) and GL_SETS_OF_BOOKS_U2 (SET_OF_BOOKS_ID) both function as business-key candidates, so all queries may rely on either identifier being unique.

Common Use Cases and Queries

The table is queried in virtually every GL-related data extraction, since it resolves the set of books ID into a human-readable accounting context. Typical joins link subledger transactions to their accounting books to report currency, calendar, and chart of accounts.

• Resolving a books name to its ID, chart of accounts, and calendar for setup validation or migration scripts.
• Reporting open periods across multiple books to support period-close status dashboards.
• Identifying reporting books in MRC environments by filtering on MRC_SOB_TYPE_CODE.
• Confirming reserved account assignments (retained earnings, net income) for one or more books.

A common pattern resolves transaction-level records to their books context:

• SELECT sob.set_of_books_id, sob.name, sob.currency_code, sob.period_set_name FROM gl_sets_of_books_11i sob WHERE sob.set_of_books_id = :sob_id;
• SELECT h.set_of_books_id, sob.name, COUNT(*) FROM gl_je_batches h JOIN gl_sets_of_books_11i sob ON sob.set_of_books_id = h.set_of_books_id_11i GROUP BY h.set_of_books_id, sob.name;

Because the table is flagged as Oracle internal use only, reporting should read from it rather than write, and any modification should proceed through the supported Accounting Setup Manager or the relevant GL APIs.

Related Objects

The table sits at the center of a dense dependency network. The most significant related objects include:

• GL_JE_BATCHES — Journal entry batches reference the books through SET_OF_BOOKS_ID_11I, joining back to SET_OF_BOOKS_ID.
• GL_BALANCES and GL_BALANCES_DELTA — Store account balances keyed by LEDGER_ID, which resolves to SET_OF_BOOKS_ID.
• GL_CODE_COMBINATIONS — Referenced by the reserved account columns (RET_EARN, NET_INCOME, CUM_TRANS, ROUNDING, RES_ENCUMB).
• FND_CURRENCIES — Referenced through CURRENCY_CODE.
• GL_MC_BOOK_ASSIGNMENTS_11I and GL_MC_CONVERSION_RULES_11I — Define MRC relationships through PRIMARY_SET_OF_BOOKS_ID and REPORTING_SET_OF_BOOKS_ID.
• AP_SYSTEM_PARAMETERS_ALL and FINANCIALS_SYSTEM_PARAMS_ALL — Subledger system parameters reference the books through SET_OF_BOOKS_ID.
• FA_BOOK_CONTROLS — Fixed Assets book controls reference the books through SET_OF_BOOKS_ID.

These relationships confirm the table's role as a hub: it is referenced by a broad array of subledger and GL tables, while it in turn references only a small set of configuration tables such as GL_CODE_COMBINATIONS, GL_DAILY_CONVERSION_TYPES, and FND_CURRENCIES.