Search Results pn_system_setup_options

Overview

GL_SETS_OF_BOOKS_11I is the General Ledger set of books definition table in the GL schema. It is the central configuration object that defines the accounting identity of a financial reporting entity: the chart of accounts, the functional currency, the accounting calendar, the period type, and the retained earnings and translation accounts used to close and convert the books. In Oracle EBS 12.1.1 it is the operative set of books table; in 12.2.2 it is retained primarily as a compatibility and upgrade view/table corresponding to the Ledger concept introduced by the Multi-Organization Access Control and subledger accounting architecture.

Because almost every financial subledger record carries a SET_OF_BOOKS_ID, this table behaves as a reference and master-data object. Under a heuristic Data Vault classification mined from its foreign key structure, GL_SETS_OF_BOOKS_11I is best modeled as a hub — a business-key-bearing entity surrounded by many dependent references — while its descriptive configuration attributes (currency, calendar, flags, account assignments) would naturally live in an attached satellite.

Key Information Stored

The table documents 69 columns. The most significant are:

• SET_OF_BOOKS_ID — surrogate primary key (GL_SETS_OF_BOOKS_PK) referenced throughout the EBS schema.
• NAME — business-key candidate, enforced by unique index GL_SETS_OF_BOOKS_U1; the user-facing set of books name.
• SHORT_NAME and DESCRIPTION — identification and reporting labels.
• CHART_OF_ACCOUNTS_ID — the chart of accounts structure applied to the books.
• CURRENCY_CODE — functional currency, foreign key to FND_CURRENCIES.
• PERIOD_SET_NAME and ACCOUNTED_PERIOD_TYPE — the accounting calendar and period type used for posting.
• TRANSACTION_CALENDAR_ID — foreign key to GL_TRANSACTION_CALENDAR.
• RET_EARN_CODE_COMBINATION_ID and CUM_TRANS_CODE_COMBINATION_ID — retained earnings and cumulative translation accounts.
• NET_INCOME_CODE_COMBINATION_ID, ROUNDING_CODE_COMBINATION_ID, and RES_ENCUMB_CODE_COMBINATION_ID — closing, rounding imbalance, and encumbrance suspense accounts.
• DAILY_TRANSLATION_RATE_TYPE — foreign key to GL_DAILY_CONVERSION_TYPES.
• LATEST_OPENED_PERIOD_NAME and FUTURE_ENTERABLE_PERIODS_LIMIT — period control state.
• TRACK_ENTERED_FUNC_CURR_FLAG, ENABLE_SECONDARY_TRACK_FLAG, and ENABLE_REVAL_SS_TRACK_FLAG — currency tracking options.

A second unique index, GL_SETS_OF_BOOKS_U2, enforces uniqueness on SET_OF_BOOKS_ID alongside the primary key definition.

Common Use Cases and Queries

Typical usage includes resolving the functional currency, calendar, and account assignments for a given set of books, and driving period-status and reporting queries. A common join pattern retrieves book identity for subledger records:

• SELECT sob.name, sob.currency_code, sob.chart_of_accounts_id FROM gl_sets_of_books_11i sob WHERE sob.set_of_books_id = :p_sob_id;
• Joining subledger transactions such as AP_INVOICES_ALL or RA_CUSTOMER_TRX_ALL to the set of books on SET_OF_BOOKS_ID for reporting by legal entity.
• Resolving account combinations via GL_CODE_COMBINATIONS using RET_EARN_CODE_COMBINATION_ID or NET_INCOME_CODE_COMBINATION_ID for closing and statement generation.
• Joining to FND_CURRENCIES and GL_TRANSACTION_CALENDAR to obtain currency precision and calendar detail.

Given the reported search term fv_refunds_voids_all, a frequent scenario is identifying the set of books attributed to refund and void records in the FV (Federal Financials) module, using FV_REFUNDS_VOIDS_ALL.SET_OF_BOOKS_ID joined to GL_SETS_OF_BOOKS_11I for reporting.

Related Objects

The table is referenced by a large number of subledger and GL objects. The most significant include:

• FV_REFUNDS_VOIDS_ALL — joins on SET_OF_BOOKS_ID; refund and void entries in Federal Financials.
• AP_INVOICES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL — payables transactions and distributions keyed by SET_OF_BOOKS_ID.
• AR_CASH_RECEIPTS_ALL and RA_CUSTOMER_TRX_ALL — receivables transactions and receipts.
• GL_JE_BATCHES — links via SET_OF_BOOKS_ID_11I to journal batches.
• FA_BOOK_CONTROLS — asset book controls keyed by SET_OF_BOOKS_ID.
• FINANCIALS_SYSTEM_PARAMS_ALL — system parameters per set of books.
• GL_CODE_COMBINATIONS, FND_CURRENCIES, and GL_TRANSACTION_CALENDAR — foreign tables this object references for accounts, currency, and calendar.