Search Results tx_tloc_cds




Overview
Explore in AI Chat

Overview

The TX_TLOC_CDS table is a master data table within the Oracle E-Business Suite (EBS) Process Manufacturing Logistics (GML) module. Its primary function is to serve as the central repository for Tax Location Codes. These codes are critical identifiers used to define specific geographic or jurisdictional locations for tax calculation and reporting purposes. The table's role is foundational to the tax engine in EBS, particularly within the manufacturing and logistics context, as it provides the reference data that links various transactional and master entities—such as organizations, warehouses, and customers—to their appropriate tax jurisdictions. Its status is VALID, indicating it is an active and supported object within the schemas for both EBS 12.1.1 and 12.2.2.

Key Information Stored

The core data element stored in this table is the Tax Location Code itself. Based on the provided metadata, the primary key for the table is the column TAXLOC_CODE, which is enforced by the primary key constraint TX_TLOC_CDS_PK. This indicates that TAXLOC_CODE is the unique identifier for each record. While the full column list is not detailed in the excerpt, the foreign key relationships imply the presence of at least one other column: TEXT_CODE. This column links to the TX_TEXT_HDR table, suggesting that descriptive text or notes associated with a tax location code can be maintained. The table's purpose is to store these code definitions, which are then referenced across the application.

Common Use Cases and Queries

The primary use case for the TX_TLOC_CDS table is tax determination setup and validation. Common operational and reporting scenarios include validating tax codes assigned to business entities and generating master lists for tax configuration. A fundamental query is to retrieve all defined tax location codes: SELECT TAXLOC_CODE FROM GML.TX_TLOC_CDS ORDER BY TAXLOC_CODE;. For implementation or support tasks, a frequent requirement is to identify which business entities (e.g., warehouses) are using a specific tax location, which involves joining to the foreign key tables: SELECT wh.WAREHOUSE_CODE, tl.TAXLOC_CODE FROM GML.IC_WHSE_MST wh, GML.TX_TLOC_CDS tl WHERE wh.TAXLOC_CODE = tl.TAXLOC_CODE;. This table is also central to troubleshooting tax calculation errors by verifying the existence and assignment of location codes.

Related Objects

The TX_TLOC_CDS table has extensive relationships with other key EBS tables, as evidenced by its foreign keys. It is referenced by master data tables to assign a tax jurisdiction to an entity. Key referencing tables include:

Furthermore, it is integral to the tax rule structure through the TX_TOFR_ASC (Tax Override Freight Association) table, where codes from TX_TLOC_CDS serve as both the origin (TAXLOC_FROM) and destination (TAXLOC_TO) in tax override rules. The descriptive text link is established via the TX_TEXT_HDR table using the TEXT_CODE column.