Search Results check_control_table

Overview

APPS.AP_IMPORT_UTILITIES_PKG is a shared technical utility package within the Oracle E-Business Suite Payables (AP) module. It provides the low-level plumbing used by the Payables open interface and related import processes to move invoice, batch, and distribution data from the interface tables into the base application tables, and to capture validation or processing failures for later review. Rather than exposing a single end-user business API, the package aggregates a collection of helper routines that open interface programs, validation packages, eTax processing packages, retro pricing routines, and vendor utilities all call upon. In an Oracle EBS 12.1.1 or 12.2.2 environment the object resides in the APPS schema and holds VALID status, meaning it is a supported, compiled component referenced by nine dependent packages, including AP_IMPORT_INVOICES_PKG, AP_IMPORT_VALIDATION_PKG, AP_ETAX_SERVICES_PKG, AP_RETRO_PRICING_PKG, AP_UTILITIES_PKG, AP_VENDOR_PUB_PKG, and POS_BATCH_IMPORT_PKG. Its primary business role is to support the bulk loading and maintenance of vendor invoices, invoice batches, invoice lines, and their distributions while ensuring referential data such as vendors, pay sites, employees, and periods are resolved correctly.

Key Procedures and Functions

The package exposes approximately thirty documented procedures and functions. The import and persistence routines include INSERT_AP_INVOICES, INSERT_AP_BATCHES, INSERT_AP_INVOICE_LINES, and UPDATE_AP_BATCHES, which write header, batch, and line data into the base Payables tables, together with INSERT_REJECTIONS and UPDATE_TEMP_INVOICE_STATUS, which record rows that fail import into the rejections interface. Status management is handled by CHANGE_INVOICE_STATUS.

Data lookup and resolution helpers include GET_BATCH_ID, GET_INVOICE_INFO, GET_INFO, GET_TOLERANCE_INFO, GET_DOC_SEQUENCE, FIND_VENDOR_PRIMARY_PAYSITE, GET_EMPLOYEE_ID, and GET_AUTO_BATCH_NAME, each returning contextual keys or default values required during import. Matching and accrual-related functions such as GET_OVERBILL_FOR_SHIPMENT and GET_OVERBILL_FOR_PO_LINE compute overbilled quantities for receipts and purchase order lines. Utility routines include CHECK_CONTROL_TABLE, PRINT, and PA_FLEXBUILD, the last supporting key flexfield construction for project-related accounting. Parameter lists are not reproduced here; consumers should reference the package specification directly.

Tables Accessed

Through APPS synonyms the package reads and writes the central Payables interface and base tables. Interface tables AP_INVOICES_INTERFACE, AP_INVOICE_LINES_INTERFACE, AP_INTERFACE_CONTROLS, and AP_INTERFACE_REJECTIONS hold staged and rejected records. Base tables AP_INVOICES, AP_INVOICES_ALL, AP_INVOICES_S, AP_BATCHES_ALL, AP_BATCHES_S, AP_BATCHES_S2, AP_INVOICE_LINES, AP_INVOICE_LINES_ALL, and AP_INVOICE_DISTRIBUTIONS store the accepted invoices, batches, lines, and distributions. Period-validation tables AP_OTHER_PERIODS and AP_OTHER_PERIOD_TYPES are queried to confirm open periods before posting.

Usage Notes

AP_IMPORT_UTILITIES_PKG is not invoked directly by end users. It is called internally by the Payables Open Interface Import concurrent program and its supporting validation and eTax packages, by retroactive pricing utilities, and by batch import logic such as POS_BATCH_IMPORT_PKG. Custom integrations that populate the Payables interface tables should rely on the standard import programs rather than calling these utilities directly, since the routines assume that validation and control-row setup have already occurred. Oracle no longer recommends direct calls to internal APIs; the supported extension point is the documented open interface.