Search Results allow_posting_warning_flag

Overview

The GL_SETS_OF_BOOKS view is a critical data object within Oracle E-Business Suite (EBS) General Ledger (GL) module. It provides a comprehensive, application-level view of ledger configuration data, historically known as a "Set of Books." In Oracle EBS 12.1 and 12.2, the underlying data model evolved with the introduction of the Accounting Setup Manager, where the primary entity became the LEDGER (GL_LEDGERS table). This view serves as a key compatibility layer, presenting ledger information in the legacy "Set of Books" format to ensure backward compatibility for numerous existing reports, interfaces, and custom code. Its role is to abstract the detailed ledger structure into a standardized interface that other modules and integrations can reliably query.

Key Information Stored

The view exposes fundamental configuration attributes that define an accounting entity's financial structure. Key columns include SET_OF_BOOKS_ID (the ledger's primary key), NAME, and SHORT_NAME for identification. It stores the core accounting flexfield structure via CHART_OF_ACCOUNTS_ID and the functional CURRENCY_CODE. Critical accounting calendar controls are held in PERIOD_SET_NAME and ACCOUNTED_PERIOD_TYPE. The view also includes numerous control flags that govern ledger behavior, such as SUSPENSE_ALLOWED_FLAG, ENABLE_BUDGETARY_CONTROL_FLAG, and ENABLE_JE_APPROVAL_FLAG. Notably, the column ALLOW_POSTING_WARNING_FLAG is hard-coded to 'N' in the view's SELECT statement, indicating this specific posting control is not enabled through this compatibility view in the documented releases. The view also provides foreign keys to important combinations like RET_EARN_CODE_COMBINATION_ID and transaction calendars.

Common Use Cases and Queries

This view is predominantly used for reporting and data extraction where the legacy Set of Books context is required. A common use case is retrieving a list of all ledgers with their core configurations for a data warehouse feed or a custom summary report. For example, a query to list active ledgers with their currency and chart of accounts ID would directly reference this view. Another frequent pattern involves joining this view to transaction tables like GL_JE_HEADERS on SET_OF_BOOKS_ID to enrich journal entry reports with ledger details. Developers also query it to determine specific ledger settings before executing custom posting or validation logic. Given the hard-coded value for ALLOW_POSTING_WARNING_FLAG, queries filtering on this column would consistently return no rows if seeking a 'Y' value, directing developers to the underlying GL_LEDGERS table or other interfaces for that specific functionality.

Related Objects

GL_SETS_OF_BOOKS is intrinsically related to the primary ledger table, GL_LEDGERS, from which it sources its data via the alias LGR in its SELECT statement. It is a foundational object referenced by many other views and tables across EBS to maintain the Set of Books paradigm. Key related objects include:

• GL_JE_HEADERS: Journal entries are stored against a SET_OF_BOOKS_ID, which can be joined to this view.
• GL_BALANCES: Balance records are keyed by LEDGER_ID (SET_OF_BOOKS_ID).
• AP_INVOICES_ALL and RA_CUSTOMER_TRX_ALL: Invoices and transactions in Payables and Receivables often store a SET_OF_BOOKS_ID column to link to this financial context.
• Various product-specific views (e.g., AP_SETS_OF_BOOKS, FA_SETS_OF_BOOKS) which often base their logic on this core GL view.

The view itself does not define foreign key constraints, as it is a derived object, but the SET_OF_BOOKS_ID column corresponds directly to the LEDGER_ID primary key in the GL_LEDGERS base table.