Search Results iby_remit_advice_setup




Overview
Explore in AI Chat

Overview

The IBY_REMIT_ADVICE_SETUP table is a core repository within the Oracle E-Business Suite Payments (IBY) module. It stores the configuration for generating and delivering remittance advice documents, which are detailed statements of payment information sent to a payee (e.g., a supplier) separately from the payment instrument itself. This separation is critical for electronic payments where remittance data is often transmitted via email, a web portal, or Electronic Data Interchange (EDI). The table's configuration is organized by the SYSTEM_PROFILE_CODE, linking remittance advice settings directly to a specific Payment Process Profile, which defines the rules for a payment batch. This setup enables businesses to automate and tailor the delivery of remittance information according to the payment method and payee requirements.

Key Information Stored

The table's primary function is to define the format and delivery mechanism for remittance advices per payment process profile. While the full column list is not detailed in the provided metadata, the documented relationships and context indicate several critical data points. The SYSTEM_PROFILE_CODE serves as the primary key, uniquely identifying the setup for a specific profile. The REMITTANCE_ADVICE_FORMAT_CODE is a foreign key that determines the output format (e.g., a specific XML, text, or PDF layout) by referencing the IBY_FORMATS_B table. Other columns likely control delivery methods (e.g., email, printing), delivery addresses, triggering events, and whether advice generation is enabled for the profile.

Common Use Cases and Queries

This table is central to troubleshooting and reporting on remittance advice configurations. A common administrative task is verifying the setup for a known payment process profile. A typical query would join to the profile and format tables to present a readable summary:

  • SELECT ras.system_profile_code, prof.profile_name, fmt.format_name FROM iby_remit_advice_setup ras, iby_sys_pmt_profiles_b prof, iby_formats_b fmt WHERE ras.system_profile_code = prof.system_profile_code AND ras.remittance_advice_format_code = fmt.format_code;

Another critical use case is during the implementation or upgrade of payment processes, where this table is populated or updated via the Oracle Payments Manager user interface to define how remittances are generated for different payee groups and payment methods.

Related Objects

The IBY_REMIT_ADVICE_SETUP table has defined relationships with other key Payments tables, as per the provided metadata:

  • IBY_SYS_PMT_PROFILES_B: The table is child to this parent table via the SYSTEM_PROFILE_CODE foreign key. This enforces that remittance advice setup is defined for a valid, existing payment process profile.
  • IBY_FORMATS_B: The table references this master list of document formats via the REMITTANCE_ADVICE_FORMAT_CODE foreign key. This determines the technical structure of the generated advice document.

As the central configuration point, this table is also referenced by various internal Payment APIs and likely underpins key views used in the Oracle Payments Manager interface for setup and inquiry.