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.
-
Table: IBY_ACCT_PMT_PROFILES_B
12.2.2
owner:IBY, object_type:TABLE, fnd_design_data:IBY.IBY_ACCT_PMT_PROFILES_B, object_name:IBY_ACCT_PMT_PROFILES_B, status:VALID, product: IBY - Payments , description: IBY_ACCT_PMT_PROFILES stores account-related information that completes the specification of the handling of payment instructions. Entries in this table are based on entries in the IBY_SYS_PMT_PROFILES table. A combination of the two tables , implementation_dba_data: IBY.IBY_ACCT_PMT_PROFILES_B ,
-
Table: IBY_ACCT_PMT_PROFILES_B
12.1.1
owner:IBY, object_type:TABLE, fnd_design_data:IBY.IBY_ACCT_PMT_PROFILES_B, object_name:IBY_ACCT_PMT_PROFILES_B, status:VALID, product: IBY - Payments , implementation_dba_data: IBY.IBY_ACCT_PMT_PROFILES_B ,
-
APPS.IBY_EXTRACTGEN_PVT dependencies on IBY_ACCT_PMT_PROFILES_B
12.2.2
-
APPS.IBY_BUILD_UTILS_PKG dependencies on IBY_ACCT_PMT_PROFILES_B
12.2.2
-
APPS.IBY_UPG_PPP_PKG dependencies on IBY_ACCT_PMT_PROFILES_B
12.1.1
-
APPS.IBY_ACCT_PMT_PROFILES_PKG dependencies on IBY_ACCT_PMT_PROFILES_B
12.1.1
-
APPS.IBY_EXTRACTGEN_PVT dependencies on IBY_ACCT_PMT_PROFILES_B
12.1.1
-
APPS.AP_AUTOSELECT_PKG dependencies on IBY_ACCT_PMT_PROFILES_B
12.2.2
-
APPS.FII_AP_INV_SUM_INC dependencies on IBY_ACCT_PMT_PROFILES_B
12.1.1
-
APPS.IBY_FD_POST_PICP_PROGS_PVT dependencies on IBY_ACCT_PMT_PROFILES_B
12.1.1
-
APPS.IBY_VALIDATIONSETS_PUB dependencies on IBY_ACCT_PMT_PROFILES_B
12.1.1
-
APPS.IBY_PAYINSTR_PUB dependencies on IBY_ACCT_PMT_PROFILES_B
12.1.1
-
APPS.IBY_ACCT_PMT_PROFILES_PKG dependencies on IBY_ACCT_PMT_PROFILES_B
12.2.2
-
APPS.IBY_FD_POST_PICP_PROGS_PVT dependencies on IBY_ACCT_PMT_PROFILES_B
12.2.2
-
APPS.FII_AP_INV_SUM_INIT dependencies on IBY_ACCT_PMT_PROFILES_B
12.1.1
-
APPS.IBY_PAYGROUP_PUB dependencies on IBY_ACCT_PMT_PROFILES_B
12.1.1
-
APPS.IBY_BUILD_UTILS_PKG dependencies on IBY_ACCT_PMT_PROFILES_B
12.1.1
-
APPS.IBY_UPG_PPP_PKG dependencies on IBY_ACCT_PMT_PROFILES_B
12.2.2
-
APPS.IBY_PAYINSTR_PUB dependencies on IBY_ACCT_PMT_PROFILES_B
12.2.2
-
APPS.IBY_BUILD_UTILS_PKG dependencies on IBY_APPLICABLE_PMT_PROFS
12.2.2
-
VIEW: IBY.IBY_ACCT_PMT_PROFILES_B#
12.2.2
owner:IBY, object_type:VIEW, object_name:IBY_ACCT_PMT_PROFILES_B#, status:VALID,
-
APPS.IBY_BUILD_UTILS_PKG dependencies on IBY_SYS_PMT_PROFILES_B
12.2.2
-
APPS.IBY_FD_POST_PICP_PROGS_PVT SQL Statements
12.2.2
-
APPS.FII_AP_INV_SUM_INIT dependencies on AP_CHECKS_ALL
12.1.1
-
APPS.IBY_FD_POST_PICP_PROGS_PVT SQL Statements
12.1.1
-
APPS.FII_AP_INV_SUM_INIT dependencies on IBY_SYS_PMT_PROFILES_B
12.1.1
-
SYNONYM: APPS.IBY_ACCT_PMT_PROFILES_B
12.2.2
owner:APPS, object_type:SYNONYM, object_name:IBY_ACCT_PMT_PROFILES_B, status:VALID,
-
APPS.IBY_ACCT_PMT_PROFILES_PKG SQL Statements
12.2.2
-
APPS.IBY_UPG_PPP_PKG dependencies on IBY_ACCT_PMT_PROFILES_B_S
12.2.2
-
TRIGGER: APPS.IBY_ACCT_PMT_PROFILES_B+
12.2.2
owner:APPS, object_type:TRIGGER, object_name:IBY_ACCT_PMT_PROFILES_B+, status:VALID,
-
APPS.IBY_UPG_PPP_PKG dependencies on IBY_FORMATS_B
12.2.2
-
APPS.AP_AUTOSELECT_PKG dependencies on IBY_PMT_CREATION_RULES
12.2.2
-
SYNONYM: APPS.IBY_ACCT_PMT_PROFILES_B
12.1.1
owner:APPS, object_type:SYNONYM, object_name:IBY_ACCT_PMT_PROFILES_B, status:VALID,
-
TRIGGER: APPS.IBY_ACCT_PMT_PROFILES_B+
12.2.2
-
VIEW: APPS.IBY_ACCT_PMT_PROFILES_VL
12.2.2
-
APPS.IBY_ACCT_PMT_PROFILES_PKG SQL Statements
12.1.1
-
APPS.IBY_PAYINSTR_PUB dependencies on IBY_SYS_PMT_PROFILES_B
12.2.2
-
APPS.IBY_UPG_PPP_PKG dependencies on IBY_BEPKEYS
12.2.2
-
APPS.IBY_PAYINSTR_PUB dependencies on IBY_SYS_PMT_PROFILES_B
12.1.1
-
APPS.IBY_UPG_PPP_PKG dependencies on IBY_BEPINFO
12.2.2
-
APPS.FII_AP_INV_SUM_INC dependencies on AP_CHECKS_ALL
12.1.1
-
APPS.FII_AP_INV_SUM_INC dependencies on IBY_SYS_PMT_PROFILES_B
12.1.1
-
VIEW: APPS.IBY_ACCT_PMT_PROFILES_VL
12.1.1
-
APPS.IBY_BUILD_UTILS_PKG dependencies on IBY_APPLICABLE_PMT_PROFS
12.1.1
-
VIEW: IBY.IBY_ACCT_PMT_PROFILES_B#
12.2.2
-
FUNCTION: APPS.IBY_ACCT_PMT_PROFILES_B=
12.2.2
-
APPS.IBY_VALIDATIONSETS_PUB dependencies on IBY_TRANSMIT_PROTOCOLS_B
12.1.1
-
APPS.IBY_VALIDATIONSETS_PUB dependencies on IBY_SYS_PMT_PROFILES_B
12.1.1
-
APPS.IBY_PAYGROUP_PUB dependencies on IBY_TRANSMIT_CONFIGS_B
12.1.1
-
Table: IBY_PAY_SERVICE_REQUESTS
12.1.1
owner:IBY, object_type:TABLE, fnd_design_data:IBY.IBY_PAY_SERVICE_REQUESTS, object_name:IBY_PAY_SERVICE_REQUESTS, status:VALID, product: IBY - Payments , implementation_dba_data: IBY.IBY_PAY_SERVICE_REQUESTS ,