Search Results get_batch_status

Overview

APPS.FUN_NET_CANCEL_PKG is a PL/SQL package in the Oracle E-Business Suite Applications schema (APPS) that supports the Funds Netting (FUN) module. Its principal business function is to reverse or cancel netting batches — the consolidated settlements that aggregate offsetting intercompany and intercompany-adjacent receivable and payable transactions into a single net payment or receipt. The package operates on the central netting batch repository, FUN_NET_BATCHES and its _ALL companion, and orchestrates the corresponding financial reversals across both Oracle Payables and Oracle Receivables, as well as the General Ledger period context required for posting. It is classified as an "OTHER" API in the ETRM metadata, meaning it is not part of the mainstream FUN public API set but is a supporting utility used by the Netting concurrent program infrastructure and by the Netting cancellation flows. It is referenced by one other package (FUN_NET_CONC_PROG_PKG) and depends on FND_API, indicating it uses the standard EBS API error-handling and return-status conventions.

Key Procedures and Functions

The documented package exposes six procedures/functions, each handling one stage of the cancellation/reversal lifecycle:

• GET_BATCH_STATUS — Retrieves the current status of a netting batch, allowing callers to determine whether a batch is eligible for cancellation or reversal before attempting the operation.
• VALIDATE_BATCH_STATUS — Validates the batch status against the permitted states for cancellation/reversal, returning an error if the batch cannot be processed (for example, if it is already cancelled or locked by another process).
• DELETE_AP_INVS — Removes or reverses the Accounts Payable invoice records associated with the netting batch, working against FUN_NET_AP_INVS and FUN_NET_AP_INVS_ALL.
• DELETE_AR_TXNS — Removes or reverses the Accounts Receivable transaction records associated with the netting batch, working against FUN_NET_AR_TXNS.
• CANCEL_NET_BATCH — The primary entry point that cancels a netting batch, coordinating the deletion of AP invoices and AR transactions and updating the batch and agreement records.
• REVERSE_NET_BATCH — Reverses a netting batch, typically creating offsetting entries in Receivables (cash receipts) and restoring the underlying AP/AR balances, rather than simply deleting them.

Tables Accessed

The package reads and writes several core FUN and adjacent module tables via APPS synonyms. FUN_NET_BATCHES and FUN_NET_BATCHES_ALL hold the netting batch header and line data being cancelled. FUN_NET_AGREEMENTS stores the netting agreements that govern the batch. FUN_NET_AP_INVS and FUN_NET_AP_INVS_ALL contain the AP invoice records linked to the batch, and FUN_NET_AR_TXNS the AR transactions. AR_CASH_RECEIPTS_ALL and AR_CASH_RECEIPT_HISTORY are accessed to reverse or record the cash receipt side of the netting settlement. FND_APPLICATION supplies application context. GL_LEDGERS and GL_PERIOD_STATUSES determine the ledger and open period required to post reversals, with DUAL and PLITBLM used for utility lookups. Together these tables allow the package to unwind the netting flow across both subledgers and the ledger period layer.

Usage Notes

FUN_NET_CANCEL_PKG is typically invoked by the Funds Netting concurrent program package FUN_NET_CONC_PROG_PKG when a user cancels a netting batch from the Netting Batch form or runs a cancellation/reversal request. Because it is classified as an "OTHER" API and lacks a fully documented public interface, it is intended primarily for internal EBS use. Custom code should call it cautiously, always invoking VALIDATE_BATCH_STATUS before CANCEL_NET_BATCH or REVERSE_NET_BATCH, and should observe the FND_API return status to detect errors. Direct DML against FUN_NET_BATCHES is discouraged in favor of this package to preserve data integrity across the AP, AR, and GL layers. When troubleshooting, DBAs commonly trace this package alongside FUN_NET_CONC_PROG_PKG and the FUN_NET_BATCHES family, which is the context in which the search term "fun_net_batches" surfaces this object.