Search Results iby_acct_pmt_profiles_b




Overview
Explore in AI Chat

Overview

The table IBY_ACCT_PMT_PROFILES_B is a core data object within the Oracle E-Business Suite Payments (IBY) module, serving as the foundation for account-specific payment processing configurations. It stores the account-related information required to complete the specification for handling payment instructions. Each record in this table is based on a corresponding entry in the IBY_SYS_PMT_PROFILES_B table, which defines system-level payment profile settings. The combination of these two tables creates a fully defined payment profile, linking a specific bank account, transmission method, and other financial details to a system-level payment process. This table is critical for the execution of payment batches, as it determines the exact funding account and disbursement mechanism for generated payments.

Key Information Stored

While the specific column list is not detailed in the provided metadata, the foreign key relationships and description indicate the table's primary purpose is to associate a payment profile with concrete banking and transmission details. The key column is PAYMENT_PROFILE_ID, which serves as the primary key and uniquely identifies each account-level profile. Based on the foreign key constraints, other crucial columns likely include SYSTEM_PROFILE_CODE (linking to the system profile), BEP_ACCOUNT_ID (identifying the specific bank account within a payment system), and TRANSMIT_CONFIGURATION_ID (defining the electronic transmission setup, such as FTP details). The table essentially operationalizes a generic system payment profile by attaching the specific bank account from which funds will be disbursed.

Common Use Cases and Queries

This table is central to payment execution and troubleshooting. A common use case is identifying the bank account and transmission method used for a specific payment instruction or batch. System administrators and payment processors query this table to validate profile setups or diagnose payment failures. For instance, to find the complete setup for a payment profile referenced on an invoice, one would join this table to the system profile and bank account tables.

  • Profile Lookup: SELECT * FROM iby_acct_pmt_profiles_b WHERE payment_profile_id = :1;
  • Join to System Profile: SELECT acc.*, sys.* FROM iby_acct_pmt_profiles_b acc, iby_sys_pmt_profiles_b sys WHERE acc.system_profile_code = sys.system_profile_code;
  • Link to Payments: SELECT p.payment_id, prof.* FROM iby_payments_all p, iby_acct_pmt_profiles_b prof WHERE p.payment_profile_id = prof.payment_profile_id;

Related Objects

