Search Results ozf_funds_all_tl_pk

Overview

The OZF_FUNDS_ALL_TL table is a core translation table within the Oracle E-Business Suite (EBS) Trade Management module (OZF). It functions as the master repository for storing translated, language-specific textual descriptions of funds. A fund in this context represents a monetary budget or allocation used for trade promotions, marketing activities, or other channel programs. This table supports the multi-language capabilities of Oracle EBS by enabling the storage of fund names and descriptions in multiple languages, which is critical for global deployments. Its role is to provide the user-facing, translatable attributes that correspond to the transactional and setup data stored in its parent table, OZF_FUNDS_ALL_B.

Key Information Stored

The table's structure is designed to hold translated text linked to a specific fund and language. The primary key, consisting of FUND_ID and LANGUAGE, ensures a unique translatable record for each fund per language. While the exact column list is not detailed in the provided metadata, translation tables in Oracle EBS typically follow a standard pattern. The critical columns include FUND_ID (the link to the base fund record), LANGUAGE (the language code, such as 'US' or 'DE'), SOURCE_LANG (the original language of the data), and translatable columns like FUND_NAME and DESCRIPTION. The presence of a SOURCE_LANG column is a common EBS design pattern for identifying the original record from which translations are seeded.

Common Use Cases and Queries

The primary use case is to retrieve fund information in a user's session language for display in EBS forms, reports, and self-service portals. A typical query joins this table with the base table OZF_FUNDS_ALL_B, filtering by the desired language and relevant fund criteria. For example, to generate a report of active funds with their descriptions in the current session language, one might use a query pattern such as:

• SELECT b.FUND_NUMBER, tl.FUND_NAME, tl.DESCRIPTION
• FROM OZF_FUNDS_ALL_B b, OZF_FUNDS_ALL_TL tl
• WHERE b.FUND_ID = tl.FUND_ID
• AND tl.LANGUAGE = USERENV('LANG')
• AND b.ACTIVE_FLAG = 'Y';

Data maintenance for this table is typically handled through the Oracle EBS application's translation forms or utilities, not via direct SQL manipulation.

Related Objects

The table has a direct and essential relationship with the OZF_FUNDS_ALL_B table, which holds the base, non-translatable fund information. As documented in the provided metadata:

• Foreign Key Relationship: OZF_FUNDS_ALL_TL.FUND_ID references OZF_FUNDS_ALL_B. This is a one-to-many relationship where a single base fund record in OZF_FUNDS_ALL_B can have multiple corresponding translated text rows in OZF_FUNDS_ALL_TL (one for each supported language).
• Primary Key: The table's primary key constraint, OZF_FUNDS_ALL_TL_PK, is defined on the columns (FUND_ID, LANGUAGE).

This table is also indirectly related to all application objects and reports that display fund names or descriptions, as they will query this translation table to present data in the appropriate language.