Search Results tx_hist_tax




Overview
Explore in AI Chat

Overview

The TX_HIST_TAX table is a legacy data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) product family. According to the official ETRM documentation, its primary stated purpose is that it is "not used in 11i," indicating it was deprecated or rendered obsolete in the 11i release cycle. In the context of releases 12.1.1 and 12.2.2, this table likely persists in the database schema for backward compatibility, potentially holding historical tax-related data from earlier application versions or implementations. Its role is archival rather than transactional, serving as a repository for legacy tax calculation records that may be referenced for historical reporting or compliance audits but is not actively engaged by the core application's tax engine in post-11i environments.

Key Information Stored

The table's structure centers on identifying a specific tax calculation for an invoice within a given tax authority and tax class context. The primary key is a composite of three columns: INVOICE_ID, TAXAUTH_ID, and ICTAX_CLASS. This design suggests it stored granular tax line details. The INVOICE_ID column links to the associated transaction document. The TAXAUTH_ID identifies the governing tax authority, while the ICTAX_CLASS column specifies the item's tax classification code. Although the full column list is not provided in the metadata, the foreign key relationships imply the table would have contained columns for the calculated tax amounts, rates, or other assessment details pertinent to the unique combination of invoice, authority, and class.

Common Use Cases and Queries

Given its deprecated status, direct operational use cases in EBS 12.1.1/12.2.2 are minimal. Its primary utility is for historical data analysis or migration validation. Common queries would involve extracting legacy tax data for reconciliation purposes or populating custom historical reports. A sample query to retrieve this legacy data, joining to the referenced lookup tables, would be:

  • SELECT hist.invoice_id, hist.taxauth_id, auth.taxauth_name, hist.ictax_class, cls.tax_class_name
  • FROM gml.tx_hist_tax hist,
  • gml.tx_taxa_mst auth,
  • gml.ic_taxn_cls cls
  • WHERE hist.taxauth_id = auth.taxauth_id
  • AND hist.ictax_class = cls.tax_class_code
  • AND hist.invoice_id = :p_invoice_id;

Any such queries should be executed with caution, understanding the data may not reflect current tax calculations.

Related Objects

The TX_HIST_TAX table maintains defined foreign key relationships with two other tables in the GML schema, as documented in the ETRM metadata:

  • IC_TAXN_CLS: The relationship is established on the ICTAX_CLASS column (TX_HIST_TAX.ICTAX_CLASS = IC_TAXN_CLS.TAX_CLASS_CODE). This table typically stores valid tax classification codes.
  • TX_TAXA_MST: The relationship is established on the TAXAUTH_ID column (TX_HIST_TAX.TAXAUTH_ID = TX_TAXA_MST.TAXAUTH_ID). This is the master table for tax authorities.

These relationships enforce referential integrity for the authority and class codes stored in each historical tax record. The table is also referenced by its primary key constraint, TX_HIST_TAX_PK.