Search Results iby_instr_creation_rules




Overview
Explore in AI Chat

Overview

The IBY_INSTR_CREATION_RULES table is a core configuration object within the Oracle Payments (IBY) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It defines the business rules that govern how individual payment requests are aggregated into consolidated payment instructions for disbursement. While the system inherently groups payments by internal bank account and payment process profile, this table provides the mechanism for administrators to specify additional, mandatory grouping criteria. This granular control over instruction creation is critical for ensuring that payment batches comply with specific banking requirements, organizational policies, and operational workflows.

Key Information Stored

The table's primary function is to store rule sets linked to specific payment process profiles. Its key columns include SYSTEM_PROFILE_CODE, which is a foreign key to IBY_SYS_PMT_PROFILES_B and identifies the profile to which the rules apply. The table stores the additional grouping attributes, which typically correspond to columns from underlying payment data, such as payment currency, payment method, or payee attributes. The primary key constraint IBY_INSTR_CREATION_RULES_PK on SYSTEM_PROFILE_CODE ensures that only one unique set of creation rules is defined per system payment process profile, enforcing configuration integrity.

Common Use Cases and Queries

A primary use case is configuring a payment process profile to group instructions strictly by payment currency in addition to the default criteria. This ensures separate payment files are generated for USD and EUR payments, for example, which is often a banking mandate. Administrators manage these rules via the Oracle Payments Manager user interface. For reporting and troubleshooting, common queries involve joining to the profile table to see all active rule sets. A sample diagnostic query is:

  • SELECT prof.system_profile_code, prof.profile_name FROM iby_sys_pmt_profiles_b prof WHERE EXISTS (SELECT 1 FROM iby_instr_creation_rules rules WHERE rules.system_profile_code = prof.system_profile_code);

This identifies which profiles have custom instruction creation rules defined, which is essential for auditing payment process configurations and understanding batch behavior.

Related Objects

IBY_INSTR_CREATION_RULES has a direct and essential relationship with the IBY_SYS_PMT_PROFILES_B table, as defined by its foreign key. The payment process profile acts as the parent entity, and the rules are a child configuration detail. The functionality of this table is integral to the payment instruction build engine within the IBY module. While the metadata does not list them, its logic is invoked by core payment processing APIs and concurrent programs, such as the Payment Process Manager, which consumes these rules when building payment instructions during a payment process request submission.

  • Table: IBY_INSTR_CREATION_RULES 12.1.1

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

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

  • View: IBY_EXT_FD_INS_1_0_V 12.1.1

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

  • View: IBY_EXT_FD_INS_1_0_V 12.2.2

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