Search Results update_ap_batches

Overview

PO_INVOICES_SV1 is an Oracle E-Business Suite PL/SQL package owned by APPS and classified as an "OTHER" API within the ETRM repository. Its principal business purpose is the automatic creation of Oracle Payables invoices from Oracle Purchasing transaction data. Specifically, the package generates AP invoices against receipt transactions that are combined with either a purchase order or a shipment and billing notice. This automation supports the Pay on Receipt process, allowing payables records to be generated directly from receiving activity rather than requiring manual invoice entry. The package header declares AUTHID CURRENT_USER, meaning that execution privileges and name resolution are evaluated against the calling schema rather than the defining schema. The source header identifies the file as POXIVCRS.pls, with the current revision dated December 4, 2009, and an original creation date of March 19, 1996, by developer SODAYAR.

Key Procedures and Functions

The documented interface exposes nine procedures and functions, of which two are detailed in the supplied source excerpt.

• create_ap_invoices — The primary entry point of the package. It automatically creates AP invoices for receipt transactions combined with a purchase order or shipment and billing notice. It accepts a transaction source, a commit interval controlling batch commit frequency, a shipment header identifier, and an optional aging period that defaults to NULL. The procedure is referenced against design document 857proc.doc.
• get_ap_parameters — A utility procedure that retrieves configuration options defined in the AP_SYSTEM_PARAMETERS and FINANCIAL_SYSTEM_PARAMETERS tables, returning values to the caller through a set of OUT NOCOPY parameters. Documented outputs include the default set of books identifier, base currency code, batch control flag, exchange rate type, multi-currency flag, GL date from receipt flag, discount invoice less tax flag, income tax region and region flag, VAT country code, transfer description flex flag, organization identifier, and the AWT include tax amount flag. The procedure was created in March 1996 and modified by SRIKRISH in July 1999.

The remaining seven documented procedures and functions are catalogued by name in the ETRM metadata but are not described in the available excerpt; their individual signatures and behaviors should be confirmed by inspecting the deployed package specification.

Tables Accessed

The package interacts with a defined set of tables through APPS synonyms. Payables batch data is read and written through AP_BATCHES, AP_BATCHES_ALL, and AP_BATCHES_S, reflecting the invoice batch creation and update activity central to the package's purpose — including the batch update operations associated with the update_ap_batches search term. Invoice and invoice line records are created in AP_INVOICES and AP_INVOICES_ALL, while the interface tables AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE carry data into the Payables open interface. Configuration values are sourced from AP_SYSTEM_PARAMETERS and FINANCIALS_SYSTEM_PARAMETERS. Accounting period validation relies on GL_PERIOD_STATUSES, and messages are resolved via FND_NEW_MESSAGES. Organizational context is derived from HR_ALL_ORGANIZATION_UNITS_TL and HR_ORGANIZATION_INFORMATION, with DUAL used for single-row queries.

Usage Notes

PO_INVOICES_SV1 is typically invoked by Oracle Purchasing concurrent programs and internal workflows that drive invoice creation from receipts, and it is referenced by two other packages within the EBS codebase. Its get_ap_parameters routine supplies Payables setup defaults to calling code that must construct valid invoice batches. The X_commit_interval parameter makes the package suitable for high-volume processing, since it controls how frequently work is committed during batch creation. Customizations should follow the documented specification rather than the body, and any extensions should preserve the AUTHID CURRENT_USER semantics so that privileges continue to resolve against the calling schema.