Search Results iby_sys_pmt_profiles_b




Overview
Explore in AI Chat

Overview

The IBY_SYS_PMT_PROFILES_B table is a core setup table within the Oracle E-Business Suite Payments module (IBY). It stores the master definition for Payment Process Profiles, which are critical configuration entities that govern the end-to-end execution of Funds Disbursement (i.e., outgoing payments) transactions. These profiles act as templates, specifying the bulk of the payment processing logic, including formatting, transmission, and bank instructions. The table holds both user-defined profiles and Oracle-seeded profiles, providing a centralized repository for the rules that determine how payments are generated and communicated to financial institutions in both EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's primary key is the SYSTEM_PROFILE_CODE, a unique identifier for each profile. Its most significant columns are foreign keys that link to other setup tables, defining the profile's behavior. Key columns include BEPID (linking to IBY_BEPINFO to identify the Bank Enterprise Publisher or payment system), TRANSMIT_PROTOCOL_CODE (defining the transmission method), and PAYMENT_FORMAT_CODE (specifying the payment file format, e.g., NACHA, BACS). Other crucial columns reference formats for positive pay files (POSITIVE_PAY_FORMAT_CODE) and payment advice letters (PAY_FILE_LETTER_FORMAT_CODE), as well as codes for optional bank instructions (BANK_INSTRUCTION1_CODE, BANK_INSTRUCTION2_CODE). This structure allows a single profile to encapsulate a complete payment processing rule set.

Common Use Cases and Queries

This table is central to troubleshooting payment process execution and understanding system configuration. Common scenarios include identifying which profiles are assigned to specific bank accounts or identifying the setup behind a failed payment submission. A typical diagnostic query joins the system profile to its related setup tables to view a complete profile definition. For example:

  • To list all payment process profiles with their associated payment format and transmission protocol: SELECT sp.system_profile_code, sp.profile_name, f.format_name, tp.protocol_name FROM iby_sys_pmt_profiles_b sp, iby_formats_b f, iby_transmit_protocols_b tp WHERE sp.payment_format_code = f.format_code(+) AND sp.transmit_protocol_code = tp.protocol_code(+);
  • To find profiles using a specific BEP (payment system): SELECT system_profile_code, profile_name FROM iby_sys_pmt_profiles_b WHERE bepid = (SELECT bepid FROM iby_bepinfo WHERE bep_name = '&BEP_NAME');

Reporting often involves joining to IBY_ACCT_PMT_PROFILES_B to see profile assignments to bank accounts.

Related Objects

