Search Results fem_budgets_pkg




Overview
Explore in AI Chat

Overview

APPS.FEM_BUDGETS_PKG is a PL/SQL package in the Oracle EBS Applications (APPS) schema that supports the Enterprise Territory Management (ETRM) / FEM (Forecasting and Essbase Management) family of objects. It is classified as an "OTHER" API package, meaning it is a supporting data-maintenance package rather than a formal public business API. The package manages the persistence layer for budget definitions stored in the FEM_BUDGETS base and translation tables. In Oracle EBS 12.1.1 and 12.2.2, this package is the low-level accessor used by the budget Dataloader, Interface Loader, and Uploader programs (FEM_BUDGETS_DL, FEM_BUDGETS_IL, FEM_BUDGETS_UL) to insert, update, lock, delete, and translate budget records. It is registered as VALID in the ETRM repository and is part of the standard APPS object inventory.

Key Procedures and Functions

The documented package exposes six procedures, all of which follow the standard Oracle EBS table-handler pattern:

  • INSERT_ROW — Creates a new budget definition row in the base table, populating the required columns and WHO columns for the new record.
  • LOCK_ROW — Acquires a row-level lock on an existing budget record to prevent concurrent modification during an update or delete operation.
  • UPDATE_ROW — Modifies the attributes of an existing budget definition, including audit columns, based on the change payload passed by the calling program.
  • DELETE_ROW — Removes a budget definition from the base table and, where applicable, its associated translation rows.
  • ADD_LANGUAGE — Inserts a new translation row in FEM_BUDGETS_TL for a language that does not yet have a translation for the given budget, typically executed when a new language is enabled in the instance.
  • TRANSLATE_ROW — Updates or inserts a translated description/name value in the translation table for a specified language, supporting multilingual budget definitions.

No parameter lists are documented in the ETRM metadata; callers must therefore reference the package specification in the APPS schema for exact signatures.

Tables Accessed

The package reads from and writes to the following APPS synonyms:

  • FEM_BUDGETS_B — The base table holding budget definition records. INSERT_ROW, UPDATE_ROW, DELETE_ROW, and LOCK_ROW all operate against this table.
  • FEM_BUDGETS_TL — The translation table storing language-specific names and descriptions. ADD_LANGUAGE and TRANSLATE_ROW write here; the base table joins to it for display.
  • FND_LANGUAGES — The Oracle EBS language repository, used to determine which languages are installed and active so that translation rows are only created for valid languages.

The package also references the SYS.STANDARD package, which is the PL/SQL built-in package required by every compiled unit.

Usage Notes

FEM_BUDGETS_PKG is not intended for direct invocation by end users or casual custom code. It is referenced by the Dataloader (FEM_BUDGETS_DL), Interface Loader (FEM_BUDGETS_IL), and Uploader (FEM_BUDGETS_UL) programs, as well as by FEM_DIMENSION_UTIL_PKG and FEM_DIM_UTILS_PVT, which together drive the ETRM budget dimension and territory configuration flows. In practice the package is invoked by these dependent programs during concurrent program execution, or by Oracle EBS Forms built on the FEM_BUDGETS tables. Customizations should call the higher-level Dataloader/Uploader APIs rather than the row handlers directly, because the row-level procedures bypass validation and security logic implemented in the enclosing programs. Any change to the base or translation tables should be made through the documented procedures to preserve WHO column maintenance and translation consistency. Because the ETRM metadata documents no parameters and no exceptions, developers extending this package must inspect the live package specification in the target release (12.1.1 or 12.2.2) before coding against it.