Search Results tx_taxa_dtl




Overview
Explore in AI Chat

Overview

The TX_TAXA_DTL table is a core transactional data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It serves as the master repository for storing detailed tax rate information, specifically linking tax authorities to applicable items and/or charge classes. Its primary role is to define and maintain the precise tax rates that are applied during financial transactions, such as invoice charges, based on the governing tax authority, the item's tax classification, and the type of charge. The table's existence is critical for ensuring accurate and compliant tax calculations within the manufacturing and logistics processes of Oracle EBS.

Key Information Stored

The table's structure is designed to capture the multi-dimensional nature of tax applicability. Its key columns include the surrogate primary key, TAXRATE_ID, and the composite unique key formed by TAXAUTH_ID, EFFECTIVE_DATE, ICTAX_CLASS, and CHGTAX_CLASS. This unique constraint ensures that only one tax rate is defined for a specific combination of tax authority, effective date, item tax class, and charge tax class. The TAXAUTH_ID links to the master tax authority (TX_TAXA_MST), while ICTAX_CLASS and CHGTAX_CLASS are foreign keys to the item tax classification (IC_TAXN_CLS) and operational charge class (OP_CHRG_CLS) tables, respectively. Other important columns likely include the tax rate percentage and a TEXT_CODE for descriptive notes.

Common Use Cases and Queries

The primary use case is the dynamic determination of the correct tax rate during transaction processing. When a system event, such as creating an invoice charge, requires tax calculation, the application logic queries this table using the known tax authority, item, and charge class to retrieve the effective rate. Common reporting and maintenance queries include identifying all rates for a specific tax authority or validating rate changes over time. A sample query to find current effective rates would be:

  • SELECT taxauth_id, ictax_class, chgtax_class, tax_rate FROM gml.tx_taxa_dtl WHERE effective_date <= SYSDATE AND (end_date IS NULL OR end_date > SYSDATE) ORDER BY taxauth_id;

Data fixes or audits often involve reconciling rates in this detail table with the master tax authority definitions.

Related Objects

TX_TAXA_DTL is centrally connected to several key EBS objects. It is a child table of TX_TAXA_MST (Tax Authority Master) via TAXAUTH_ID. The foreign keys to IC_TAXN_CLS and OP_CHRG_CLS define the tax applicability dimensions. The TEXT_CODE column links to TX_TEXT_HDR for descriptive text. Crucially, it is referenced by the OP_INVC_CHG (Operational Invoice Charges) table, which uses the TAXRATE_ID to store the specific tax rate applied to a transactional invoice line, creating the vital link between master tax rules and actual transaction data.