IBY_SYS_PMT_PROFILES_B is a major hub in the Payments schema, referenced by numerous child tables that extend or utilize its configuration. Key related objects include the translation table IBY_SYS_PMT_PROFILES_TL for multilingual names and several rule and assignment tables: IBY_ACCT_PMT_PROFILES_B (assigns profiles to bank accounts), IBY_PMT_CREATION_RULES, IBY_INSTR_CREATION_RULES, and IBY_PMT_LOGICAL_GRP_RULES. It also links to setup tables for remittance advice (IBY_REMIT_ADVICE_SETUP) and defines applicability (IBY_APPLICABLE_PMT_PROFS). Its foreign key relationships to IBY_FORMATS_B, IBY_TRANSMIT_PROTOCOLS_B, IBY_BEPINFO, and IBY_BANK_INSTRUCTIONS_B are essential for retrieving the descriptive details of the referenced setup entities.

  • 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_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_FORMATS_B 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_FORMATS_B,  object_name:IBY_FORMATS_B,  status:VALID,  product: IBY - Payments ,  description: Stores payment processing format types ,  implementation_dba_data: IBY.IBY_FORMATS_B , 

  • Table: IBY_BANK_INSTRUCTIONS_B 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_BANK_INSTRUCTIONS_B,  object_name:IBY_BANK_INSTRUCTIONS_B,  status:VALID,  product: IBY - Payments ,  description: IBY_BANK_INSTRUCTIONS stores bank instructions that are used as lookup values for payment process profiles and external payee setup. This table corresponds to the Bank Instruction Codes page. ,  implementation_dba_data: IBY.IBY_BANK_INSTRUCTIONS_B , 

  • Table: IBY_PMT_LOGICAL_GRP_RULES 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_PMT_LOGICAL_GRP_RULES,  object_name:IBY_PMT_LOGICAL_GRP_RULES,  status:VALID,  product: IBY - Payments ,  description: IBY_PMT_LOGICAL_GRP_RULES specifies the attributes for grouping the payments in a payment instruction. ,  implementation_dba_data: IBY.IBY_PMT_LOGICAL_GRP_RULES , 

  • Table: IBY_APPLICABLE_PMT_PROFS 12.1.1

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

  • Table: IBY_PMT_CREATION_RULES 12.1.1

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

  • 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_REMIT_ADVICE_SETUP 12.1.1

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

  • Table: IBY_TRANSMIT_PROTOCOLS_B 12.2.2

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

  • Table: IBY_REMIT_ADVICE_SETUP 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_REMIT_ADVICE_SETUP,  object_name:IBY_REMIT_ADVICE_SETUP,  status:VALID,  product: IBY - Payments ,  description: IBY_REMIT_ADVICE_SETUP stores information on creating and delivering remittance information, or remittance advice, for a payee separately from the payment itself. Remittance advice setup is organized by payment process profile. Each payment ,  implementation_dba_data: IBY.IBY_REMIT_ADVICE_SETUP , 

  • Table: IBY_APPLICABLE_PMT_PROFS 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_APPLICABLE_PMT_PROFS,  object_name:IBY_APPLICABLE_PMT_PROFS,  status:VALID,  product: IBY - Payments ,  description: IBY_APPLICABLE_PMT_PROFS maps payment methods to payment process profiles. Since administrators can define both payment methods and payment process profiles, they must also choose which payment process profiles are associated with each paym ,  implementation_dba_data: IBY.IBY_APPLICABLE_PMT_PROFS , 

  • Table: IBY_PMT_CREATION_RULES 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_PMT_CREATION_RULES,  object_name:IBY_PMT_CREATION_RULES,  status:VALID,  product: IBY - Payments ,  description: IBY_PMT_CREATION_RULES specifies how documents payable are grouped into payments. Creation rules are determined by payment process profiles. This table corresponds to the Payment Creation tab of the Update Payment Process Profile page. ,  implementation_dba_data: IBY.IBY_PMT_CREATION_RULES , 

  • Table: IBY_SYS_PMT_PROFILES_TL 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_SYS_PMT_PROFILES_TL,  object_name:IBY_SYS_PMT_PROFILES_TL,  status:VALID,  product: IBY - Payments ,  description: IBY_SYS_PMT_PROFILES stores seeded information that specifies the bulk of payment processing behavior. The rest of the behavior is specified in a user-defined account payment process profile stored in IBY_ACCT_PMT_PROFILES. A combination of ,  implementation_dba_data: IBY.IBY_SYS_PMT_PROFILES_TL , 

  • Table: IBY_INSTR_CREATION_RULES 12.2.2

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_INSTR_CREATION_RULES,  object_name:IBY_INSTR_CREATION_RULES,  status:VALID,  product: IBY - Payments ,  description: IBY_INSTR_CREATION_RULES specifies how payments are grouped into payment instructions. Payment instructions are always grouped by internal bank account and payment process profile but additional items stored in this table can be added for f ,  implementation_dba_data: IBY.IBY_INSTR_CREATION_RULES , 

  • Table: IBY_BEPINFO 12.2.2

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

  • 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_BEPINFO 12.1.1

    owner:IBY,  object_type:TABLE,  fnd_design_data:IBY.IBY_BEPINFO,  object_name:IBY_BEPINFO,  status:VALID,  product: IBY - Payments ,  description: IBY_BEPINFO has a row for every BEP(Back End Payment System) configured in system. A BEP is a payment provider such as Cybercash, Verifone etc ,  implementation_dba_data: IBY.IBY_BEPINFO , 

  • View: IBY_SYS_PMT_PROFILES_VL 12.1.1

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

  • View: IBY_SYS_PMT_PROFILES_VL 12.2.2

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

  • View: IBY_XML_FD_INS_1_0_V 12.2.2

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

  • View: IBY_XML_FD_INS_1_0_V 12.1.1

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