Search Results fem_acct_grps_il

Overview

FEM_ACCT_GRPS_PKG is the primary PL/SQL package in the Oracle EBS Applications (APPS) schema responsible for maintaining accounting group definitions used by the Enterprise Tax, Regulatory, and Reporting Management (ETRM) modules. Accounting groups allow organizations to logically aggregate accounting entities, ledgers, or legal entities for consolidation, balancing, and reporting purposes within the Financials and ETRM architecture. This package provides the canonical data manipulation interface for the two core base tables that store accounting group definitions: the base table FEM_ACCT_GRPS_B and its translatable child table FEM_ACCT_GRPS_TL. In Oracle EBS 12.1.1 and 12.2.2, the package is classified as API type OTHER under the ETRM product family, indicating it is a data-maintenance utility rather than a seeded public business API. It is the recommended low-level entry point for inserting, updating, locking, deleting, and translating accounting group records while preserving the integrity between the base and translated tables.

Key Procedures and Functions

The documented interface of FEM_ACCT_GRPS_PKG consists of six procedures that together implement the standard multi-language table maintenance pattern used throughout EBS:

• INSERT_ROW — Creates a new accounting group record, writing the primary definition into the base table and the appropriate language row into the translation table.
• LOCK_ROW — Acquires an exclusive row-level lock on an existing accounting group definition, ensuring serialized updates by concurrent sessions.
• UPDATE_ROW — Modifies an existing accounting group definition and propagates attribute changes to the translatable columns where applicable.
• DELETE_ROW — Removes an accounting group definition, deleting the corresponding records from the base and translation tables.
• ADD_LANGUAGE — Inserts a new language row into the translation table for an existing accounting group, enabling the definition to be surfaced in an additional installed language.
• TRANSLATE_ROW — Updates or maintains the translated descriptive fields for a specific accounting group in a given language.

Tables Accessed

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

• FEM_ACCT_GRPS_B — The base table holding language-independent accounting group columns. All insert, update, lock, and delete operations act on this table.
• FEM_ACCT_GRPS_TL — The translation table storing language-dependent description fields. INSERT_ROW, DELETE_ROW, ADD_LANGUAGE, and TRANSLATE_ROW maintain rows here.
• FND_LANGUAGES — The Oracle Applications installed-languages view, consulted to validate language codes during ADD_LANGUAGE and TRANSLATE_ROW processing.

Usage Notes

FEM_ACCT_GRPS_PKG is invoked indirectly rather than through direct user interaction. Its documented callers are the three adjoining ETRM packages FEM_ACCT_GRPS_DL, FEM_ACCT_GRPS_IL, and FEM_ACCT_GRPS_UL, which serve as the delete, insert, and update layer wrappers typical of EBS generated table-handler patterns. These wrappers are in turn called by the ETRM accounting group maintenance forms and by any concurrent programs that seed or migrate accounting group setups. Developers extending ETRM should call the DL/IL/UL wrappers or the package procedures rather than issuing direct DML against FEM_ACCT_GRPS_B or FEM_ACCT_GRPS_TL, since the package enforces the required base/translation synchronization, WHO column population, and row locking semantics. Because the package is classified as OTHER and is not a published public API, customizations should be validated against the specific EBS patch level (12.1.1 or 12.2.2) in use. Direct dependencies are limited to the SYS STANDARD package, and the object status is VALID in the documented environment.