Search Results tx_taxa_sts




Overview
Explore in AI Chat

Overview

The TX_TAXA_STS table is a core reference data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. It serves as the master repository for tax status codes, which are critical for determining the appropriate tax treatment of transactions within the manufacturing and logistics domain. This table provides a standardized set of statuses that are referenced by transactional and configuration tables to ensure consistent tax calculation and reporting. Its role is foundational to the tax engine's logic in GML, enabling the system to apply correct tax rules based on the status assigned to items, customers, or specific charges.

Key Information Stored

While the provided ETRM excerpt does not list specific columns, the primary key and foreign key relationships define its core structure. The table's primary key is the TAX_STATUS column, which stores the unique identifier for a tax status code. Another significant column is TEXT_CODE, which is referenced by the TX_TEXT_HDR table, suggesting a link to descriptive text or notes associated with the tax status. The table's purpose is to store these code values along with any supporting attributes necessary for tax processing within the GML module.

Common Use Cases and Queries

This table is primarily used in two contexts: setup and transactional processing. During implementation, tax statuses are defined in this table and then associated with various system entities. Common queries involve listing all valid statuses for configuration purposes or validating a status during data entry. For example, a typical validation query would be:

  • SELECT TAX_STATUS FROM GML.TX_TAXA_STS WHERE TAX_STATUS = :p_status_code;

In reporting, this table is joined to transactional data to decode the tax status on invoices or charges. A common reporting pattern involves joining TX_TAXA_STS to the OP_INVC_CHG table to analyze tax applied to invoice charges based on their status.

Related Objects

As per the documented foreign keys, TX_TAXA_STS has direct relationships with several key transactional and setup tables. The primary key (TAX_STATUS) is referenced by:

  • OP_INVC_CHG (Invoice Charges): Links tax status to specific charges on an invoice.
  • OP_TXCU_ASC (Tax Currency Association): Likely associates tax statuses with currency rules.

Furthermore, TX_TAXA_STS references the TX_TEXT_HDR table via its TEXT_CODE column, which stores multilingual descriptive text for the status codes. This relationship is crucial for generating user-facing descriptions in reports and forms.