Search Results fem_ledgers_pkg




Overview
Explore in AI Chat

Overview

FEM_LEDGERS_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that provides the foundational data access and maintenance layer for ledger definitions within the Enterprise Performance Foundation (EPF) / Enterprise Tax Reporting and Management (ETRM) schema. Its central responsibility is the management of records stored in the FEM_LEDGERS_B base table and its associated translation table FEM_LEDGERS_TL, which together define the ledgers recognized by the FEM (Financial Enterprise Management) engine. These ledger records establish the accounting book context against which dimension members, balances, and analytical mappings are resolved, making the package a low-level building block rather than a user-facing API. The package is classified as an "OTHER" API in the ETRM 12.1.1 documentation, indicating that it is not part of a formally published public interface but is instead a supporting utility package relied upon by other FEM components.

Key Procedures and Functions

The package exposes six documented units, all of which are conventional table-maintenance procedures rather than complex business logic routines:

  • INSERT_ROW — Creates a new ledger record, inserting the base row into FEM_LEDGERS_B and, where applicable, handling the associated attributes required for a valid ledger definition.
  • LOCK_ROW — Acquires a row-level lock on an existing ledger record prior to modification, ensuring concurrency control during updates or deletes.
  • UPDATE_ROW — Modifies the attributes of an existing ledger record in FEM_LEDGERS_B once the row has been locked.
  • DELETE_ROW — Removes a ledger record from the base table, typically preceded by a LOCK_ROW call.
  • ADD_LANGUAGE — Inserts a new language row into FEM_LEDGERS_TL, creating a translatable instance of a ledger name or description for a supported language.
  • TRANSLATE_ROW — Maintains the translatable text (name and description) of a ledger within FEM_LEDGERS_TL for the requested language.

No parameter lists are documented, and callers should consult the package specification in the database for exact signatures.

Tables Accessed

The package operates against three documented tables, referenced through APPS synonyms:

  • FEM_LEDGERS_B — The base table holding the non-translatable ledger definition, including the ledger identifier and its core attributes. INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW act upon this table.
  • FEM_LEDGERS_TL — The translation table storing language-specific ledger names and descriptions. ADD_LANGUAGE and TRANSLATE_ROW write to this table.
  • FND_LANGUAGES — The Oracle Application Object Library table of installed and active languages, consulted to validate language codes during translation operations.

Usage Notes

Because FEM_LEDGERS_PKG is an internal maintenance package, it is not typically invoked directly by end users. The documented dependency information shows that it is referenced by five other objects, including FEM_DIMENSION_UTIL_PKG, FEM_DIM_UTILS_PVT, FEM_LEDGERS_DL, FEM_LEDGERS_IL, and FEM_LEDGERS_UL. The latter three are the data-load, insert, and update loader components associated with the ledger interface, which are the most likely runtime entry points through which the package's procedures are exercised. In practice, ledger definitions reach FEM_LEDGERS_PKG indirectly through these loader programs, through EPF/ETRM administrative forms that host ledger setup, or through concurrent programs that populate FEM tables from source general ledger data. Custom development that must create or amend ledger records should preferably call the higher-level loader or public FEM APIs rather than FEM_LEDGERS_PKG directly, since bypassing the loaders may skip validation and dependent processing. When direct invocation is unavoidable, callers should observe the standard sequence of LOCK_ROW before UPDATE_ROW or DELETE_ROW to preserve concurrency integrity.