Search Results update_header

Overview

ARP_TEST_TAX is a utility package owned by the APPS schema in Oracle E-Business Suite Receivables. Its name and the package-level variable test_description indicate that it is a diagnostic and data-repair utility rather than a production business API. Unlike the standard Receivables APIs such as ARP_PROCESS_TAX or ARP_TAX_VALIDATE, which drive tax calculation and validation during transaction entry, ARP_TEST_TAX is used to inspect and correct tax-related data on existing transactions. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling user rather than the definer, which is typical for internal test and correction routines that must respect the invoker's access to the underlying tables.

Key Procedures and Functions

The package exposes three documented program units, all operating against a specific customer transaction identified by a transaction ID:

• UPDATE_HEADER — A function that takes a customer transaction identifier and returns a BOOLEAN result, with a message returned through an OUT parameter. It updates header-level tax information on the specified transaction, indicating success or failure and passing back a diagnostic message. This is the primary single-transaction correction routine in the package.
• UPDATE_ALL_HEADERS — A procedure that processes headers in bulk. It accepts an optional tax line count parameter with a default of null, allowing the caller to either target all headers or restrict processing based on the number of tax lines present. This is the set-based counterpart to UPDATE_HEADER, suitable for mass correction runs.
• CHECK_DIST — A function that takes a customer transaction identifier and returns a BOOLEAN indicating whether the distribution data for that transaction is consistent. It performs a read-only verification, typically used before or after running the update routines to confirm that tax distributions reconcile correctly.

The absence of an END; terminator in the excerpt is a documentation artifact; the package body and specification are complete objects in the EBS database.

Tables Accessed

The package operates across the core Receivables transaction and tax tables, accessed through APPS synonyms:

• RA_CUSTOMER_TRX and RA_CUSTOMER_TRX_LINES — the transaction header and line records whose tax attributes are examined and updated.
• RA_CUST_TRX_LINE_GL_DIST — the accounting distributions that CHECK_DIST validates and that must remain consistent with any tax adjustment made by the update routines.
• RA_CUST_TRX_TYPES — the transaction type definition, used to qualify which transactions fall within the scope of processing.
• AR_VAT_TAX — the tax code and rate definition table, consulted to confirm the applicable tax treatment for the transaction.
• HZ_CUST_ACCT_SITES and HZ_CUST_SITE_USES — customer account site and site-use records, which determine the ship-to and bill-to locations that in turn drive tax determination.

Usage Notes

ARP_TEST_TAX is not referenced by any other documented package, confirming its status as a standalone utility. Because it is classified as OTHER rather than as a supported public API, it should be invoked only by technical personnel performing targeted diagnostics or corrections, and not from production forms or concurrent programs delivered by Oracle. Typical use is from a custom SQL*Plus or PL/SQL script, often with the test_description variable set to annotate the reason for the run. Any correction should be preceded by a CHECK_DIST call and followed by revalidation of the transaction's distributions. As with all unsupported utilities, changes made by this package bypass standard API validation logic, so a database backup or transaction export is advisable before execution.