Search Results gl_sets_of_books_v




Overview
Explore in AI Chat

Overview

GL_SETS_OF_BOOKS_V is a backward-compatibility view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It exposes the attributes of a General Ledger ledger (formerly termed a "set of books") by projecting columns from the GL_LEDGERS table and joining to a small set of supporting configuration tables. The view preserves the pre-R12 SET_OF_BOOKS API surface so that existing reports, interfaces, and customizations continue to function after the multi-organization architecture replaced sets of books with the ledger concept.

Because the view is a read-only projection, it plays no role in transaction processing. Its value lies in reporting and integration: subledger reconciliation reports, custom concurrent programs, and third-party extracts that reference SOB_ID, SUSPENSE_CCID, or CURRENCY_CODE can query GL_SETS_OF_BOOKS_V without modification. In R12 the LEDGER_ID column is aliased to SET_OF_BOOKS_ID, reinforcing this compatibility role.

Underlying Base Objects

The view text selects primarily from GL_LEDGERS (synonym LGR), the single source of truth for ledger definitions. It joins the following documented base objects:

All referenced objects are synonyms resolving to their APPLSYS base tables. The join to GL_SUSPENSE_ACCOUNTS is the key relationship for the common search term suspense_ccid: it maps a ledger to the code combination used to hold unbalanced or suspense journal lines.

Key Columns

Common Use Cases and Queries

The predominant use is retrieving ledger configuration, especially the suspense account, for reconciliation and validation logic. A typical query resolving the suspense code combination is:

  • SELECT sob.set_of_books_id, sob.name, sob.suspense_ccid, gcc.concatenated_segments suspense_account FROM gl_sets_of_books_v sob, gl_code_combinations_kfv gcc WHERE sob.suspense_ccid = gcc.code_combination_id;

Other recurring scenarios include validating that suspense posting is active before loading journals, extracting all ledgers for a multi-ledger consolidations report, and mapping a legacy SOB_ID to its currency and chart of accounts during migration. Because the object is a view without DML capability, all access is read-only. Reports should join GL_SETS_OF_BOOKS_V to GL_CODE_COMBINATIONS_KFV or FND_FLEX_VALUES_VL to translate CCID values into human-readable account strings, and should filter by SET_OF_BOOKS_ID when a specific ledger is targeted.