Search Results distribute_import

Overview

APPS.AP_ETAX_SERVICES_PKG is a core Oracle Payables PL/SQL package that provides the tax calculation, distribution, and validation services used throughout the Oracle E-Business Suite Procure-to-Pay flow. Its primary purpose is to integrate external tax engines and Oracle E-Business Tax with the payables invoice lifecycle, ensuring that tax lines are correctly computed, distributed to invoice distributions, and persisted for downstream accounting. The package operates on both standard invoice entry paths and the Payables Open Interface import path, exposing paired procedures such as CALCULATE and CALCULATE_IMPORT, or DISTRIBUTE and DISTRIBUTE_IMPORT, so that interactive forms and bulk import processes share a single, consistent tax engine invocation mechanism.

Key Procedures and Functions

The package exposes 31 documented procedures and functions grouped by functional area:

• Calculation and distribution: CALCULATE and CALCULATE_IMPORT perform tax determination and computation for standard and interface invoices respectively; DISTRIBUTE and DISTRIBUTE_IMPORT proportion tax amounts across invoice distributions and lines.
• Import interface support: IMPORT_INTERFACE orchestrates the tax portion of the Payables Open Interface processing, supported by POPULATE_HEADERS_GT, POPULATE_HEADER_IMPORT_GT, POPULATE_LINES_GT, POPULATE_LINES_IMPORT_GT, POPULATE_TAX_LINES_GT, and POPULATE_DISTRIBUTIONS_GT, which stage invoice data into global temporary tables prior to tax engine calls.
• Validation: VALIDATE_INVOICE and VALIDATE_DEFAULT_IMPORT verify tax configuration and taxable status before calculation proceeds.
• Overrides and adjustments: OVERRIDE_TAX and OVERRIDE_RECOVERY allow manual intervention on calculated tax or recoverability amounts, typically from the invoice entry UI.
• Reversal and correction: REVERSE_INVOICE and MARK_TAX_LINES_DELETED handle cancellations and line-level voiding, while FREEZE_ITM_DISTRIBUTIONS records final tax distribution state.
• Hold management: RELEASE_TAX_HOLDS removes tax-related holds applied to invoices, distinguishing resolution of tax validation failures.
• Mass processing: GLOBAL_DOCUMENT_UPDATE applies tax changes across multiple documents in a single invocation.

Tables Accessed

The package reads and writes the principal Payables invoice tables through APPS synonyms. AP_INVOICES_ALL, AP_INVOICE_LINES_ALL, and AP_INVOICE_DISTRIBUTIONS_ALL (and its _S sequence-backed companion) hold invoice headers, lines, and accounting distributions, with AP_INVOICE_DISTRIBUTIONS and AP_INVOICE_LINES serving as interface views. AP_HOLDS_ALL is used to apply and release tax holds. SUPPLIER and organization context comes from AP_SUPPLIER_SITES_ALL, HR_ALL_ORGANIZATION_UNITS, and FINANCIALS_SYSTEM_PARAMS_ALL, while PO_LINES_ALL provides purchasing match context. AP_BATCHES_ALL supports batch-level interface processing, and AP_ERRORS_GT, AP_EXPENSE_REPORT_LINES_ALL, and AP_EXP_REPORT_DISTS_ALL extend coverage to expense report taxation and error logging.

Usage Notes

AP_ETAX_SERVICES_PKG is invoked indirectly rather than called by end users. It is referenced by 15 Payables packages, including AP_INVOICES_PKG, AP_APPROVAL_PKG, AP_CANCEL_PKG, AP_MATCHING_PKG, AP_IMPORT_INVOICES_PKG, AP_IMPORT_VALIDATION_PKG, AP_HOLDS_PKG, and the ETRM packages AP_ETAX_PKG and AP_ETAX_UTILITY_PKG. Consequently, it executes during invoice entry and validation, approval, matching, cancellation, holds processing, and Payables Open Interface import. Customizations should not call its procedures directly except when reusing the documented import paths; Oracle does not guarantee signature stability across patches or releases. Behavior differs slightly between 12.1.1 and 12.2.2, primarily in E-Business Tax integration depth, so regression testing is advised after upgrades.