Search Results ap_ai_table_handler_pkg




Overview
Explore in AI Chat

Overview

AP_AI_TABLE_HANDLER_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its name follows the AP_AI naming convention associated with Oracle Payables' invoice interface and inbound invoice processing infrastructure, where "AI" denotes Application Invoicing — the internal mechanism by which validated invoice data is written into the Payables base tables. The package functions as a low-level data manipulation handler, providing centralized insert, update, and delete operations against the core Payables invoice tables. It is classified in the ETRM as an OTHER API rather than a public, supported extension API, indicating that it is an internal implementation artifact invoked by other Payables components rather than by customer-facing integration code.

The package status is VALID in the APPS schema, and its dependency map is intentionally narrow: it references only SYS.STANDARD and is referenced by AP_INVOICES_PKG and, recursively, by itself. This structure confirms that AP_AI_TABLE_HANDLER_PKG sits at the base of the invoice persistence layer, beneath the higher-level AP_INVOICES_PKG interface that Oracle documents for customer use.

Key Procedures and Functions

ETRM documents three procedures on this package, all of which are conventional row-level data manipulation handlers:

  • INSERT_ROW — Creates a new row in the target Payables invoice table. It is used when invoice header, line, distribution, hold, or payment schedule records must be created during inbound invoice processing.
  • UPDATE_ROW — Modifies an existing row in the target table, supporting changes to invoice data after initial persistence.
  • DELETE_ROW — Removes a row from the target table, supporting rollback or cleanup of invoice records.

The procedures take their table target contextually; the specific parameter lists are not published in the ETRM metadata and are not reproduced here. No public functions are documented.

Tables Accessed

The package operates against the principal Payables invoice schema, accessed through APPS synonyms:

Collectively these tables represent the complete invoice document model, which explains why a single handler package is required: consistent, centralized writes across the invoice hierarchy.

Usage Notes

AP_AI_TABLE_HANDLER_PKG is an internal package and is not intended for direct invocation by customer code. It is typically called indirectly through AP_INVOICES_PKG, which is the documented integration point for creating and maintaining invoices programmatically. Higher-level flows that reach this package include the Payables Open Interface import, the Invoice Validation workflow, and Oracle Forms-based invoice entry in the Payables professional forms.

Because it is classified as an OTHER API and the ETRM exposes no public signature, customizations should never call INSERT_ROW, UPDATE_ROW, or DELETE_ROW directly; doing so bypasses validation, distribution generation, and accounting event logic. Any requirement to load invoices should be implemented through the supported AP_INVOICES_PKG interface or the Open Interface tables. Its presence in the dependency chain serves as a useful diagnostic marker when troubleshooting invoice persistence errors in Release 12.1.1 and 12.2.2.