Search Results create_ppa_invoice

Overview

APPS.AP_RETRO_PRICING_UTIL_PKG is the utility package body that supports Oracle Payables Retroactive Pricing (RetroPrice) processing within Oracle E-Business Suite 12.1.1 and 12.2.2. Retroactive pricing is invoked when a supplier renegotiates pricing on items already received and invoiced, requiring Payables to generate credit or debit price adjustment documents that reconcile the difference between the original matched invoice amounts and the newly agreed purchase order prices. This package provides the low-level validation, lookup, and interface-population routines that the RetroPrice concurrent programs rely on to construct Price Protection Adjustment (PPA) invoices and their associated distributions and lines.

The package was first created in 2003 (as evidenced by the embedded modification history) and its header revision 120.11 dates to February 2008. It is registered in ETRM as an OTHER classification object owned by APPS, and the documentation records 24 procedures and functions in total. It is referenced by one other package, indicating it functions as a shared utility layer rather than a standalone entry point.

Key Procedures and Functions

The entry point most commonly sought by developers is CREATE_PPA_INVOICE, which builds the retroactive Price Protection Adjustment invoice records, persisting them through the PPA global temporary tables and the invoice interface tables.

The documented procedures and functions fall into several functional groups:

• Validation routines: ARE_ORIGINAL_INVOICES_VALID (documented in detail in the excerpt), ARE_HOLDS_OK, PPA_ALREADY_EXISTS, IPV_DISTS_EXISTS, ERV_DISTS_EXISTS, ADJ_CORR_EXISTS, CORRECTIONS_EXISTS, TIPV_EXISTS, and TERV_DISTS_EXISTS. These determine whether the base matched invoices, holds, and prior adjustment documents satisfy the conditions required before a PPA can proceed.
• Lookup and derivation helpers: GET_INVOICE_DISTRIBUTION_ID, GET_CCID, GET_DIST_TYPE_LOOKUP_CODE, GET_MAX_PPA_LINE_NUM, GET_EXCHANGE_RATE, GET_INVOICE_AMOUNT, and GET_CORRESPONDING_RETRO_DISTID. These retrieve identifiers, exchange rates, amounts, and line-numbering values needed to construct correct adjustment records.
• Data construction routines: CREATE_LINE, GET_BASE_MATCH_LINES, IS_SEQUENCE_ASSIGNED, and the principal CREATE_PPA_INVOICE. GET_BASE_MATCH_LINES extracts the original matched invoice lines, while CREATE_LINE and CREATE_PPA_INVOICE assemble the adjustment invoice header, lines, and distributions.

Parameter lists are not reproduced here; the metadata documents procedure names and purposes only.

Tables Accessed

The package operates against APPS synonyms for the core Payables and Purchasing matching tables. It reads and writes invoice data through AP_INVOICES_ALL, AP_INVOICES_INTERFACE, and AP_INVOICES_S; line-level detail through AP_INVOICE_LINES_ALL, AP_INVOICE_LINES, AP_INVOICE_LINES_INTERFACE, and AP_INVOICE_LINES_INTERFACE_S; and distribution detail through AP_INVOICE_DISTRIBUTIONS_ALL and AP_INVOICE_DISTRIBUTIONS_S. Hold validation uses AP_HOLDS_ALL. Allocation rules are resolved from AP_ALLOCATION_RULE_LINES, and system options from AP_SYSTEM_PARAMETERS_ALL. Finally, the package populates three global temporary tables — AP_PPA_INVOICES_GT, AP_PPA_INVOICE_LINES_GT, and AP_PPA_INVOICE_DISTS_GT — which stage the PPA invoice, line, and distribution rows during assembly before final insertion.

Usage Notes

This package is not intended to be called directly by end users. It is invoked internally by the RetroPrice concurrent programs and by the parent package that references it, which orchestrate the retroactive pricing workflow beginning from the Retro Price Adjustment instruction. Custom code should treat AP_RETRO_PRICING_UTIL_PKG as an internal implementation detail: the supported integration surface is the RetroPrice concurrent program family and the Payables open interface (AP_INVOICES_INTERFACE, AP_INVOICE_LINES_INTERFACE), through which retroactive adjustment documents are ultimately loaded and validated. Because procedural logic in this package may change between patch levels without a change to the public interface, direct invocation is discouraged.