Search Results iby_assignext_pub

Overview

The APPS.IBY_ASSIGN_PUB package is a public PL/SQL API within the Oracle Payments (IBY) module of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It forms the core assignment engine for payment documents, orchestrating the evaluation, selection, and application of payment process profiles and payment system assignments against payable documents. In practice, this package drives the rules-based logic that determines how an invoice or payment request is routed through a configured payment process, including profile driver evaluation and payee format resolution. Because it is classified as a PUB API, it is intended for controlled external invocation by other Oracle EBS modules and, where appropriate, by custom extensions.

The object carries a VALID status in the APPS schema and depends on standard IBY and SYS objects. Its architecture clearly separates the public assignment logic from the external-facing wrapper IBY_ASSIGNEXT_PUB, which references it, reflecting the typical IBY design pattern of pairing internal "PUB" engine packages with "EXT" (extension) public wrappers.

Key Procedures and Functions

The documented API exposes thirteen procedures and functions. PERFORMASSIGNMENTS is the primary entry point that executes assignment processing for one or more payable documents. GETREQUESTATTRIBUTES retrieves attributes associated with a payment service request. UPDATEDOCUMENTASSIGNMENTS persists assignment results back to the affected document records, while SETDOCUMENTASSIGNMENTS establishes the document-level assignment values in preparation for updates.

Configuration resolution is handled by GETPROFILEFROMPROFILEDRIVERS and GETPROFILEFROMPAYEEFORMAT, which derive the applicable payment process profile from profile driver criteria and from the payee's payment format, respectively. Attribute and status handling is provided by POPULATEDOCATTRIBUTES, UPDATEREQUESTSTATUS, and FINALIZESTATUSES. Event and integration support comes from RAISEBIZEVENTS and GETXMLCLOB. Two placeholder hooks, DUMMYCEAPI and DUMMYASGNHOOK, exist as extension points where customer-specific logic may be injected. Parameter lists are intentionally omitted here and should be validated against the current ETRM documentation for the target release.

Tables Accessed

The package reads and writes principal IBY tables through APPS synonyms. IBY_DOCS_PAYABLE_ALL stores the payable documents being assigned and is central to reading document attributes and writing assignment outcomes. IBY_PAY_SERVICE_REQUESTS tracks payment service requests and status transitions. IBY_EXTERNAL_PAYEES_ALL supplies payee and payment format information used in profile resolution, and CE_BANK_ACCOUNTS provides internal bank account data. IBY_EVENT_KEY_S supports business event key generation for RAISEBIZEVENTS. Auxiliary access includes DBMS_XMLQUERY, DUAL, and PLITBLM for XML serialization, singleton queries, and PL/SQL index-by table handling.

Usage Notes

IBY_ASSIGN_PUB is not typically called directly by end users. It is invoked from IBY forms, concurrent programs, and higher-level packages such as IBY_ASSIGNEXT_PUB, IBY_DISBURSE_SINGLE_PMT_PKG, and IBY_DISBURSE_SUBMIT_PUB_PKG, all of which reference it. The user search term "iby_assignext_pub" indicates that custom code integrating with assignment logic should generally target the EXT wrapper, which in turn calls this PUB engine. Direct calls to IBY_ASSIGN_PUB are appropriate only in controlled customizations, and developers should ensure the relevant profile drivers, formats, and payee data are correctly configured before invoking PERFORMASSIGNMENTS.