The IBY_ACCT_PMT_PROFILES_B table sits at a critical junction, referenced by numerous transactional and setup tables within the Payments module, as evidenced by its extensive foreign key relationships.

  • Parent/Dependency Tables:
    • IBY_SYS_PMT_PROFILES_B: Linked via SYSTEM_PROFILE_CODE. Provides the system-level profile definition.
    • IBY_BEPKEYS: Linked via BEP_ACCOUNT_ID. Identifies the specific bank account.
    • IBY_TRANSMIT_CONFIGS_B: Linked via TRANSMIT_CONFIGURATION_ID. Defines the electronic file transmission parameters.
  • Child/Referencing Tables:
  • 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 , 

  • 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 , 

  • Table: IBY_DOCUMENTS_PAYABLE_H 12.1.1

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_DOCUMENTS_PAYABLE_H,  object_name:IBY_DOCUMENTS_PAYABLE_H,  status:VALID,  product: IBY - Payments ,  implementation_dba_data: IBY.IBY_DOCUMENTS_PAYABLE_H , 

  • Table: IBY_SYS_PMT_PROFILES_B 12.1.1

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_SYS_PMT_PROFILES_B,  object_name:IBY_SYS_PMT_PROFILES_B,  status:VALID,  product: IBY - Payments ,  implementation_dba_data: IBY.IBY_SYS_PMT_PROFILES_B , 

  • Table: IBY_TRANSMIT_CONFIGS_B 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_TRANSMIT_CONFIGS_B,  object_name:IBY_TRANSMIT_CONFIGS_B,  status:VALID,  product: IBY - Payments ,  implementation_dba_data: IBY.IBY_TRANSMIT_CONFIGS_B , 

  • Table: IBY_BEPKEYS 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_BEPKEYS,  object_name:IBY_BEPKEYS,  status:VALID,  product: IBY - Payments ,  description: IBY_BEPKEYS stores information about the payment systems accounts. ,  implementation_dba_data: IBY.IBY_BEPKEYS , 

  • Table: IBY_PAY_INSTRUCTIONS_ALL 12.1.1

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_PAY_INSTRUCTIONS_ALL,  object_name:IBY_PAY_INSTRUCTIONS_ALL,  status:VALID,  product: IBY - Payments ,  implementation_dba_data: IBY.IBY_PAY_INSTRUCTIONS_ALL , 

  • Table: IBY_ACCT_PMT_PROFILES_TL 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_ACCT_PMT_PROFILES_TL,  object_name:IBY_ACCT_PMT_PROFILES_TL,  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_TL , 

  • Table: IBY_PAY_SERVICE_REQUESTS 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_PAY_SERVICE_REQUESTS,  object_name:IBY_PAY_SERVICE_REQUESTS,  status:VALID,  product: IBY - Payments ,  description: "This table contains records of the payment process requests which are created by system while processing 'Build payments' program.IBY_PAY_SERVICE_REQUESTS stores payment process requests from source products. A payment process request is ,  implementation_dba_data: IBY.IBY_PAY_SERVICE_REQUESTS , 

  • Table: IBY_PAY_INSTRUCTIONS_ALL 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_PAY_INSTRUCTIONS_ALL,  object_name:IBY_PAY_INSTRUCTIONS_ALL,  status:VALID,  product: IBY - Payments ,  description: "This table contains records of the payment instructions. Instructions are created based on the Payment Process Request options. Data is inserted in to the table IBY_PAY_INSTRUCTIONS_AL after payment instruction creation, based on the opt ,  implementation_dba_data: IBY.IBY_PAY_INSTRUCTIONS_ALL , 

  • View: IBY_ACCT_PMT_PROFILES_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:IBY.IBY_ACCT_PMT_PROFILES_VL,  object_name:IBY_ACCT_PMT_PROFILES_VL,  status:VALID,  product: IBY - Payments ,  implementation_dba_data: APPS.IBY_ACCT_PMT_PROFILES_VL , 

  • View: IBY_ACCT_PMT_PROFILES_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IBY.IBY_ACCT_PMT_PROFILES_VL,  object_name:IBY_ACCT_PMT_PROFILES_VL,  status:VALID,  product: IBY - Payments ,  implementation_dba_data: APPS.IBY_ACCT_PMT_PROFILES_VL , 

  • Table: IBY_DOCUMENTS_PAYABLE_H 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_DOCUMENTS_PAYABLE_H,  object_name:IBY_DOCUMENTS_PAYABLE_H,  status:VALID,  product: IBY - Payments ,  description: IBY_DOCUMENTS_PAYABLE_H stores historical snapshots of documents payable. This table contains denormalized versions of documents payable from specific points in time, such as when the payment for this document was submitted to a payment sys ,  implementation_dba_data: IBY.IBY_DOCUMENTS_PAYABLE_H , 

  • Table: IBY_PAYMENTS_ALL 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_PAYMENTS_ALL,  object_name:IBY_PAYMENTS_ALL,  status:VALID,  product: IBY - Payments ,  description: "This table contains records of the payments which are created by system while processing 'Build payments' program. A payment can be a single check or an electronic fund transfer between first party payer and third party payee. A row in ,  implementation_dba_data: IBY.IBY_PAYMENTS_ALL , 

  • Table: IBY_SYS_PMT_PROFILES_B 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_SYS_PMT_PROFILES_B,  object_name:IBY_SYS_PMT_PROFILES_B,  status:VALID,  product: IBY - Payments ,  description: "This table stores Payment Process Profile setup for Funds Disbursement transactions. This table also stores information of the seeded Payment process profiles. IBY_SYS_PMT_PROFILES_B stores information that specifies the bulk of payment ,  implementation_dba_data: IBY.IBY_SYS_PMT_PROFILES_B , 

  • Table: IBY_DOCS_PAYABLE_ALL 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_DOCS_PAYABLE_ALL,  object_name:IBY_DOCS_PAYABLE_ALL,  status:VALID,  product: IBY - Payments ,  description: "This table contains records of the documents payable which are updated by system while processing 'Build payments' program. IBY_DOCS_PAYABLE_ALL stores Oracle Payments' representation of source products' documents payable. A document pay ,  implementation_dba_data: IBY.IBY_DOCS_PAYABLE_ALL ,