Search Results fem_entities_tl




Overview
Explore in AI Chat

Overview

FEM_ENTITIES_PKG is the Application Programming Interface (API) package that governs the Entities repository within Oracle Enterprise Performance Management (EPM) and the Enterprise Tax, Risk, and Management (ETRM) modules delivered with Oracle E-Business Suite. Entities in this context represent the highest level of the EPM dimensional model — the legal or management entities against which financial and tax data is captured, consolidated, and reported. The package serves as the sole supported mechanism for creating, maintaining, and translating these entity definitions, enforcing the denormalized structure that separates the base (language-independent) definition from its translated attributes.

The body, identified by header revision fem_entity_pkb.plb 120.1, follows the standard Oracle EBS Table API pattern: a base table (FEM_ENTITIES_B) holds structural and flag-based attributes, while a translation table (FEM_ENTITIES_TL) holds the descriptive text. This split permits multiple-language support without duplicating the structural rows.

Key Procedures and Functions

  • INSERT_ROW — Creates a new entity. It first resolves the ROWID of the base row from FEM_ENTITIES_B by ENTITY_ID and VALUE_SET_ID, then inserts the base definition (dimension group, display code, enabled/personal/read-only flags, object version number, and audit columns) and subsequently inserts the translated name and description into FEM_ENTITIES_TL for every installed language, using FND_LANGUAGES filtered by INSTALLED_FLAG in ('I','B') and defaulting SOURCE_LANG to the session language via USERENV('LANG').
  • LOCK_ROW — Obtains a row-level lock on the specified entity record, supporting optimistic concurrency control before an update.
  • UPDATE_ROW — Modifies the base definition and the corresponding translated attributes of an existing entity, incrementing the object version number used for version checking.
  • DELETE_ROW — Removes an entity, handling the base table and its translations together to preserve referential integrity.
  • ADD_LANGUAGE — Inserts translation rows into FEM_ENTITIES_TL for a newly installed language, propagating the seed values from the source language.
  • TRANSLATE_ROW — Updates the name and description for a specific language and row, allowing localized text to be maintained without altering the base structural row.

Tables Accessed

  • FEM_ENTITIES_B — The base table; read to retrieve the ROWID and written by INSERT_ROW, UPDATE_ROW, and DELETE_ROW with structural and audit columns.
  • FEM_ENTITIES_TL — The translation table; receives the entity name and description during INSERT_ROW, ADD_LANGUAGE, and TRANSLATE_ROW, keyed by ENTITY_ID, VALUE_SET_ID, LANGUAGE, and SOURCE_LANG.
  • FND_LANGUAGES — Read by INSERT_ROW to determine the set of installed and base languages for which translation rows must be seeded.

Usage Notes

This API is classified as OTHER and is referenced by four other ETRM packages, indicating it is invoked both directly and indirectly during entity maintenance workflows. In standard Oracle EBS operation, the package is called from the EPM/ETRM setup forms that manage entity definitions, from concurrent programs that seed or migrate entity data, and from custom or extension code that provisions entities programmatically. Because the package encapsulates the base/translation insert logic and the language propagation performed through FND_LANGUAGES, developers should never insert into FEM_ENTITIES_B or FEM_ENTITIES_TL directly; all DML should be routed through these procedures to ensure that audit columns, object version numbers, and multi-language rows remain consistent. The metadata excerpt is drawn from revision 120.1 (2005), which remains the pertinent implementation across 12.1.1 and 12.2.2.