Results for “tx_tloc_asc”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

TX_TLOC_ASC is a GML (Process Manufacturing Logistics) intersection table that defines which tax authorities apply to a given pair of tax locations. In Oracle EBS 12.1.1 and 12.2.2, the table is owned by the GML schema and holds a VALID status in the ETRM repository, confirming it is an active, supported object used by the Process Manufacturing tax determination engine. Its purpose is to bind a tax location (TAXLOC_ID) to one or more tax authorities (TAXAUTH_ID), so that tax calculation can resolve the correct jurisdiction when a transaction originates from, or is destined for, that location.

From a modeling perspective, the heuristic Data Vault classification mined from the foreign key structure is link. This is appropriate because the table resolves a many-to-many relationship between two independent business entities — tax locations and tax authorities — rather than storing descriptive attributes of either entity on its own. The presence of CREATE/UPDATE audit columns and a soft-delete indicator (DELETE_MARK) further confirms this role.

Key Information Stored

The table contains 11 documented physical columns. The most important are summarized below.

• TAXLOC_ID — Identifies the tax location. This is the first component of the composite primary key and is a foreign key to TX_TOFR_ASC.
• TAXAUTH_ID — Identifies the tax authority applicable to that location. Second component of the primary key and a foreign key to TX_TAXA_MST.
• CALC_SEQUENCE — Governs the order in which tax authorities are evaluated when more than one authority applies to the same location pair.
• TEXT_CODE — Foreign key to TX_TEXT_HDR, linking to descriptive/explanatory text recorded against the association.
• TRANS_CNT — A concurrency/versioning counter used to detect conflicting updates in the EBS multi-user environment.
• DELETE_MARK — Soft-delete flag; records are logically removed rather than physically deleted.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns recording who created and last modified the row.

The surrogate primary key is the composite TX_TLOC_ASC_PK (TAXLOC_ID, TAXAUTH_ID), which also serves as the documented unique business-key candidate. This guarantees that a given tax authority is registered at most once per tax location, preventing duplicate authority assignments.

Common Use Cases and Queries

The primary use case is tax determination during Process Manufacturing transactions: the application resolves the applicable authorities for a location pair and returns them in CALC_SEQUENCE order for tax computation and reporting.

Typical query to list the tax authorities assigned to a location:

• SELECT t.TAXLOC_ID, t.TAXAUTH_ID, t.CALC_SEQUENCE, t.TEXT_CODE FROM GML.TX_TLOC_ASC t WHERE t.DELETE_MARK = 0 AND t.TAXLOC_ID = :p_taxloc_id ORDER BY t.CALC_SEQUENCE;

Joining to resolve authority names and explanatory text:

• SELECT a.TAXLOC_ID, m.TAXAUTH_ID, m.TAXAUTH_NAME, h.TEXT_CODE FROM GML.TX_TLOC_ASC a JOIN GML.TX_TAXA_MST m ON a.TAXAUTH_ID = m.TAXAUTH_ID LEFT JOIN GML.TX_TEXT_HDR h ON a.TEXT_CODE = h.TEXT_CODE WHERE a.DELETE_MARK = 0;

Reporting patterns include audits of tax authority coverage per location, verification that no location pair is missing an authority, and reconciliation of ordered calculation sequences. Because correct filtering on DELETE_MARK is essential, all operational queries should exclude logically deleted rows unless historical analysis is intended.

Related Objects

The following objects are the most significant dependencies, each confirmed by the documented relationships.

• TX_LOCN_ASC / TX_TOFR_ASC — Provides the tax location master referenced by TX_TLOC_ASC.TAXLOC_ID; the assigned authorities of a location pair are resolved through this link.
• TX_TAXA_MST — Tax authority master table referenced by TX_TLOC_ASC.TAXAUTH_ID; supplies authority names and attributes used in tax computation.
• TX_TEXT_HDR — Header table for explanatory text referenced by TX_TLOC_ASC.TEXT_CODE.

Collectively, these relationships position TX_TLOC_ASC at the intersection of location, authority, and descriptive metadata within the GML tax model, making it a key link object for both tax determination logic and compliance reporting in Oracle EBS 12.1.1 and 12.2.2.