Results for “gl_sets_of_books”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

GL_SETS_OF_BOOKS is a compatibility view in the APPS schema that exposes the attributes of Oracle General Ledger ledgers. In Release 12, the accounting entity previously known as a "set of books" was re-architected as a "ledger," and the underlying data was consolidated into the GL_LEDGERS table. GL_SETS_OF_BOOKS preserves the pre-R12 naming convention and interface so that legacy reports, concurrent programs, forms, and custom integrations continue to resolve ledger attributes without modification. The view is owned by APPS, holds VALID status, and belongs to the GL - General Ledger product family.

The view returns one row per ledger, offering a denormalized, read-only projection of ledger definition and control settings. It is widely referenced in Oracle EBS reporting and integration layers, particularly in older code paths and third-party tools that were written against the 11i data model. The column SUSPENSE_ALLOWED_FLAG, which prompted the user's search, is surfaced here as a direct mapping from the ledger definition and controls whether unbalanced journal entries may be posted to a suspense account.

Underlying Base Objects

The documented base object for this view is GL_LEDGERS, accessed through a synonym. All columns exposed by GL_SETS_OF_BOOKS are drawn from GL_LEDGERS using column aliases that retain the original set-of-books column names. For example, LEDGER_ID is aliased to SET_OF_BOOKS_ID, and CONSOLIDATION_LEDGER_FLAG is aliased to CONSOLIDATION_SOB_FLAG. Two columns are derived rather than directly mapped: MRC_SOB_TYPE_CODE is produced by a DECODE on ALC_LEDGER_TYPE_CODE, and ALLOW_POSTING_WARNING_FLAG is hard-coded to 'N'. A third, EARLIEST_UNTRANS_PERIOD_NAME, is returned as NULL. This structure confirms the view is a thin translation layer rather than an independent data source.

Key Columns

• SET_OF_BOOKS_ID — Aliased from LEDGER_ID; the unique ledger identifier and primary join key throughout GL.
• NAME / SHORT_NAME — The ledger's descriptive and abbreviated names.
• CHART_OF_ACCOUNTS_ID — The chart of accounts assigned to the ledger.
• CURRENCY_CODE — The ledger's functional (base) currency.
• PERIOD_SET_NAME / ACCOUNTED_PERIOD_TYPE — The accounting calendar and period type governing the ledger.
• SUSPENSE_ALLOWED_FLAG — Indicates whether the ledger permits posting to a suspense account when an entry does not balance by balancing segment.
• ALLOW_INTERCOMPANY_POST_FLAG — Controls whether intercompany journal entries may be posted.
• TRACK_ROUNDING_IMBALANCE_FLAG — Governs tracking of rounding imbalances.
• ENABLE_AVERAGE_BALANCES_FLAG / ENABLE_BUDGETARY_CONTROL_FLAG / REQUIRE_BUDGET_JOURNALS_FLAG — Ledger control settings for average balances and budgetary control.
• ENABLE_JE_APPROVAL_FLAG — Enables journal approval workflow for the ledger.
• ENABLE_AUTOMATIC_TAX_FLAG — Enables automatic tax calculation.
• CONSOLIDATION_SOB_FLAG, TRANSLATE_EOD_FLAG, TRANSLATE_QATD_FLAG, TRANSLATE_YATD_FLAG — Consolidation and translation behavior flags.
• FUTURE_ENTERABLE_PERIODS_LIMIT, LATEST_OPENED_PERIOD_NAME, LATEST_ENCUMBRANCE_YEAR — Period and encumbrance control attributes.
• RET_EARN_CODE_COMBINATION_ID, CUM_TRANS_CODE_COMBINATION_ID, RES_ENCUMB_CODE_COMBINATION_ID, NET_INCOME_CODE_COMBINATION_ID, ROUNDING_CODE_COMBINATION_ID — Reserved account assignments used by GL processes.

Common Use Cases and Queries

Because it retains legacy column names, GL_SETS_OF_BOOKS is most commonly used to retrofit 11i-era SQL into an R12 environment. A typical query retrieves ledger identifiers and control flags for a specific ledger:

• SELECT set_of_books_id, name, currency_code, suspense_allowed_flag FROM gl_sets_of_books WHERE set_of_books_id = :ledger_id;
• SELECT set_of_books_id, short_name, period_set_name, account__ed_period_type FROM gl_sets_of_books ORDER BY name;
• Joining to GL_JE_BATCHES or GL_JE_HEADERS on SET_OF_BOOKS_ID to attribute journal activity to a ledger.
• Auditing suspense and intercompany posting settings across all defined ledgers for compliance review.

For new development, Oracle recommends referencing GL_LEDGERS directly; GL_SETS_OF_BOOKS should be treated as a backward-compatibility interface.