Search Results create_net_batch

Overview

The FUN_NET_CONC_PROG_PKG package is a public PL/SQL API within the Oracle E-Business Suite Financials product family, owned by the APPS schema. Its name and procedure set indicate that it provides the concurrent-program entry points for the netting functionality in Oracle Receivables and Oracle Payables — the process that consolidates offsetting receivable and payable balances between trading partners into a single net settlement obligation. The package is classified as OTHER in the ETRM 12.2.2 metadata and is documented in source control under RCS header funntcps.pls 120.1, last updated 2006/01/05, which places its core logic in the 11i era with continued applicability through 12.1.1 and 12.2.2.

Each routine in the package is a standard concurrent-program wrapper: it accepts the obligatory errbuf and retcode OUT parameters required by every Oracle Application Object Library concurrent program, plus a single p_batch_id input typed as fun_net_batches_all.batch_id%TYPE. The package therefore acts as the programmatic surface through which a netting batch is created, submitted, settled, reversed, and generated as a batch operation.

Key Procedures and Functions

• CREATE_NET_BATCH — Creates a new netting batch record. It is the entry point invoked to instantiate a batch header row in FUN_NET_BATCHES_ALL prior to populating the netting lines. The p_batch_id passed by the caller identifies the batch to be built.
• SUBMIT_NET_BATCH — Submits an existing batch for processing. This routine drives the netting calculation and validation stages that assemble offsetting receivable and payable transactions into the batch.
• SETTLE_NET_BATCH — Settles a processed netting batch, applying the net amount against the participating transactions.
• REVERSE_NET_BATCH — Reverses a previously created or settled batch, undoing the netting entries and restoring the original transaction states.
• GENERATE_NET_BATCH — Documented in the ETRM metadata but not present in the source excerpt shown; its name indicates it generates the netting batch content, likely orchestrating the selection of transactions that qualify for netting.

All five routines share the same signature shape: errbuf OUT, retcode OUT, and p_batch_id IN. No other parameters are documented and none should be assumed.

Tables Accessed

• FUN_NET_BATCHES_ALL — The primary base table holding netting batch headers. All procedures read or write batch definitions keyed by batch_id.
• FUN_NET_AGREEMENTS_ALL — Stores the netting agreements between trading partners that govern which transactions may be netted. CREATE and GENERATE logic reads this table to determine valid netting relationships.
• FUN_NET_BATCHES_S — The sequence or intersection table associated with FUN_NET_BATCHES_ALL, used to generate batch identifiers.

Access is via APPS synonyms, consistent with the package being owned by APPS and callable from custom code as APPS.FUN_NET_CONC_PROG_PKG.

Usage Notes

This package is typically invoked as the executable for concurrent programs registered in the System Administrator responsibility. The errbuf/retcode pattern confirms that its routines are designed to be called from the concurrent manager. It may also be called from Oracle Forms, from custom PL/SQL, or from workflow. The ETRM metadata records that no other packages reference it, so it is a top-level entry point rather than a shared utility. When migrating from 12.1.1 to 12.2.2, note that the package remains available; however, netting is a legacy Receivables/Payables feature and customers should confirm whether it is enabled in their configuration before relying on it.