Search Results iby_acct_pmt_profiles_b




The IBY_ACCT_PMT_PROFILES_B table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical component of the Oracle Payments module, which facilitates payment processing across various Oracle applications. This table serves as the foundation for storing payment profile details at the account level, enabling organizations to define and manage payment processing rules, formats, and methods for different bank accounts. Below is a detailed analysis of its structure, purpose, and integration within Oracle EBS.

Purpose and Functional Overview

The IBY_ACCT_PMT_PROFILES_B table stores payment profile configurations linked to specific bank accounts. These profiles determine how payments are processed, including payment methods, formats (e.g., EFT, check, wire), and validation rules. The table acts as a bridge between bank account setups (CE_BANK_ACCOUNTS) and payment instructions (IBY_PAYMENTS_ALL), ensuring consistency in payment execution. Key functionalities include:

  • Payment Method Assignment: Defines allowed payment methods (e.g., ACH, SWIFT) per account.
  • Format Customization: Specifies payment file formats (e.g., BAI2, NACHA) for electronic payments.
  • Validation Rules: Enforces business rules (e.g., minimum/maximum payment amounts) during payment creation.

Table Structure and Key Columns

The table’s structure includes columns that map payment profiles to bank accounts and define processing attributes. Notable columns include:

Column Name Data Type Description
ACCOUNT_PMT_PROFILE_ID NUMBER Primary key; unique identifier for the payment profile.
BANK_ACCOUNT_ID NUMBER Foreign key linking to CE_BANK_ACCOUNTS.
PAYMENT_PROFILE_ID NUMBER References IBY_PMT_PROFILES_B for shared profile settings.
ORG_TYPE VARCHAR2(30) Indicates the owning entity type (e.g., 'LE', 'OU').
ORG_ID NUMBER ID of the owning organization (Legal Entity/Operating Unit).
ENABLED_FLAG VARCHAR2(1) Activates/deactivates the profile ('Y'/'N').

Integration with Oracle EBS Modules

The table integrates with several EBS modules:

  • Accounts Payable (AP): Payment profiles determine how supplier invoices are paid.
  • Accounts Receivable (AR): Defines formats for customer receipt processing.
  • Cash Management (CE): Links bank accounts to payment instructions for reconciliation.

Technical Considerations

In EBS 12.2.2, the table leverages Oracle’s Online Patching (ADOP) framework, ensuring zero downtime during updates. Indexes like IBY_ACCT_PMT_PROFILES_B_N1 (on BANK_ACCOUNT_ID) optimize query performance. Customizations should avoid direct DML on this table; instead, use Oracle Payments’ APIs (IBY_PROFILE_PUB) to maintain data integrity.

Conclusion

The IBY_ACCT_PMT_PROFILES_B table is a cornerstone of Oracle Payments, enabling granular control over payment processing. Its design ensures scalability and compliance with global banking standards, making it indispensable for organizations leveraging Oracle EBS for financial operations.