Search Results gmf_gl_get_sob_id

Overview

GMF_GL_GET_SOB_ID is an Oracle EBS PL/SQL package owned by the APPS schema and classified under the ETRM taxonomy as an "OTHER" API. It belongs to the Process Manufacturing (GMF) family of database objects and is designed to resolve a General Ledger Set of Books identifier from a supplied Set of Books name and a date range. In Oracle EBS 12.1.1 the concept of the Set of Books (SOB) remains the accounting entity for General Ledger; in 12.2.2 the same underlying data model persists through the GL_SETS_OF_BOOKS table even though the user-facing terminology shifts to "Ledger" and "Legal Entity." The package therefore supports legacy Process Manufacturing code paths that still operate against SOB identifiers and must translate the internal name ("sob name") into the numeric identifier ("sob id") used throughout the GL schema. The header comment shows the package body was delivered in late 2002 (revision 115.1), making it a long-standing utility retained for backward compatibility.

Key Procedures and Functions

• PROC_GL_GET_SOB_ID — The single documented procedure in the package. It is responsible for deriving the numeric Set of Books ID that corresponds to a given SOB name and a specified effective date window. The procedure accepts an in/out date range, an in/out Set of Books name, an output SOB ID, a row_to_fetch hint, and an output error status. The in/out NOCOPY semantics on the date and name parameters indicate the routine may normalize or echo back the values it evaluated, while the error_status output lets callers detect lookup failures without relying on unhandled exceptions. No further public procedures or functions are exposed by the package specification.

Tables Accessed

The provided ETRM metadata does not enumerate any tables referenced through APPS synonyms. Functionally, a Set of Books ID lookup routine of this nature resolves the identifier from the General Ledger Set of Books definition, and the effective date parameters align with the start/end date columns maintained on that entity. Because the documented metadata lists no explicit tables, the object should be treated as a lightweight lookup utility whose data access is limited to the GL Set of Books definition. Customizations should not assume any writes occur; the procedure's parameter signature and error_status output are consistent with a read-only resolution service.

Usage Notes

GMF_GL_GET_SOB_ID is referenced by one other package, indicating it is a subordinate utility invoked during higher-level Process Manufacturing or GL integration processing rather than being called directly from a form or concurrent program. Typical invocation patterns include:

• Internal calls from Process Manufacturing costing, accounting, or period-close packages that need to convert a stored SOB name into the numeric ID required by GL APIs.
• Custom extensions or conversions that must reconcile historical SOB data when migrating from 12.1.1 to 12.2.2, where ledger identifiers may differ from legacy SOB identifiers.
• Troubleshooting scenarios involving "sob curr" (Set of Books currency) lookups, where validating that the correct SOB is being resolved is the first diagnostic step.

The row_to_fetch parameter suggests the caller may request a specific row when multiple Set of Books definitions match the supplied criteria, and error_status must be checked after every call before consuming the returned sob_id. Because the package is compiled AUTHID CURRENT_USER, execution privileges are evaluated against the invoking schema, so grants to the APPS synonyms and appropriate privileges are required. Release-specific behavior should be verified against the 12.1.1 and 12.2.2 instances in use, since the object predates both and is retained primarily for compatibility.