Search Results tx_tofr_asc_u1




Overview
Explore in AI Chat

Overview

The TX_TOFR_ASC table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. Its primary function is to define and manage valid pairings between tax locations designated as "ship-from" and "ship-to" points. This association is critical for enabling accurate tax determination and calculation in logistics and distribution processes, particularly for inter-state or inter-jurisdictional transactions within a manufacturing context. The table acts as a control mechanism, ensuring that tax rules are only evaluated for predefined and permissible location combinations, thereby maintaining data integrity and compliance in the tax engine.

Key Information Stored

The table's structure centers on the relationship between two key tax locations and associated descriptive metadata. The primary identifier for each record is the TAXLOC_ID column. The core relationship is defined by the TAXLOC_FROM and TAXLOC_TO columns, which store the identifiers for the originating (ship-from) and destination (ship-to) tax locations, respectively. This pairing is enforced by a unique key constraint (TX_TOFR_ASC_U1). Additionally, the table includes a TEXT_CODE column, which is a foreign key to descriptive text or notes (likely in TX_TEXT_HDR) that can provide further explanation or legal context for the specific location pairing.

Common Use Cases and Queries

This table is primarily referenced during order management, shipping, and tax calculation workflows. When a transaction is initiated, the system queries this table to validate if the combination of the shipment's origin and destination is a recognized pairing for tax purposes. A common query would retrieve all valid destination locations for a given ship-from point, or verify a specific combination. For example:

  • SELECT taxloc_to FROM gml.tx_tofr_asc WHERE taxloc_from = :p_ship_from_loc;
  • SELECT COUNT(*) FROM gml.tx_tofr_asc WHERE taxloc_from = :p_from_id AND taxloc_to = :p_to_id;

Reporting use cases include auditing tax location setup, analyzing distribution networks, and troubleshooting tax calculation errors by identifying missing or invalid location associations.

Related Objects

TX_TOFR_ASC is integrally linked to other tax and location master tables within the GML schema. Its primary foreign key relationships are with the TX_TLOC_CDS table (via both TAXLOC_FROM and TAXLOC_TO columns), which is the master table for tax location codes. It also references the TX_TEXT_HDR table via the TEXT_CODE column for descriptive text. Furthermore, the TX_TLOC_ASC table holds a foreign key reference back to TX_TOFR_ASC.TAXLOC_ID, indicating that this pairing table is a parent to other tax location association records, forming a hierarchical data model for tax location management.