Search Results fem_datasets_tl

Overview

APPS.FEM_DATASETS_PKG is the Oracle Enterprise Resource Planning (EBS) Application Programming Interface (API) that manages the definition, maintenance, and multilingual translation of "Datasets" within the Enterprise Performance Foundation / Enterprise Tax, Risk, and Regulatory Management (ETRM) product family. A Dataset, as modeled by the base table FEM_DATASETS_B and its translation table FEM_DATASETS_TL, represents a logical grouping or container of financial and analytical data used by downstream ETRM engines, including Financial Services Accounting Hub, ledger and consolidation processing, and other Hyperion-derivative performance foundation modules.

This package is classified as OTHER in the ETRM repository, meaning it is not a fully public, supported end-user API in the sense of an open "DML" interface, but it is nevertheless referenced by at least five other packages within the ETRM schema. The embedded header comment (fem_dataset_pkb.plb 120.0, dated 2005/06/06) confirms its long-standing role as a foundational maintenance routine for the multi-language Dataset construct in Oracle EBS 12.1.1 and 12.2.2.

Key Procedures and Functions

The package body exposes six documented procedures, forming a complete transactional API over the dataset entities:

• INSERT_ROW — Creates a new Dataset record. It inserts the core attributes (dataset code, enabled flag, display code, read-only flag, personal flag, object version number, and audit columns) into FEM_DATASETS_B, then inserts the translated name and description into FEM_DATASETS_TL for every installed language returned by FND_LANGUAGES (INSTALLED_FLAG in 'I','B'). A rowid cursor validates the base insert.
• LOCK_ROW — Acquires a pessimistic lock on an existing Dataset row, typically to serialize concurrent updates against the same DATASET_CODE before an update or delete operation.
• UPDATE_ROW — Updates the base attributes of an existing Dataset in FEM_DATASETS_B and the corresponding translatable name and description in FEM_DATASETS_TL.
• DELETE_ROW — Removes a Dataset from FEM_DATASETS_B and its associated translation rows from FEM_DATASETS_TL.
• ADD_LANGUAGE — Inserts missing FEM_DATASETS_TL translation rows for a newly installed language, seeded from the SOURCE_LANG value, allowing newly installed languages to inherit the source-language dataset names and descriptions.
• TRANSLATE_ROW — Updates the translated DATASET_NAME and DESCRIPTION for an existing (language, dataset) combination in FEM_DATASETS_TL, supporting the standard Oracle translation workflow (typically performed via the "Translate" window in Forms).

Tables Accessed

The package reads and writes three tables (via APPS synonyms):

• FEM_DATASETS_B — The base (non-translated) table storing the DATASET_CODE primary key, enabled/read-only/personal flags, display code, object version number, WHO audit columns, and creation/update metadata.
• FEM_DATASETS_TL — The translation table holding DATASET_NAME, DESCRIPTION, LANGUAGE, and SOURCE_LANG, keyed by DATASET_CODE and LANGUAGE. This is the object users typically search for as "fem_datasets_tl."
• FND_LANGUAGES — The Oracle Applications language registry, queried during INSERT_ROW and ADD_LANGUAGE to enumerate installed languages and seed translation rows using userenv('LANG') as the source language.

Usage Notes

FEM_DATASETS_PKG is normally invoked by ETRM administrative forms (Dataset definition and translation windows) and by other ETRM packages that reference it, rather than called directly by end users. Custom extensions and migrations may invoke these procedures to load dataset definitions programmatically, but the calling code must supply the DATASET_CODE, audit columns, and language context correctly, since the package does not generate the primary key sequence or the object version number. When working with multi-language datasets, developers should call ADD_LANGUAGE after installing a new language and TRANSLATE_ROW to provide localized names and descriptions, ensuring consistency between FEM_DATASETS_B and FEM_DATASETS_TL.