Search Results iby_pmt_creation_rules_pk

Overview

The IBY_PMT_CREATION_RULES table is a core repository within the Oracle Payments (IBY) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as a rule-based control table that governs the fundamental behavior of payment creation processes. Specifically, it stores the primary configuration rules linked to a System Payment Profile, dictating how the system generates payments for a given payment process request. This table is essential for ensuring payments are created according to the organization's specific business, compliance, and operational requirements, acting as a central point of configuration for the payment engine.

Key Information Stored

The table's structure is defined by its primary key and its relationship to the system profile. The most critical column is SYSTEM_PROFILE_CODE, which serves as the unique identifier and primary key (IBY_PMT_CREATION_RULES_PK). This column links the creation rules directly to a specific System Payment Profile defined in the IBY_SYS_PMT_PROFILES_B table. While the provided metadata does not list additional columns, typical rule configurations stored in such a table could include flags or parameters controlling behaviors like: whether to combine multiple invoices into a single payment, rules for determining the payment method (e.g., check, electronic), thresholds for payment creation, and handling instructions for exceptions or discounts. The data in this table is primarily implementation and setup data, configured during the initial payments setup or when modifying payment workflows.

Common Use Cases and Queries

This table is primarily referenced for configuration analysis and troubleshooting payment creation issues. Common use cases include auditing the active rules applied to a payment profile or identifying the profile associated with a specific set of creation rules. A typical query would join this table to the profile table to view the complete setup.

Sample Query:
SELECT prof.system_profile_code, prof.profile_name, rules.*
FROM iby.iby_pmt_creation_rules rules,
     iby.iby_sys_pmt_profiles_b prof
WHERE rules.system_profile_code = prof.system_profile_code
AND prof.profile_name = '<Your_Profile_Name>';
This query retrieves all creation rules for a specified payment profile name, linking the configuration to its human-readable identifier.

Related Objects

The table has a direct and critical foreign key relationship, as documented in the provided metadata.

• IBY_SYS_PMT_PROFILES_B: This is the parent table for System Payment Profiles. The IBY_PMT_CREATION_RULES table references it via the SYSTEM_PROFILE_CODE column (Foreign Key: IBY_PMT_CREATION_RULES.SYSTEM_PROFILE_CODE → IBY_SYS_PMT_PROFILES_B). A payment creation rule cannot exist without being associated with a defined system payment profile.

This relationship is fundamental, ensuring that every set of payment creation rules is explicitly tied to a master payment configuration profile within the Oracle Payments module.