Search Results fem_data_types_tl

Overview

APPS.FEM_DATA_TYPES_PKG is an Oracle Enterprise Business Suite (EBS) PL/SQL package that maintains the definition and translation records for FEM (Financial Enterprise Management) Data Types. In the ETRM/Enterprise Performance Foundation data model, a Data Type describes a class or category of stored data used by the analytic and dimensional engines — for example, identifying the semantic role a value plays when it is staged, calculated, or reported. The package encapsulates the standard Oracle Forms-style DML API pattern that governs the base table FEM_DATA_TYPES_B and its translation table FEM_DATA_TYPES_TL.

The package is classified in ETRM metadata as OTHER, meaning it is not a fully public, versioned business API in the same sense as a major interface table handler; it is a maintenance package invoked primarily by the owning application’s setup forms and internal processing. It provides the low-level insert, lock, update, delete, add-language, and translate operations required so that the seed or setup data in the base table and its language rows remain synchronized. The user search term fem_data_types_tl corresponds directly to the translation table this package manipulates: the package is the supported code path by which rows in that table are created and maintained.

Key Procedures and Functions

The documented interface consists of six procedures:

• INSERT_ROW — Creates a new Data Type. It first inserts the base (non-translated) attributes into FEM_DATA_TYPES_B, then inserts one translation row into FEM_DATA_TYPES_TL for every installed language returned by FND_LANGUAGES, using USERENV('LANG') as the source language. It returns the ROWID of the newly created base row.
• LOCK_ROW — Obtains a pessimistic lock on a Data Type record, validating that the supplied values still match the persisted row and raising an error if another session has changed it. This supports the standard lost-update protection pattern used by Oracle Forms.
• UPDATE_ROW — Applies modifications to an existing Data Type, updating the base table attributes and the translation rows as appropriate.
• DELETE_ROW — Removes the Data Type definition, deleting the corresponding base and translation rows.
• ADD_LANGUAGE — Propagates a new language row into FEM_DATA_TYPES_TL for languages installed after the original Data Type was created. This is the routine that back-fills translations when a new language is activated in the instance.
• TRANSLATE_ROW — Updates the translatable columns (name and description) for a specific language in FEM_DATA_TYPES_TL, supporting the standard translation maintenance user interface.

Tables Accessed

• FEM_DATA_TYPES_B — The base table holding language-independent attributes: data type code, personal flag, enabled flag, read-only flag, and the standard WHO audit columns. INSERT_ROW, UPDATE_ROW, and DELETE_ROW write here; the package also selects ROWID from it during insert and lock processing.
• FEM_DATA_TYPES_TL — The translation table storing FEM_DATA_TYPE_NAME, DESCRIPTION, LANGUAGE, and SOURCE_LANG. INSERT_ROW populates it across all installed languages; ADD_LANGUAGE and TRANSLATE_ROW maintain it thereafter.
• FND_LANGUAGES — The Oracle Applications language registry, queried to enumerate installed languages (INSTALLED_FLAG in 'I' or 'B') so that insert and add-language operations create the correct set of translation rows.

Usage Notes

FEM_DATA_TYPES_PKG is invoked by the ETRM setup forms and by internal concurrent processing rather than by end users directly. Metadata indicates the package is referenced by three other packages, consistent with its role as a building block for higher-level Data Type and dimension maintenance routines. Custom code should not bypass the package to write directly to FEM_DATA_TYPES_B or FEM_DATA_TYPES_TL, because the insert and add-language procedures rely on FND_LANGUAGES and USERENV('LANG') to keep the base and translation tables consistent; direct DML risks orphaned or missing translation rows. When diagnosing issues with the term fem_data_types_tl, verify that each base row has a complete set of language rows and that TRANSLATE_ROW or ADD_LANGUAGE has been rerun after any language installation.