Search Results iby_disbursement_comp_pub




Overview
Explore in AI Chat

Overview

IBY_DISBURSEMENT_COMP_PUB is a public PL/SQL package in the APPS schema that supports the Oracle Payments (IBY) disbursement completion flow within Oracle E-Business Suite 12.1.1 and 12.2.2. Its primary role is to resolve and validate the payment attributes that determine how a disbursement is issued to a payee, particularly during the period when disbursements are created, formatted, and confirmed by the payment process. The package aggregates eligibility logic across payment methods, payment profiles, formats, delivery channels, and payee bank accounts, and then returns the applicable or default value for a given document or payment context.

Because its API classification is PUB, the package is intended for external invocation by other Oracle applications and by customer extensions. Ten other packages reference it, most notably IBY_DISBURSE_SUBMIT_PUB_PKG, which drives disbursement submission and uses this package to determine the correct instruction and routing values for each payment.

Key Procedures and Functions

The package exposes twelve documented procedures and functions, grouped by purpose:

Tables Accessed

The package reads and, where applicable, writes through APPS synonyms against the following core Oracle Payments tables: IBY_DOCS_PAYABLE_ALL and IBY_EXTERNAL_PAYEES_ALL (document and payee context); IBY_INTERNAL_PAYERS_ALL (payer definition); IBY_PMT_INSTR_USES_ALL and IBY_EXT_PARTY_PMT_MTHDS (payment instrument usage and party method assignments); IBY_APPLICABLE_PMT_MTHDS and IBY_APPLICABLE_PMT_PROFS (applicability rules); IBY_PAYMENT_METHODS_B, IBY_PAYMENT_RULES, and IBY_RULE_CONDITIONS (method and rule definitions); and IBY_TRXN_TYPES_B for transaction type lookups. Supplier and site data is obtained from HZ_PARTIES, HZ_PARTY_SITES, and HZ_LOCATIONS. PLITBLM is used for PL/SQL table handling. The package also depends on FND_API, FND_MSG_PUB, FND_MESSAGE, FND_LOG, IBY_DEBUG_PUB, IBY_DISBURSE_SUBMIT_PUB_PKG, and IBY_VALIDATIONSETS_PUB.

Usage Notes

IBY_DISBURSEMENT_COMP_PUB is typically invoked indirectly by the standard Payments engine during disbursement submission and formatting, rather than being called directly from a form. Custom code that needs to reproduce disbursement applicability logic — for example, to preview eligible payment methods, profiles, or bank accounts for a given payee and document — can call the public functions directly, but should honor the FND message stack and debug conventions used throughout the package. Validation errors are raised through FND_MSG_PUB, so callers must initialize and retrieve messages accordingly. Because the package relies on setup data (payment methods, rules, profiles, and formats), results depend on effective dating and rule conditions configured in the Oracle Payments setup.