Search Results proc_gl_get_sob_id

Overview

The APPS.GMF_GL_GET_SOB_ID package body provides a lightweight utility for resolving an Oracle General Ledger set of books identifier (SET_OF_BOOKS_ID) from a set of books name and an optional creation-date range. It is part of the Oracle Process Manufacturing (OPM) financials integration layer, where the GMF_ prefix denotes packages belonging to the GMF (Process Manufacturing Financials) schema. Its role is to supply downstream OPM accounting and GL interface routines with a verified SET_OF_BOOKS_ID, which is a mandatory key for posting journal entries, querying balances, and enforcing ledger context within the E-Business Suite. The package body carries the header revision 115.1 dated 2002/11/11, indicating it is a legacy utility carried forward relatively unchanged into EBS 12.1.1 and 12.2.2. It is classified as OTHER in the ETRM repository, meaning it is not a public, supported API but an internal helper invoked by other application code. In 12.2.2 the repository records that it is referenced by one other package, confirming its narrow, dependent usage rather than direct end-user invocation.

Key Procedures and Functions

• PROC_GL_GET_SOB_ID — The single documented procedure in this package. It opens (if not already open) the private cursor cur_gl_get_sob_id, fetches a matching SET_OF_BOOKS_ID into its output parameter, and returns that identifier to the caller. It accepts the start date, end date, and set of books name as IN OUT NOCOPY parameters, returns the set of books identifier and an error status as OUT NOCOPY parameters, and takes a ROW_TO_FETCH control value. The ROW_TO_FETCH argument governs cursor reuse: when it equals 1 the procedure explicitly closes the cursor after the fetch, while other values leave the cursor open for subsequent row retrieval by the calling code. On NO_DATA_FOUND conditions the procedure sets ERROR_STATUS to 100; on any other exception it assigns SQLCODE to ERROR_STATUS. This design allows a caller to iterate over multiple matching sets of books while managing cursor lifetime and error signalling through the single status parameter.

Tables Accessed

• GL_SETS_OF_BOOKS (via APPS synonym) — The sole documented table referenced. The cursor selects SET_OF_BOOKS_ID from this table, filtering rows where NAME matches the supplied SOB_NAME pattern (using a LIKE comparison) and where CREATION_DATE falls between the supplied start and end dates, with NVL defaults substituting CREATION_DATE when either bound is null. The table is read-only in this package; no DML is performed.

Usage Notes

GMF_GL_GET_SOB_ID is an internal utility rather than a formally supported public API, so it is typically invoked from other OPM packages, concurrent programs, or custom extensions that must derive a ledger identifier before calling GL posting logic. Because the cursor filters on NAME LIKE and an optional CREATION_DATE range, callers requiring a unique ledger should pass a fully qualified or wildcard-free name to avoid ambiguous multi-row results; the ROW_TO_FETCH convention lets a caller step through such matches one row at a time. The NOCOPY parameter modes indicate performance-oriented coding for repeated invocation. In 12.1.1 and 12.2.2 environments, where the accounting setup may retain multiple sets of books, this package remains functional, but customizations should prefer the current GL ledger APIs (for example the FND_FLEX/GL ledger query interfaces) for new development, treating GMF_GL_GET_SOB_ID as a legacy dependency to be referenced only where the existing OPM code path already relies upon it.