Search Results gta_trx_number




Overview
Explore in AI Chat

Overview

The AR_GTA_TRX_HEADERS_ALL table is a core data object within Oracle E-Business Suite (EBS) Receivables (AR), specifically designed to support the Global Tax Engine (GTA). It serves as the primary repository for header-level information for invoices processed through the GTA. The table's role is to store the master record for a GTA tax calculation, linking the transactional tax determination to the original source document, typically a Receivables transaction (RA_CUSTOMER_TRX_ALL). Its multi-org structure, indicated by the ORG_ID column, allows it to hold data for all operating units within an EBS instance.

Key Information Stored

The table stores metadata and identifiers that define a GTA invoice header. Critical columns include GTA_TRX_HEADER_ID (the primary surrogate key), GTA_TRX_NUMBER (a unique identifier for the GTA transaction), and RA_TRX_ID, which is the pivotal foreign key linking directly to the CUSTOMER_TRX_ID in RA_CUSTOMER_TRX_ALL. Other significant fields are RULE_HEADER_ID (linking to the applied tax rule from AR_GTA_RULE_HEADERS_ALL), BILL_TO_CUSTOMER_ID (linking to HZ_CUST_ACCOUNTS), and RA_CURRENCY_CODE (linking to FND_CURRENCIES). The SOURCE, GROUP_NUMBER, and VERSION columns support the processing and versioning of tax calculations, particularly for complex scenarios involving adjustments or multiple calculation passes.

Common Use Cases and Queries

A primary use case is tracing the GTA tax calculation details for a specific Receivables invoice, especially during tax reporting, audits, or troubleshooting. The RA_TRX_ID is the most common entry point for such queries. For instance, to retrieve the GTA header information for a known transaction ID:

  • SELECT gta.* FROM ar_gta_trx_headers_all gta WHERE gta.ra_trx_id = <transaction_id> AND gta.org_id = <org_id>;

Another common scenario involves joining to related tables for a comprehensive tax report:

  • SELECT gta.gta_trx_number, gta.ra_trx_id, rct.trx_number, cust.account_number FROM ar_gta_trx_headers_all gta JOIN ra_customer_trx_all rct ON gta.ra_trx_id = rct.customer_trx_id JOIN hz_cust_accounts cust ON gta.bill_to_customer_id = cust.cust_account_id WHERE gta.org_id = <org_id>;

Related Objects

This table is centrally linked to several key EBS objects. Its most critical relationship is with RA_CUSTOMER_TRX_ALL via the RA_TRX_ID foreign key, anchoring the GTA data to the core Receivables transaction. It references master data tables: HZ_CUST_ACCOUNTS for the customer and FND_CURRENCIES for the transaction currency. It also depends on AR_GTA_RULE_HEADERS_ALL for the tax rule applied. Child detail records, such as tax lines, are typically stored in related tables like AR_GTA_TRX_LINES_ALL, which would link back using the GTA_TRX_HEADER_ID. The existence of multiple unique keys (e.g., on RA_TRX_ID, GROUP_NUMBER, VERSION, ORG_ID, SOURCE) underscores its integral role in a complex, versioned tax determination process.