Search Results prepare_ar_transactions

Overview

FUN_NET_ARAP_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It implements the core processing logic of the Oracle Financials Netting feature, which allows a trading partner relationship between a customer and a supplier within the same legal entity to be settled on a net basis rather than through separate receipt and payment transactions. The package reconciles open Accounts Receivable customer transactions against open Accounts Payable invoices, calculates net balances by currency, creates a netting batch, and drives the settlement of the underlying transactions. In Oracle EBS 12.1.1 and 12.2.2 the package resides in the FUN module and is classified as an OTHER API, meaning it is largely internal to the Netting product and is not published as a general integration interface, although it is referenced by three other packages.

Key Procedures and Functions

The documented procedures divide into setup retrieval, batch preparation, balance calculation, and batch execution groups.

• get_functional_currency — resolves the functional currency context used for netting calculations.
• get_batch_details, get_agreement_details, batch_exists — return BOOLEAN results indicating whether batch and netting agreement data exist and are available for processing. batch_exists accepts the currency code as input.
• insert_batch_record — inserts the netting batch record for a given currency code. This is the routine most commonly sought when tracing how a FUN_NET_BATCHES row is created.
• prepare_ar_transactions and prepare_ap_transactions — assemble the eligible open AR and AP transactions that will participate in netting.
• insert_transactions — writes the selected transactions into the netting batch, taking invoice currency, currency code, and application as inputs.
• calculate_AP_AR_balances, validate_AP_AR_balances, calculate_ar_txn_open_amt — compute and verify the open AP and AR balances and return the amount to net together with a status flag.
• update_batch_status, update_net_balances, update_net_amounts — maintain batch state and net amount values as processing progresses.
• create_net_batch and submit_net_batch — follow the standard FND_API calling convention (p_init_msg_list, p_commit, x_return_status, x_msg_count, x_msg_data) and accept p_batch_id, creating and then submitting the netting batch.
• validate_netting_dates — validates netting dates using the same standard API parameter convention.
• settle_ap_invs and settle_net_batch — perform settlement of the AP invoices and the batch itself.
• get_netting_bank_details — retrieves the bank account information used for the netting settlement payment.

Tables Accessed

The package reads and writes AP, AR, and netting tables through APPS synonyms. FUN_NET_AGREEMENTS and FUN_NET_BATCHES hold netting agreement definitions and batch headers. RA_CUSTOMER_TRX supplies open AR transactions, while AP_INVOICES, AP_INVOICES_ALL, AP_PAYMENT_SCHEDULES, AP_PAYMENT_SCHEDULES_ALL, AP_INV_SELECTION_CRITERIA_ALL, AP_INV_SELECTION_CRITERIA_S, AP_CHECKS, and AP_CHECKS_ALL supply AP invoices, schedules, selection criteria, and payments. CE_BANK_ACCOUNTS and CE_BANK_ACCT_USES_ALL provide bank account details for settlement, XLE_ENTITY_PROFILES identifies the legal entity, and FND_APPLICATION resolves application identifiers.

Usage Notes

FUN_NET_ARAP_PKG is invoked primarily from the Netting concurrent programs and the Netting setup and processing forms in Oracle Financials, with create_net_batch and submit_net_batch forming the entry points for batch generation and execution. Because it is classified as an OTHER API, custom code should generally avoid calling it directly; the supported approach is to use the standard Netting windows and concurrent requests. Where extension code must reference it, developers should rely on the documented procedure names and the FND_API return-status convention rather than on internal parameter details, which may change between 12.1.1 and 12.2.2.