Search Results get_sob_id

Overview

APPS.GL_BIS_REPORTS_PKG is a small, session-scoped PL/SQL server-side package in the Oracle E-Business Suite General Ledger (GL) module. Its name associates it with the GL Business Intelligence System (BIS) reporting layer, which supplies the standard financial reporting and analysis facilities used by General Ledger. Rather than performing any query, calculation, or data manipulation itself, the package acts as a lightweight state holder: it captures the identifier of the currently selected Set of Books (SOB) and makes that value available to other program units within the same database session.

The package body carries the header marker $Header: gluoarpb.pls 120.3 2005/05/05 01:41:29 kvora ship $, indicating a long-lived, shipped Oracle artifact that predates both the 12.1.1 and 12.2.2 releases and has remained materially unchanged. In 12.1.1 the Set of Books model is still the primary accounting context for General Ledger; in 12.2.2 the Ledger and Ledger Set model governs accounting configuration, but the legacy "SOB_ID" naming persists in older GL reporting code. The package is classified in the ETRM metadata as an "OTHER" API, meaning it is not a public, supported integration interface such as an OPEN interface or a documented business API.

Key Procedures and Functions

The ETRM metadata documents two program units in this package body:

• INITIALIZE — A procedure whose documented purpose is to accept a Set of Books identifier and assign it to the package-level variable G_SOB_ID. It is the sole write path into the package's internal state and is intended to be called once at the beginning of a reporting session to establish the accounting context. The identifier supplied to this procedure is what every subsequent call to GET_SOB_ID returns.
• GET_SOB_ID — A function that returns the value previously stored in G_SOB_ID. Its purpose is to provide read access to the session's current Set of Books identifier without requiring the caller to pass that identifier explicitly through a call stack. The body simply returns the package variable; no lookup, validation, or query against any table is performed.

No parameter lists are documented beyond the single input to INITIALIZE and the declared return of GET_SOB_ID, and no other procedures or functions are present in the package body.

Tables Accessed

The ETRM metadata records no tables referenced through APPS synonyms for this package. This is consistent with the source body, which contains only a package variable assignment and a return statement. The package does not read from or write to any General Ledger table such as GL_SETS_OF_BOOKS, GL_LEDGERS, or GL_JE_HEADERS, and it performs no SQL at all. The Set of Books identifier it stores must be obtained elsewhere — typically by a calling form, concurrent program, or report — and then handed to INITIALIZE.

Usage Notes

Because the package maintains state only in a package variable, its values are scoped to a single database session and are not visible across sessions, concurrent requests, or database instances. It is therefore typically invoked by code that already knows which Set of Books is active — for example, a General Ledger BIS reporting program that initializes the package at startup and then calls GET_SOB_ID from downstream routines that need the identifier but are not passed it directly. The documented metadata shows zero other packages referencing it, so its callers are expected to be forms, concurrent programs, or custom extensions rather than other PL/SQL packages.

The package is a legacy construct. Release 12.1.1 and 12.2.2 both retain it for backward compatibility with GL reporting code, and in 12.2.2 the value it carries continues to be used as though it were an accounting context identifier even though the underlying configuration model has moved to ledgers and ledger sets. Custom code extending GL BIS reports should treat this package as an internal helper, populate it through INITIALIZE only when the reporting context is unambiguous, and avoid relying on it as a substitute for querying the current ledger from the supported GL configuration views.