Search Results fun_net_batches_s

Overview

The APPS.FUN_NET_BATCHES_PKG package body is an Oracle E-Business Suite database object that supports netting batch processing within the Oracle Financials Netting module (FUN). Netting enables organizations to offset reciprocal receivables and payables between trading partners and related legal entities, consolidating multiple transactions into a single net settlement. This package encapsulates the core data manipulation logic — insert, update, select, and delete operations — that governs the FUN_NET_BATCHES and FUN_NET_BATCHES_ALL tables, which store the batch header records used during netting execution.

In EBS 12.1.1 and 12.2.2, the object is documented in the ETRM repository as a VALID package body owned by the APPS schema, classified under the OTHER API classification. It is a low-level data access package rather than a public, supported business API, and it is not referenced by any other database object at the dependency level, indicating it is called at runtime by higher-level netting processes rather than serving as a shared dependency.

Key Procedures and Functions

The ETRM metadata documents four procedures within this package body:

• INSERT_ROW — Creates a new netting batch record. This procedure handles the creation of a batch header in the netting batch tables, populating the identifying and descriptive columns required to track a netting run.
• UPDATE_ROW — Modifies an existing netting batch record. It is used to change batch attributes after initial creation, such as status or descriptive fields.
• SELECT_ROW — Retrieves a single batch record by its identifying key. This is the standard query routine used by callers to fetch batch details for display or downstream processing.
• DELETE_ROW — Removes a netting batch record. This procedure is invoked when a batch must be purged, typically during cleanup or rollback scenarios.

These four routines form a conventional CRUD interface over the netting batch entity and are referenced internally by the package body itself.

Tables Accessed

The package body accesses the following objects (through APPS synonyms):

• FUN_NET_BATCHES — The base (non-multi-org) netting batch table, holding batch header information.
• FUN_NET_BATCHES_ALL — The multi-organization variant of the batch table, enabling batch data to be partitioned by operating unit or ledger. The _ALL suffix indicates the table carries an ORG_ID column.
• FUN_NET_BATCHES_S — The sequence used to generate unique batch identifiers. The user's search term fun_net_batches_s corresponds to this sequence, which is a supporting object rather than a table.
• DUAL — Used for singleton value retrieval and sequence-based assignments.

The package also depends on FND_GLOBAL (for session and context values), FND_LOG (for debug logging), and FUN_NET_UTIL (shared netting utilities).

Usage Notes

FUN_NET_BATCHES_PKG is not a public API. It is invoked indirectly by the Oracle Netting forms and concurrent programs that manage batch creation, maintenance, and settlement. Customizations or extensions that need to interact with netting batches should generally call the supported netting APIs rather than this internal package directly, as its interface is not guaranteed across releases.

Because the package is documented as not referenced by any database object, dependencies flow in only one direction — the package depends on its tables, sequences, and FND utilities, but nothing depends on the package. This confirms its role as a leaf-level implementation layer within the Netting module. Organizations extending Netting in 12.1.1 or 12.2.2 should treat FUN_NET_BATCHES_PKG as an internal, version-sensitive object and validate any direct invocations against patch and upgrade activity.