Search Results okl_fe_adj_mat_all_tl_pk

Overview

The OKL_FE_ADJ_MAT_ALL_TL table is a critical component within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the OKL (Lease and Finance Management) product module. It functions as a translation table, a standard architectural pattern in Oracle Applications for storing multilingual data. Its primary role is to hold the translated name and description for pricing adjustment matrices. These matrices are business rules used to calculate financial adjustments, such as fees or discounts, within lease and finance contracts. By storing translations separately, the system can present the matrix information in a user's preferred language while maintaining a single, language-independent definition of the adjustment logic in its base table.

Key Information Stored

The table stores language-specific textual attributes for pricing adjustment matrices. Its structure is defined by a composite primary key, which uniquely identifies each translation record. The most significant columns include:

• ADJ_MAT_ID: The foreign key that links the translation to its corresponding base adjustment matrix record in the associated table (e.g., OKL_FE_ADJ_MAT_ALL_B). This is the core identifier for the business object.
• LANGUAGE: The ISO code for the language of the translated text (e.g., 'US' for American English, 'DE' for German). Together with ADJ_MAT_ID, it forms the table's primary key.
• SOURCE_LANG: A system column indicating the original language in which the data was entered, facilitating synchronization during translation processes.
• NAME: The translated, user-facing name of the adjustment matrix.
• DESCRIPTION: The translated, detailed explanation of the adjustment matrix's purpose or rule.

Common Use Cases and Queries

This table is primarily accessed to support multilingual user interfaces and reports within the leasing module. A common scenario is retrieving the matrix description for display in a contract pricing screen or a report based on the user's session language. Developers and report writers will typically join this table to its base table using the ADJ_MAT_ID and filtering by the LANGUAGE column, often leveraging the NLS (National Language Support) session parameter. A standard query pattern is:

• Sample SQL: SELECT B.MATRIX_CODE, TL.NAME, TL.DESCRIPTION FROM OKL_FE_ADJ_MAT_ALL_B B, OKL_FE_ADJ_MAT_ALL_TL TL WHERE B.ADJ_MAT_ID = TL.ADJ_MAT_ID AND TL.LANGUAGE = USERENV('LANG');
• Reporting: All reports listing adjustment matrices, such as configuration audits or pricing summaries, must join to this table to present human-readable names and descriptions.
• Data Migration/Setup: When implementing or configuring the system for multiple languages, this table is populated with translated values for each predefined adjustment matrix.

Related Objects

The OKL_FE_ADJ_MAT_ALL_TL table has a direct, dependent relationship with the base table that holds the non-translated, operational data for the adjustment matrix. This relationship is enforced by its primary key constraint.

• Primary Key Constraint: OKL_FE_ADJ_MAT_ALL_TL_PK on columns (ADJ_MAT_ID, LANGUAGE).
• Base Table Relationship: The ADJ_MAT_ID column is a foreign key referencing the primary key (presumably also ADJ_MAT_ID) of the base adjustment matrix table, which is typically named OKL_FE_ADJ_MAT_ALL_B. This is a standard "B" (base) and "TL" (translation) table pairing in Oracle EBS.
• Dependent Views: Application views that present adjustment matrix data will inherently join to this translation table to source the NAME and DESCRIPTION in the session language.