Search Results create_netting_inv_payment

Overview

APPS.AP_PAYMENT_PUBLIC_PKG is a public PL/SQL package in the Oracle E-Business Suite Payables (AP) module. Its primary business function is to support the creation of netting payments: payments that settle offsetting receivable and payable balances between trading partners rather than issuing separate cash disbursements in each direction. The package exposes public procedures that build payment records for netted transactions, allowing Payables to reduce the volume of physical payments and reconcile intercompany or inter-partner balances in a controlled manner. The package is classified as an "OTHER" API within the Oracle ETRM repository, holds a VALID status in the APPS schema, and depends directly on AP_CHECKS_ALL. It is referenced by FUN_NET_ARAP_PKG, confirming its role as a supporting component of the Receivables/Payables netting flow rather than a standalone entry point.

Key Procedures and Functions

Four documented program units are exposed by this package:

• CREATE_NETTING_PAYMENT — Creates a netting payment record in Payables. It is the principal routine used to generate a payment that reflects a netted obligation between parties, driving the insert of the payment header and associated payment data.
• CREATE_NETTING_INV_PAYMENT — Creates the payment or payment-to-invoice association specifically for invoices included in a netting arrangement, linking the netting payment to the invoices it settles.
• GET_DISC_FOR_PMT_SCHEDULE — Returns the discount applicable to a given payment schedule. This supports accurate calculation of the payable amount when a discount is available on an installment.
• GET_DISC_FOR_NETTED_AMT — Returns the discount applicable to a netted amount, enabling the netting logic to apply the correct discount treatment when aggregating offsetting balances.

Parameter lists are not documented in the ETRM metadata and should not be assumed; callers should inspect the package specification in the target environment before use.

Tables Accessed

The package reads and writes a consistent set of Payables tables through APPS synonyms:

• AP_CHECKS_ALL and AP_CHECKS_S — the core payment tables, holding the netting payment header and its surrogate key.
• AP_INVOICES and AP_INVOICES_ALL — invoice details for the invoices being netted.
• AP_PAYMENT_SCHEDULES and AP_PAYMENT_SCHEDULES_ALL — installment schedules used for discount and amount determination.
• AP_INVOICE_PAYMENTS_S — the association between invoices and the payment that settles them.
• AP_SUPPLIER_SITES_ALL and AP_SYSTEM_PARAMETERS — supplier site and Payables setup context.
• FND_DOCUMENT_SEQUENCES and FND_DOC_SEQUENCE_ASSIGNMENTS — document sequence assignment for payment numbering.
• GL_PERIOD_STATUSES — accounting period validation for the resulting payment.
• FND_LOG_MESSAGES — debug and diagnostic logging.
• DUAL and PLITBLM — utility access for scalar evaluation and PL/SQL index-by table handling.

Usage Notes

AP_PAYMENT_PUBLIC_PKG is not normally invoked directly by end users. It is called programmatically by netting logic — notably through its dependent client FUN_NET_ARAP_PKG — and may be reached from concurrent programs or custom extensions that automate netting payment generation. Because it writes to AP_CHECKS_ALL and AP_PAYMENT_SCHEDULES, callers must ensure that Payables system parameters, document sequences, and open GL periods are correctly configured before invocation. The presence of FND_LOG_MESSAGES access indicates support for FND_LOG-based debugging, useful when diagnosing failed netting runs. As the API classification is OTHER, Oracle does not document a supported public interface contract; custom code should therefore validate compatibility against the specific EBS release (12.1.1 or 12.2.2) before relying on these routines in production.