Search Results net_amt

Overview

APPS.FUN_NET_ARAP_PKG is the core PL/SQL engine behind Oracle E-Business Suite's Netting functionality, a treasury and cash-management feature used when a single trading partner is simultaneously a customer and a supplier. Its purpose is to offset open Accounts Receivable (AR) transactions against open Accounts Payable (AP) transactions within a legal entity, currency, and netting agreement, and to settle the resulting residual balance. In release 12.1.1 and 12.2.2 the package sits over the FUN_NET_* schema objects and is registered in ETRM under API classification OTHER, meaning it is a supporting internal package rather than a formally published open interface.

The body declares strongly typed record and collection structures that reflect the netting domain. The batch_rec and batch_table types map to FUN_NET_BATCHES_ALL (batch identifier, agreement, ledger currency); the txnRecType record carries AR transaction attributes including transaction_amt, open_amt, txn_curr_open_amt, txn_curr_amt, txn_curr_net_amt, and net_amt (sourced from FUN_NET_AR_TXNS.NETTED_AMT), along with exchange rate, invoice currency, and receipt method. The pymt_sch_rec structure tracks minimum and maximum payment numbers on AP payment schedules. Global batch details and batch list variables maintain state across procedure calls within a session, and FND logging globals provide diagnostic tracing. This design confirms that netting is executed as a multi-step, stateful process: gather, validate, calculate, settle.

Key Procedures and Functions

The documented entry points divide into retrieval, preparation, calculation, validation, and settlement groups.

• GET_FUNCTIONAL_CURRENCY — returns the functional currency for the netting context, establishing the currency basis for balance comparison.
• GET_BATCH_DETAILS — retrieves header attributes for a specified netting batch from FUN_NET_BATCHES.
• GET_AGREEMENT_DETAILS — returns the definition of the netting agreement, which governs eligible partners, currencies, and dates.
• GET_NETTING_BANK_DETAILS — fetches bank account information (CE_BANK_ACCOUNTS, CE_BANK_ACCT_USES_ALL) used to settle the netted residual.
• PREPARE_AR_TRANSACTIONS and PREPARE_AP_TRANSACTIONS — assemble candidate open AR and AP transactions and load them into the FUN_NET_AR_TXNS and corresponding AP netting structures.
• CALCULATE_AR_TXN_OPEN_AMT — determines the remaining open amount per AR transaction, honoring payment schedules and adjustments.
• CALCULATE_AP_AR_BALANCES — aggregates AP and AR positions to derive the net payable or net receivable per partner and currency.
• VALIDATE_AP_AR_BALANCES and VALIDATE_NETTING_DATES — enforce business rules, ensuring balances reconcile and netting dates fall within agreement effective periods.
• INSERT_TRANSACTIONS and INSERT_BATCH_RECORD — persist the netted transaction lines and the batch header.
• UPDATE_NET_BALANCES, UPDATE_NET_AMOUNTS, and UPDATE_BATCH_STATUS — write back calculated net amounts (including the net_amt column family) and advance batch lifecycle status.
• BATCH_EXISTS and CREATE_NET_BATCH — determine whether a batch already exists for the period and create one when absent.
• SETTLE_AP_INVS and SETTLE_NET_BATCH — apply settlement, clearing invoices and the net residual.
• SUBMIT_NET_BATCH — initiates batch processing, typically via concurrent request submission.

Tables Accessed

The package accesses documented APPS synonyms. Netting definition and state reside in FUN_NET_AGREEMENTS and FUN_NET_BATCHES (with the FUN_NET_AR_TXNS ledger of netted AR lines). AR data is read from RA_CUSTOMER_TRX and its lines. AP data is read from AP_INVOICES/AP_INVOICES_ALL, AP_CHECKS/AP_CHECKS_ALL, AP_PAYMENT_SCHEDULES/AP_PAYMENT_SCHEDULES_ALL, and selection criteria tables AP_INV_SELECTION_CRITERIA_ALL and AP_INV_SELECTION_CRITERIA_S. Banking and legal-entity context come from CE_BANK_ACCOUNTS, CE_BANK_ACCT_USES_ALL, and XLE_ENTITY_PROFILES, with FND_APPLICATION used for application context. Reads dominate candidate selection; writes occur on FUN_NET_BATCHES and the netting transaction tables during insert, update, and settlement steps.

Usage Notes

FUN_NET_ARAP_PKG is invoked primarily from the Netting workbench and related concurrent programs in the Oracle Payables/Receivables netting flow, and is referenced by three other packages in the ETRM repository. Because its procedures are not documented as a public API, customizations should call the standard concurrent programs rather than the package directly. The absence of a formal parameter list in the metadata means callers must not assume signatures; the reliable contract is its documented procedure names and the batch lifecycle they implement. Typical usage follows the sequence: create batch, prepare AR and AP transactions, validate balances and dates, calculate net amounts, update net balances, and settle.