Search Results settle_net_batch

Overview

FUN_NET_CONC_PROG_PKG is an Oracle Applications (APPS) PL/SQL package that supports the Oracle Receivables netting functionality within Oracle E-Business Suite. Netting allows a trading partner organization to offset open receivable and payable transactions across related operating units, arriving at a single net settlement amount rather than paying and collecting gross balances. This package provides the concurrent-program-facing entry points that drive the lifecycle of a net batch: creating the batch, submitting it for processing, settling the resulting netted balances, and reversing a batch where required. The package serves purely as a concurrent processing wrapper; it does not itself expose a public business API and is not referenced by any other package in the ETRM repository. Its procedures are designed to be attached to concurrent programs that accept a batch identifier parameter and return the standard concurrent request completion values (errbuf and retcode). The package specification carries the header identifier funntcps.pls, version 120.1, indicating it has been stable since the early 12.x releases and is carried forward essentially unchanged into 12.1.1 and 12.2.2.

Key Procedures and Functions

The package specification exposes four procedures, with a fifth documented entry, Generate_Net_Batch, completing the set of netting operations:

• Create_Net_Batch — Builds a net batch for the specified batch identifier. This is the initial processing step that assembles the candidate transactions to be netted for the batch.
• Generate_Net_Batch — Performs the generation of the netted results for the batch, producing the netted transaction lines and settlement amounts from the selected source transactions.
• Submit_Net_Batch — Submits the net batch for approval or downstream processing, moving the batch into a state where settlement can be applied.
• Settle_Net_Batch — Applies the settlement to the net batch, relieving the underlying open receivable and payable items and recording the net settlement. This is the procedure most commonly associated with the search term "settle_net_batch" and is the functional core of the package.
• Reverse_Net_Batch — Reverses a previously processed net batch, restoring the affected transactions for re-processing or correction.

Each procedure follows the standard concurrent program signature, receiving errbuf and retcode as OUT NOCOPY parameters and accepting p_batch_id typed against fun_net_batches_all.batch_id. Parameter lists are not otherwise documented and should not be assumed beyond this concurrent program convention.

Tables Accessed

The package operates against the following tables via APPS synonyms:

• FUN_NET_BATCHES_ALL — The primary net batch table. Batches are identified and updated here, and batch_id supplies the key parameter for every procedure.
• FUN_NET_BATCHES_S — The secondary (translation) table for net batch descriptive attributes.
• FUN_NET_AGREEMENTS_ALL — The netting agreements that govern which trading partners and operating units may be netted, and the rules applied during batch creation and settlement.

Usage Notes

FUN_NET_CONC_PROG_PKG is invoked through Oracle Receivables netting concurrent programs rather than directly from forms or custom code. The standard operational flow is sequential: a batch is created, generated, and submitted, then settled once approved; reversal is used to undo a batch that has been processed in error. In 12.1.1 and 12.2.2 the package behaves identically, the 12.2 online patching model having no impact on this concurrent processing wrapper. Because the package is not referenced by any other package and is not classified as a public API, custom development should not call these procedures directly; instead, customization should invoke the corresponding concurrent programs or build on supported Receivables APIs. The procedures are intended to run in a single transaction controlled by the concurrent manager, with success or failure reported through retcode and errbuf.