Search Results ap_etax_pkg




Overview
Explore in AI Chat

Overview

APPS.AP_ETAX_PKG is a PL/SQL package body in the Oracle E-Business Suite Payables (AP) module that provides the integration layer between Oracle Payables and the Oracle E-Business Tax (EBTax / ETRM) engine. Its principal business function is to support the calculation of transaction taxes on invoices and invoice distributions, and to enable interactive tax quoting before an invoice is finalized. In releases 12.1.1 and 12.2.2, E-Business Tax replaced the legacy tax engine, and Payables components such as the Invoice Workbench invoke this package to obtain tax lines, tax amounts, and applicable tax rules from the ZX (E-Business Tax) schema.

The package is classified with an API classification of OTHER, indicating that it is an internal, engine-facing utility rather than a formally published open interface or public API. It is documented as VALID and is referenced by seventeen other database objects, confirming its role as a foundational internal dependency within the Payables tax call stack.

Key Procedures and Functions

The ETRM metadata documents three procedures or functions within AP_ETAX_PKG:

  • CALLING_ETAX — Invokes the E-Business Tax service to perform tax determination and calculation for a Payables transaction. It typically assembles the tax driver information required by the ETRM engine and hands control to the E-Business Tax services layer.
  • CALCULATE_QUOTE — Supports tax quoting, returning an estimated tax amount for a transaction or distribution without permanently committing the resulting tax lines. This is used for what-if and pre-validation scenarios.
  • CALLETAX — A wrapper entry point that routes the tax calculation request to the E-Business Tax engine, effectively bridging Payables code to the external tax services package.

The metadata does not publish parameter lists for these units, so callers should treat them as internal entry points and should not assume a stable signature across releases.

Tables Accessed

AP_ETAX_PKG reads and writes against the following documented objects, referenced through APPS synonyms:

  • AP_INVOICES_ALL — The invoice header table; supplies invoice-level attributes such as supplier, legal entity, and currency that drive tax determination.
  • AP_INVOICE_LINES_ALL — The invoice line table; provides line-level attributes that determine the applicable tax regime and tax rate.
  • ZX_TRX_HEADERS_GT — A global temporary table belonging to E-Business Tax, used to stage transaction header data for processing by the ETRM engine.
  • DUAL — The standard single-row pseudo-table, used for scalar evaluations within PL/SQL.

The package additionally depends on APP_EXCEPTION, AP_ETAX_SERVICES_PKG, AP_UTILITIES_PKG, FND_MESSAGE and FND_PROFILE, reflecting its use of message-based error handling, profile option lookups, and the downstream tax services layer.

Usage Notes

AP_ETAX_PKG is invoked indirectly through the standard Payables tax call stack rather than being called directly by end users. Typical invocation points include the Invoice Workbench and related forms, the Payables Open Interface import and Invoice Validation concurrent programs, and any custom code that recalculates tax on an existing invoice. Because it interacts with global temporary tables and the E-Business Tax engine, it should be called within the transaction context that owns the invoice and after requisite tax setup, regime-to-rate flows, and party tax profiles are configured. Customizations should call the higher-level E-Business Tax APIs where possible and treat AP_ETAX_PKG strictly as an internal dependency, since its procedures are neither documented as public APIs nor guaranteed to remain stable across patch levels.