Search Results gl_ledgers_s

Overview

GL_LEDGERS_PKG is the core PL/SQL package in Oracle General Ledger responsible for the definition, configuration, and maintenance of ledgers within the Oracle E-Business Suite environment. Ledgers represent the fundamental accounting books used by an enterprise, combining a chart of accounts, calendar, currency, and accounting conventions. The package body serves as the back-end implementation supporting the Ledger Setup and Ledger Configuration forms, providing the logic required to create, validate, update, and query ledger definitions. It is classified as an "OTHER" API within the ETRM 12.2.2 repository and is owned by the APPS schema. The package consists of 39 documented procedures and functions, spanning ledger creation, uniqueness verification, set-of-books-to-ledger migration, and configuration completion logic.

Key Procedures and Functions

The package exposes a broad set of row-level and configuration-level operations. The primary ledger maintenance routines include INSERT_ROW, UPDATE_ROW, SELECT_ROW, SELECT_COLUMNS, and LOCK_ROW, which collectively implement standard data-block behavior for the Ledger form. Validation logic is provided by CHECK_UNIQUE_NAME, CHECK_UNIQUE_SHORT_NAME, and CHECK_AVG_TRANSLATION, the latter verifying average translation eligibility.

• COMPLETE_CONFIG — manages completion of a ledger configuration, iterating over ledger configuration details and linking ledgers, operating units, and access sets.
• GET_UNIQUE_ID — returns a unique identifier used during ledger record creation.
• IS_COA_FROZEN — determines whether the chart of accounts structure associated with a ledger is frozen, preventing structural changes.
• GET_BAL_MGT_SEG_INFO — retrieves balance management segment information used to control account balancing behavior.
• UPDATE_GL_SYSTEM_USAGES — maintains GL system usage flags recording where the ledger is referenced across subledgers.
• INSERT_GL_NET_INCOME_ACCOUNTS — establishes net income accounts linked to the ledger.
• LED_UPDATE_OTHER_TABLES — propagates ledger changes to dependent tables.
• ENABLE_MANUAL_JE_APPROVAL — toggles manual journal entry approval functionality for the ledger.
• INSERT_SET, LOCK_SET, UPDATE_SET — manage access or criteria sets associated with the ledger.
• MAINTAIN_DEF_LEDGER_ASSIGN — maintains the default ledger assignment, including primary ledger designation.

Tables Accessed

The package interacts primarily with GL_LEDGERS and GL_LEDGERS_S, which store the ledger definition and its translated/security attributes. Configuration logic reads GL_LEDGER_CONFIGURATIONS and GL_LEDGER_CONFIG_DETAILS to drive the setup wizard. Chart of accounts integrity is validated against FND_ID_FLEX_STRUCTURES, FND_ID_FLEX_SEGMENTS, and FND_SEGMENT_ATTRIBUTE_VALUES, while FND_FLEX_VALIDATION_TABLES supports value-set validation. Access control uses GL_ACCESS_SETS and GL_LEDGER_NORM_SEG_VALS. Supporting references include GL_CODE_COMBINATIONS, GL_DATE_PERIOD_MAP, GL_JE_SOURCES, GL_AUTOREV_CRITERIA_SETS, and GL_LEDGER_RELATIONSHIPS for subledger and relationship maintenance.

Usage Notes

GL_LEDGERS_PKG is invoked predominantly through the Oracle General Ledger Ledger Setup and Accounting Setup Manager forms, where it backs the ledger entry and configuration pages. It is referenced by two other packages, indicating it forms a foundational dependency for higher-level GL routines. Custom or extension code should generally avoid calling these internal routines directly; supported integrations should use the public GL ledger and accounting setup APIs. Administrators encountering issues with the "ret_earn" (retained earnings) search term in this context should note that retained earnings account assignment is typically handled through ledger configuration steps linked to GL_LEDGER_CONFIG_DETAILS and the net income account routines documented above.