Search Results get_bal_mgt_seg_info

Overview

GL_LEDGERS_PKG is a core Oracle E-Business Suite PL/SQL package owned by the APPS schema and stored in the General Ledger module. It encapsulates the business logic that supports the definition, configuration, validation, and ongoing maintenance of accounting ledgers. In Oracle EBS Release 12, the ledger replaces the earlier concept of a set of books and represents the central accounting entity against which journals are entered, balances are maintained, and financial reports are generated. This package provides the programmatic foundation that allows forms, concurrent programs, and other packages to create, modify, and validate ledger definitions in a controlled and consistent manner.

The package is classified as an OTHER API, meaning it is not a fully documented public interface but is nonetheless heavily relied upon by standard EBS components. It is validated in the APPS schema and is referenced by other ledger-related packages such as GL_JE_HEADERS_PKG and GL_WF_JE_APPROVAL_PKG, confirming its role as a shared utility layer for ledger processing.

Key Procedures and Functions

The package exposes 39 documented procedures and functions, covering the full lifecycle of ledger maintenance:

• INSERT_ROW, UPDATE_ROW, SELECT_ROW, LOCK_ROW, SELECT_COLUMNS — standard row-level data manipulation and concurrency control routines for ledger records.
• COMPLETE_CONFIG — finalizes the configuration of a ledger once its supporting setup is complete.
• CHECK_UNIQUE_NAME, CHECK_UNIQUE_SHORT_NAME, GET_UNIQUE_ID — enforce uniqueness and generate surrogate keys for ledger and related entities.
• IS_COA_FROZEN, GET_BAL_MGT_SEG_INFO — inspect chart of accounts state and retrieve balancing segment information used by ledger configuration.
• UPDATE_GL_SYSTEM_USAGES, INSERT_GL_NET_INCOME_ACCOUNTS, LED_UPDATE_OTHER_TABLES — maintain related accounting setup records that must remain synchronized with the ledger.
• CHECK_AVG_TRANSLATION, ENABLE_MANUAL_JE_APPROVAL — validate translation settings and control journal approval behavior.
• INSERT_SET, LOCK_SET, UPDATE_SET — manage ledger access/configuration sets.
• MAINTAIN_DEF_LEDGER_ASSIGN — maintain default ledger assignments.

Tables Accessed

The package reads and writes several foundational GL and FND tables through APPS synonyms. GL_LEDGERS and GL_LEDGERS_S hold the primary ledger definition and its translated (TL) columns. GL_LEDGER_CONFIGURATIONS and GL_LEDGER_CONFIG_DETAILS store the setup parameters that define how a ledger operates. GL_LEDGER_NORM_SEG_VALS and GL_LEDGER_RELATIONSHIPS support segment-level and inter-ledger relationship data. GL_CODE_COMBINATIONS and GL_AUTOREV_CRITERIA_SETS underpin account validation and automatic reversal rules. FND_ID_FLEX_STRUCTURES, FND_ID_FLEX_SEGMENTS, FND_FLEX_VALIDATION_TABLES, and FND_SEGMENT_ATTRIBUTE_VALUES provide the key flexfield structure and validation metadata. GL_ACCESS_SETS, GL_DATE_PERIOD_MAP, and GL_JE_SOURCES are also referenced for access control, period mapping, and journal source integration.

Usage Notes

GL_LEDGERS_PKG is typically invoked indirectly. It is called by the Accounting Setup Manager and ledger definition forms during interactive ledger creation and update, and referenced by GL_JE_HEADERS_PKG and GL_WF_JE_APPROVAL_PKG during journal entry and approval workflows. Custom code should treat it as an internal supporting package rather than a supported public API, and should prefer standard ledger forms or the Accounting Setup Manager for configuration changes to avoid bypassing validation logic.