Search Results iby_acct_pmt_profiles_vl




Overview
Explore in AI Chat

Overview

IBY_ACCT_PMT_PROFILES_VL is an APPS-owned, valid database view in the Oracle Payments (IBY) module of Oracle E-Business Suite, available in both 12.1.1 and 12.2.2. It is a translated (_VL) view that exposes account payment profiles—the configuration records that determine how a specific bank account or payment system profile transmits, secures, and numbers payment instructions. The view presents a language-specific, denormalized read model of payment profile definitions, joining the base table to its translation table and filtering the translation by the session language through USERENV('LANG'), so that each user sees the descriptive name in their own language while the underlying identifiers remain consistent across locales.

Because payment profiles hold the operational parameters used by the payments engine—transmission configuration, security configuration, acknowledgment settings, and document numbering sequences—this view is a primary reference for reporting, data extraction, and integration. It is widely used in Oracle Payments setup validation, diagnostics of payment instruction formatting, and downstream ETL into data warehouses or reconciliation platforms.

Underlying Base Objects

The view is defined over two documented base objects:

The two are combined on PAYMENT_PROFILE_ID, with the translation restricted to the user's language. The "_VL" suffix confirms this is a view that presents translatable data for the current session locale. The synonyms resolve to the underlying application tables registered under the APPS schema.

Key Columns

Common Use Cases and Queries

Typical scenarios include listing active payment profiles for a given bank account, auditing numbering usage, and validating security/transmission configuration assignments.

List all active profiles with their names and system codes:

  • SELECT payment_profile_id, payment_profile_name, system_profile_code FROM iby_acct_pmt_profiles_vl WHERE inactive_date IS NULL;

Inspect numbering state for a profile:

  • SELECT payment_profile_name, last_used_number_1, reset_value_1, reset_request_1 FROM iby_acct_pmt_profiles_vl WHERE payment_profile_id = :p_profile_id;

Correlate profiles with transmission and security configurations:

  • SELECT payment_profile_name, transmit_configuration_id, security_configuration_id FROM iby_acct_pmt_profiles_vl ORDER BY payment_profile_name;

Because the view embeds the language filter, queries automatically return the profile name in the session language, simplifying multilingual reporting and integration extracts.