Search Results interest_code_id




Overview
Explore in AI Chat

Overview

The AS_INTEREST_CODES_TL table is a core data object within the Oracle E-Business Suite (EBS) Sales Foundation module, specifically designed to support the Multi-Lingual Support (MLS) architecture. It functions as a translation table, storing language-specific textual descriptions for interest codes defined in the base table, AS_INTEREST_CODES_B. This structure separates language-invariant data (like IDs and codes) from translatable attributes (like names and descriptions), enabling a single EBS installation to support multiple languages for sales-related interest classifications used in processes such as lead and opportunity management.

Key Information Stored

The table's primary purpose is to hold translated text, which is uniquely identified by a composite key. The most critical columns include INTEREST_CODE_ID, which is the foreign key linking to the base table's primary identifier; LANGUAGE, which holds the language code (e.g., 'US', 'FR', 'DE') for the translation; and CODE, which stores the actual interest code value. The table also contains the translated NAME and DESCRIPTION columns for the interest code in the specified language. The SOURCE_LANG column indicates the original language of the record, which is typically the installation's base language. The table enforces data integrity through two unique constraints: a primary key on (INTEREST_CODE_ID, LANGUAGE) and a unique key on (INTEREST_CODE_ID, CODE, LANGUAGE).

Common Use Cases and Queries

The primary use case is retrieving interest code descriptions in a user's session language for UI display, reports, and data extracts. A typical query joins the translation table with its base table, filtering by the desired language and often the session language via the NLS_LANGUAGE database parameter. For example, to get all active interest codes in French, one might use:

  • SELECT b.CODE, tl.NAME, tl.DESCRIPTION FROM AS_INTEREST_CODES_B b, AS_INTEREST_CODES_TL tl WHERE b.INTEREST_CODE_ID = tl.INTEREST_CODE_ID AND tl.LANGUAGE = 'FR' AND b.ENABLED_FLAG = 'Y';

Another common pattern is used in seeded data migration or upgrade scripts, where data is inserted into this table for each supported language. Reporting on the availability of translations for a given set of interest codes is also a frequent administrative task.

Related Objects

AS_INTEREST_CODES_TL has a direct and fundamental relationship with the AS_INTEREST_CODES_B table. The foreign key AS_INTEREST_CODES_TL.INTEREST_CODE_ID references AS_INTEREST_CODES_B, forming the core link between a translatable attribute and its base definition. This is a classic EBS MLS table pair. In application logic, this table is accessed through views that automatically handle language filtering, such as AS_INTEREST_CODES_VL (the "VL" suffix denotes a view for a specific language). Developers and integrators should utilize these public views or the relevant Oracle APIs for any data operations to ensure proper MLS behavior and data integrity.