Search Results fun_dist_lines_s




Overview
Explore in AI Chat

Overview

FUN_TRX_PUB is the public PL/SQL package body owned by the APPS schema that supports Oracle E-Business Suite Funds Capture and disbursement transaction processing. It sits within the Funds Disbursement (FUN) module and serves as a published API layer sitting above the private implementation package FUN_TRX_PVT. Its principal role is to accept a transaction (batch) creation request, validate and stage the associated header, line, and distribution records, and hand control to the Funds Capture workflow for downstream processing. The package has been certified as VALID and is classified as a public (PUB) API, meaning it is intended to be called by external consumers such as concurrent programs, forms, or custom code rather than being restricted to internal use within the FUN module.

Key Procedures and Functions

The documented ETRM metadata lists a single public entry point for this package body:

  • CREATE_BATCH — The public API for creating a funds capture or disbursement batch. It serves as the orchestration procedure through which a caller submits a batch request. Internally it validates the incoming data, resolves ledger and legal-entity context, persists the transaction rows into the FUN_TRX_* tables, records any failures in the interface rejection tables, and coordinates message handling via FND_MSG_PUB.

Although only CREATE_BATCH is documented as public, the dependency list shows that FUN_TRX_PUB calls the private package FUN_TRX_PVT for its core implementation logic, and invokes FUN_WF_COMMON, FUN_INITIATOR_WF_PKG, and FUN_TCA_PKG to drive workflow initiation and trading community (TCA) lookups. Error conditions are raised through APP_EXCEPTION and the FND_API utility stack.

Tables Accessed

The package reads from and writes to a well-defined set of FUN and XLE tables, including the sequence-backed primary objects and their interface staging counterparts:

The user search term fun_dist_lines_s corresponds to the distribution line sequence referenced above; it is the sequence that FUN_TRX_PUB relies on when new distribution rows are inserted during batch creation.

Usage Notes

FUN_TRX_PUB is typically invoked from the Funds Capture concurrent programs, from the Receivables and Payments setup forms, and from custom integrations that need to programmatically create a funds capture batch. Because it is a PUB-classified API, custom code may call CREATE_BATCH directly; callers should supply FND_GLOBAL context (application, responsibility, user, and org) before invocation and should inspect the FND_MSG_PUB message stack after the call to detect validation errors. The package is referenced by two other packages in the APPS schema but does not itself reference any object outside the APPS and SYS owners, with the exception of the DUAL and PLITBLM utility objects. When processing interface data, callers should expect rejected rows to be logged in FUN_INTERFACE_REJECTIONS rather than raised as exceptions, allowing batch processing to continue for valid records.