Search Results ff_database_items_tl




Overview
Explore in AI Chat

Overview

The FF_DATABASE_ITEMS_TL table is a core data object within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically supporting the FastFormula (FF) engine. It serves as the translation table for database item definitions. In Oracle EBS, a database item is a variable that can be referenced within FastFormula programs to retrieve or calculate data from the underlying application tables. This table stores the user-friendly names and descriptions for these database items in multiple languages, enabling the localization of formula definitions and related user interfaces. Its existence is critical for multinational implementations where payroll, compensation, and other HR rules defined via FastFormulas must be presented and maintained in an end-user's native language.

Key Information Stored

The table's structure is designed to support multilingual content tied to specific database item entities. While the full column list is not detailed in the provided metadata, the primary and foreign key relationships reveal its essential components. The primary key is a composite of USER_NAME, USER_ENTITY_ID, and LANGUAGE, ensuring a unique translated entry for each database item per language. The USER_NAME column likely stores the translated, display-ready name of the database item (e.g., "Basic Salary" or "Salaire de base"). The USER_ENTITY_ID is a foreign key that links back to the core definition of the database item in the FF_USER_ENTITIES table. The LANGUAGE column holds the language code (such as 'US', 'F', 'DE') for the translation, adhering to Oracle's standard translation table architecture. Additional columns typically found in TL tables, like SOURCE_LANG, may also be present to track the source language of the translation.

Common Use Cases and Queries

A primary use case is generating reports or building user interfaces that list available FastFormula database items in a specific language for formula designers. Support personnel may query this table to verify or audit the translated labels used within global payroll implementations. A common diagnostic query involves joining to the base table to check for missing translations. For example:

  • SELECT feu.USER_ENTITY_NAME, fdit.USER_NAME, fdit.LANGUAGE FROM ff_user_entities feu, ff_database_items_tl fdit WHERE feu.USER_ENTITY_ID = fdit.USER_ENTITY_ID AND fdit.LANGUAGE = 'F';

This would retrieve the French translations for all database items. Another typical pattern is to use this table as the source for translatable values when customizing or extending the FastFormula engine, ensuring any new items respect the application's multilingual framework.

Related Objects

The FF_DATABASE_ITEMS_TL table has a direct and documented foreign key relationship with the FF_USER_ENTITIES table, which is the central repository for all FastFormula database item definitions. The relationship is defined as follows:

  • Foreign Key to FF_USER_ENTITIES: The column FF_DATABASE_ITEMS_TL.USER_ENTITY_ID references the primary key of FF_USER_ENTITIES. This join is essential for retrieving the technical name and definition details of a database item alongside its translated user name.

Therefore, any process or report that requires the display of a database item's technical identifier (USER_ENTITY_NAME from FF_USER_ENTITIES) with its localized label (USER_NAME from FF_DATABASE_ITEMS_TL) must join these two tables on the USER_ENTITY_ID column, filtered by the appropriate LANGUAGE.