Results for “get_release”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

ZX_TAX_TAXWARE_REV is a small utility package within the Oracle E-Business Tax (EB Tax) module, owned by the APPS schema and classified as OTHER in the ETRM repository. Its name reflects its role as the Taxware revision or release identification component of the ZX Taxware integration layer. Oracle E-Business Tax supports third-party tax engines through the Tax Service Provider architecture, and Taxware (now part of Sovos) is one of the historically supported external providers. The ZX_TAX_TAXWARE_* family of packages encapsulates the interface between EB Tax and the Taxware calculation engine resident outside the EBS database.

This particular package is deliberately minimal. Its sole documented purpose is to expose the Taxware revision level in use for the installed integration, allowing the Taxware adapter and its diagnostic or auditing layers to record and compare the release of the vendor interface bundle. It does not calculate tax; it identifies which revision of the Taxware connectivity code is deployed. The source header shows a single shipped version, 120.1, last updated in January 2006 under the 12.0 code line, which carried forward into 12.1.1 and 12.2.2 without functional change. The AUTHID CURRENT_USER declaration indicates the package executes with the privileges of the calling schema rather than the definer, which is typical for thin utility packages that do not require elevated data access.

Key Procedures and Functions

The package exposes exactly one documented function:

• GET_RELEASE — Returns a VARCHAR2 value identifying the release or revision of the Taxware adapter code. Callers use this value to log, display, or validate the version of the third-party integration currently installed. No parameter list is documented for this function in the ETRM metadata, and none should be assumed beyond a no-argument invocation returning a version string.

Because the package body is not represented in the documented metadata beyond this signature, no other subprograms should be attributed to it. The function is a straightforward metadata accessor with no documented side effects.

Tables Accessed

The ETRM metadata lists two database objects reached through APPS synonyms:

• ZX_TAX_TAXWARE_010 — Belongs to the Taxware integration schema family, where the numeric suffix typically denotes a versioned or generation-specific table in the Taxware interface. The revision package likely references it to relate the returned release string to installed configuration data.
• ZX_TRX_PRE_PROC_OPTIONS_GT — A global temporary table used in transaction pre-processing option handling. Its presence indicates the package participates, at least incidentally, in the options-resolution path that precedes tax calculation on a transaction.

The metadata does not discriminate between read and write access; the function's read-only nature and naming suggest these objects are queried, not modified.

Usage Notes

ZX_TAX_TAXWARE_REV is invoked indirectly. The ETRM metadata records that it is referenced by one other package, meaning it is consumed programmatically rather than through a form or concurrent program of its own. In practice, the Taxware adapter packages call GET_RELEASE when composing diagnostic output, writing audit rows, or validating that the expected adapter version is active before submitting a tax calculation request. Custom extensions integrating with Taxware may also call it for logging. Given the AUTHID CURRENT_USER setting, any schema invoking the package needs appropriate EXECUTE privileges and select access to the referenced synonyms. No direct end-user entry point exists.