Search Results iby_payment_manager_pkg




Overview
Explore in AI Chat

Overview

The APPS.IBY_PAYMENT_MANAGER_PKG package body is a core component of the Oracle Payments (IBY) module in Oracle E-Business Suite 12.1.1 and 12.2.2. Its principal business function is to support the Payment Manager, the central engine responsible for orchestrating payment processing after invoices, payment instructions, and payment service requests have been selected for payment. The package provides the runtime plumbing required to validate organizational access, assemble the working set of payment instructions and payment service requests, and expose that data to downstream processes such as the payment instruction build, formatting, and transmission programs. Because it is a package body with no documented independent business API classification ("OTHER"), it is intended primarily as an internal implementation unit invoked by the Payment Manager infrastructure rather than as a published integration interface.

Key Procedures and Functions

The ETRM metadata documents two public program units within this package body:

  • GET_PSR_SNAPSHOT_PIPE — Returns a snapshot of payment service requests (PSRs) through a pipelined table function. This enables the Payment Manager to stream the current set of PSRs to callers in a set-based, row-by-row fashion, which is efficient for large payment runs. It is the mechanism by which PSR data is made available to the Payment Manager workflow and any dependent processing logic.
  • CHECK_ORG_ACCESS — Validates whether the current user has access to a given organization (operating unit or legal entity) for payment processing purposes. This function enforces multi-org security and ensures that payment operations are confined to the organizations the user is authorized to act upon. It relies on MO_GLOBAL for multi-org context resolution.

No further parameter-level detail is documented, and no additional public procedures or functions are recorded for this version.

Tables Accessed

The package body references the following tables and views through APPS synonyms:

  • IBY_PAYMENTS_ALL — The central payment table; read to obtain payment records associated with the current processing context.
  • IBY_PAY_INSTRUCTIONS_ALL — Payment instructions that group payments for delivery to a payment system or bank.
  • IBY_PAY_SERVICE_REQUESTS — Payment service requests that define the services (e.g., formatting, transmission) to be performed; the source set for GET_PSR_SNAPSHOT_PIPE.
  • AP_INV_SELECTION_CRITERIA_ALL — Payables invoice selection criteria, providing the parameters under which payments were selected.
  • FND_LOOKUP_VALUES — Standard lookup values used for validation and interpretation of payment attributes.
  • DUAL and PLITBLM — Utility constructs supporting SQL expression evaluation and pipelined/tabular data handling respectively.

The dependency list also shows references to PL/SQL units including AP_PAYMENT_UTIL_PKG, FND_LOG, IBY_DEBUG_PUB, and MO_GLOBAL, which support payment utilities, logging, debugging, and multi-org access control.

Usage Notes

IBY_PAYMENT_MANAGER_PKG is invoked internally by the Oracle Payments Payment Manager framework during payment processing runs, typically as part of concurrent program execution for payment instruction creation and formatting. The multi-org access check (CHECK_ORG_ACCESS) is called early in the processing sequence to confirm that the submitting user may act on the target organizations. The pipelined snapshot function (GET_PSR_SNAPSHOT_PIPE) is used within the build/processing logic to consume PSR data efficiently. Because the package is not referenced by any other database object and is not classified as a public API, customizations should avoid calling it directly; integrators requiring similar functionality should use supported Oracle Payments APIs or the documented concurrent programs. The package is listed as VALID in the ETRM metadata, indicating it is compiled and operational in the documented releases.