Search Results get_reporting_set_of_books_id

Overview

GL_MC_INFO is a multi-currency and multiple reporting currency (MRC) information package within the Oracle E-Business Suite General Ledger module. Its principal responsibility is to expose metadata about ledgers, sets of books, legal entities, and balancing segment values to other PL/SQL constructs in the EBS application stack without requiring each caller to re-query the underlying configuration tables. The package declares an extensive set of PL/SQL collection types and record structures — including r_sob_rec, r_sob_rec_col, r_sob_list, and r_ael_sob_info — that allow bulk retrieval of set of books and ledger attributes in a single database round trip.

The package carries the AUTHID CURRENT_USER directive, meaning its SQL statements execute with the privileges of the invoking user rather than the definer (APPS). This is significant because GL_MC_INFO is invoked from a wide variety of contexts, including concurrent programs and forms, where the invoking session's security profile and organization context must be respected. The inclusion of procedures such as SET_ORG_ID and SET_LEDGER demonstrates that the package maintains session-level context that drives the behavior of its subsequent retrieval functions.

Key Procedures and Functions

The 39 documented procedures and functions fall into several functional groupings:

Ledger and set of books attribute retrieval: GET_LEDGER_CURRENCY, GET_SOB_TYPE, GET_LEDGER_CATEGORY, GET_ALC_LEDGER_TYPE, and GET_SOURCE_LEDGER_ID return individual scalar attributes of a ledger or set of books.
Primary and reporting ledger identification: GET_PRIMARY_SET_OF_BOOKS_ID, GET_PRIMARY_LEDGER_ID, GET_ALC_LEDGER_ID, GET_REPORTING_SET_OF_BOOKS_ID, and GET_ALC_ASSOCIATED_LEDGERS resolve the relationships between primary ledgers, reporting ledgers, and their associated ledgers under the Accounting Ledger Configuration (ALC) model.
Legal entity and balancing segment value queries: GET_LEGAL_ENTITIES, GET_BAL_SEG_VALUES, GET_LEG_LEDGERS, and INIT_LEDGER_LE_BSV_GT populate and query the global temporary table GL_LEDGER_LE_BSV_GT with legal entity and balancing segment value associations.
Environment and context settings: SET_LEDGER, SET_ORG_ID, and SET_RSOB establish the current ledger, operating unit, and reporting set of books context for the session.
Feature availability checks: MRC_INSTALLED, MRC_ENABLED, and ALC_ENABLED return boolean-style indicators reflecting whether Multiple Reporting Currencies or Accounting Ledger Configuration functionality is installed and enabled. The ALC_ENABLED function is the specific routine that callers use to determine whether the instance operates under the post-11i ledger architecture.

Tables Accessed

GL_MC_INFO reads from GL_LEDGERS, GL_LEDGER_CONFIG_DETAILS, and GL_LEDGER_RELATIONSHIPS to resolve ledger identity, configuration, and inter-ledger relationships. GL_LEDGER_NORM_SEG_VALS and GL_LEDGER_BSV_GT support balancing segment value resolution, while GL_LEDGER_LE_BSV_GT and XLE_ENTITY_PROFILES supply legal entity information. FND_CURRENCIES, FND_PRODUCT_GROUPS, FND_FLEX_VALUE_SETS, and FND_FLEX_VALIDATION_TABLES provide currency and key flexfield metadata. FA_MC_BOOK_CONTROLS is referenced for multi-currency asset book configuration. DBMS_APPLICATION_INFO, DBMS_SQL, and DUAL are used for session context and dynamic SQL support.

Usage Notes

GL_MC_INFO is a foundational utility invoked by approximately 31 other packages across the EBS schema. It is not typically called directly by end users but rather by General Ledger forms, concurrent programs, and application APIs that require ledger or reporting currency metadata. Custom code should invoke the setter routines to establish context before calling any retrieval functions, and should always test ALC_ENABLED or MRC_ENABLED before assuming the presence of reporting ledger or MRC structures. Because the package uses AUTHID CURRENT_USER, callers must possess appropriate privileges on the underlying tables for the queries to succeed.