Search Results final_netting_report

Overview

FUN_XML_REPORT_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM repository as an "OTHER" API. It belongs to the Funds Capture / netting subsystem of Oracle Payments, where the FUN_ prefix denotes Funds Capture objects. The package provides XML report generation logic for the netting process, producing structured report output that summarizes proposed and final netting activity across payables and receivables transactions. Its role is to assemble data from the netting agreement, batch, and transaction tables together with supporting party and invoice information, and to render that data as XML suitable for reporting or downstream consumption.

The package is listed with a VALID status in both EBS 12.1.1 and 12.2.2. Its only documented external dependency is on the SYS.STANDARD package, reflecting standard PL/SQL language constructs, and no other APPS packages are documented as referencing it, indicating that it is invoked as a standalone reporting utility rather than as a shared library component.

Key Procedures and Functions

Two procedures are documented in the ETRM metadata for this package:

• PROPOSED_NETTING_REPORT — Generates the XML report for proposed netting. This procedure assembles the candidate netting positions before final settlement, drawing on the netting batch and agreement data together with the associated payables invoices and receivables transactions that are under consideration for netting.
• FINAL_NETTING_REPORT — Generates the XML report for final netting. This procedure produces the report reflecting netting that has been finalized, using the same netting structures but reflecting committed results rather than proposals.

No parameter lists are documented in the available metadata; both procedures are described solely by their reporting purpose and their role in the proposed-versus-final stages of the netting cycle.

Tables Accessed

The package accesses its data through APPS synonyms. The core netting tables are:

• FUN_NET_AGREEMENTS_ALL — the netting agreements that define counterparties and netting terms.
• FUN_NET_BATCHES_ALL — the netting batches submitted for processing.
• FUN_NET_AP_INVS_ALL and FUN_NET_AR_TXNS_ALL — the payables invoices and receivables transactions included in each netting batch.
• AP_INVOICES_ALL, RA_CUSTOMER_TRX_ALL, and RA_CUSTOMER_TRX_LINES_ALL — source payables and receivables documents supplying invoice, transaction, and line detail.
• AR_CASH_RECEIPTS_ALL — cash receipt information relevant to receivables settlement.
• HZ_CUST_ACCOUNTS_ALL, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_PARTIES, HZ_PARTY_SITES, and HZ_LOCATIONS — TCA party, account, site, and location data used to identify counterparties and their addresses in the report.
• FND_LOOKUP_VALUES — lookup codes and meanings used to translate stored values into descriptive report output.

Usage Notes

FUN_XML_REPORT_PKG is a reporting utility invoked programmatically rather than through a form-level user interface or a directly attached concurrent program. Because no other APPS packages are documented as referencing it, it is typically called from within the Oracle Payments Funds Capture netting flow or from custom code that needs to produce netting reports in XML format for a given batch or agreement. The proposed and final report procedures correspond to the two reporting points in the netting lifecycle: before settlement, to present proposed netting positions for review, and after settlement, to document the finalized results. Developers integrating with this package should treat it as read-oriented reporting logic, since its documented table accesses are primarily the netting, invoice, transaction, and party tables required to render the report body.