Search Results iby_fd_user_api_pub




Overview
Explore in AI Chat

Overview

IBY_FD_USER_API_PUB is a public PL/SQL API package in the APPS schema that supports the Funds Disbursement (IBY) module of Oracle E-Business Suite. Its role is to expose validation, enablement, and authorisation logic for payment instructions and payment methods to user-facing interfaces such as the Disbursement Instruction UI and payment processing utilities. The package is classified as a PUB (public) API, indicating it is intended for external invocation and is not restricted to internal use.

Rather than creating or executing payments, IBY_FD_USER_API_PUB provides the decision-support layer that determines whether a given payment instruction, method, or profile is valid, complete, or eligible for a specific action. Interactive forms and other modules call these routines to render buttons, raise errors, and enforce business rules before a disbursement record is committed. The package is VALID in both 12.1.1 and 12.2.2, and depends on the standard FND_API and SYS.STANDARD packages.

Key Procedures and Functions

The package exposes eleven documented procedures and functions, all concerned with validating or gating payment instruction activity:

Together these routines form the enablement and validation checks that dictate the availability of termination and action options to the user.

Tables Accessed

The package reads and validates against several IBY tables through APPS synonyms:

  • IBY_APPLICABLE_PMT_MTHDS and IBY_APPLICABLE_PMT_PROFS — supply the permitted payment methods and payment profiles used by VALIDATE_METHOD_AND_PROFILE.
  • IBY_PAYMENTS_ALL — the disbursement payment records examined for instruction status and completeness.
  • IBY_PAY_INSTRUCTIONS_ALL — the payment instruction header and section data used by the termination and completion checks.
  • IBY_REMIT_ADVICE_SETUP — the remittance advice configuration used by RETRIEVE_DEFAULT_SRA_FORMAT.
  • DUAL and PLITBLM — auxiliary references used within the PL/SQL logic.

Usage Notes

IBY_FD_USER_API_PUB is typically invoked by the Disbursement Instruction user interface and by surrounding infrastructure packages. ETRM metadata shows it is referenced by AP_PAYMENT_UTIL_PKG, IBY_DISBURSE_UI_API_PUB_PKG, IBY_UTILITY_PVT, and by itself. Custom code that needs to mimic the standard termination or action enablement behaviour should call these routines rather than reimplementing the rules, ensuring consistency with funds disbursement processing. Because it is a PUB API, it is a supported integration point, though callers should treat the underlying tables as read sources and avoid direct DML.