Search Results iby_sys_pmt_profiles_tl_pk

Overview

The IBY_SYS_PMT_PROFILES_TL table is a core translation table within the Oracle Payments (IBY) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It stores translated, language-specific descriptions for system payment profiles. These profiles define the operational rules and configurations for payment processing, such as payment methods, formatting, and transmission setups. The table's primary role is to support the multilingual capabilities of the application, ensuring that profile names and descriptions are displayed in the user's session language. It is a child table to the base table IBY_SYS_PMT_PROFILES_B, which holds the language-independent definition of the profile.

Key Information Stored

The table's structure is designed to manage translated text for a unique payment profile in each supported language. Its primary key is a composite of SYSTEM_PROFILE_CODE and LANGUAGE, enforcing uniqueness of translation per profile per language. The SYSTEM_PROFILE_CODE column is a foreign key referencing the base profile definition. The LANGUAGE column stores the standard Oracle language code (e.g., 'US' for American English). The most critical user-facing column is typically SYSTEM_PROFILE_NAME, which holds the translated, descriptive name of the payment profile as it should appear in the application's user interface. Other standard Translation Table (TL) columns, such as CREATED_BY and LAST_UPDATE_DATE, track the row's audit history.

Common Use Cases and Queries

This table is primarily accessed by the application's runtime to display localized profile information. Common use cases include generating user interface labels in payment setup forms and reports in the correct language. A standard query to retrieve a profile's translated name for the current session language would join this table to its base table. For example:

• SELECT tl.system_profile_name FROM iby_sys_pmt_profiles_b b, iby_sys_pmt_profiles_tl tl WHERE b.system_profile_code = tl.system_profile_code AND tl.language = USERENV('LANG');

Administrative or data migration scripts may also query this table to extract or verify translation data for a set of profiles across multiple languages, often using the SOURCE_LANG column to identify the original language of the record.

Related Objects

The IBY_SYS_PMT_PROFILES_TL table has a direct and critical relationship with its base table, as defined by the provided foreign key metadata.

• IBY_SYS_PMT_PROFILES_B: This is the primary related object. The foreign key from IBY_SYS_PMT_PROFILES_TL on the column SYSTEM_PROFILE_CODE references the corresponding column in IBY_SYS_PMT_PROFILES_B. All translation rows are dependent on a master record existing in this base table.
• IBY_SYS_PMT_PROFILES_TL_PK: This is the primary key constraint on the table, defined on the columns (SYSTEM_PROFILE_CODE, LANGUAGE).

This table is also referenced by various Payment module APIs and user interface forms that present profile information. It is integral to the seeded multi-language support architecture of Oracle EBS.