Search Results jmf_gta_trx_headers_all




Overview
Explore in AI Chat

Overview

The JMF_GTA_TRX_HEADERS_ALL table is a core data object within the Oracle E-Business Suite (EBS) module JMF - Supply Chain Localizations. This table serves as the header-level repository for transactions processed under the Global Trade Automation (GTA) framework. Its primary role is to store high-level information about trade-related transactions, such as invoices subject to localization-specific rules, enabling compliance with regional legal and fiscal requirements. The table acts as a central point linking transactional data from the Receivables module to specific GTA business rules and detailed line-level information.

Key Information Stored

The table's structure is designed to capture essential header attributes for a GTA transaction. Its primary key is the system-generated identifier, GTA_TRX_HEADER_ID. Critical foreign key columns establish vital relationships with other EBS entities. The RA_TRX_ID links the GTA header to its source transaction in the RA_CUSTOMER_TRX_ALL table, while RULE_HEADER_ID references the governing rule defined in JMF_GTA_RULE_HEADERS_ALL. Customer and billing information is maintained via BILL_TO_CUSTOMER_ID, which references HZ_CUST_ACCOUNTS. The transactional currency is stored in RA_CURRENCY_CODE, linked to FND_CURRENCIES. Collectively, these columns provide the contextual framework for all associated line-level details stored in the related lines table.

Common Use Cases and Queries

The primary use case for this table is reporting and auditing of transactions that have been processed through GTA rules for localization compliance. A common query pattern involves joining the header to its lines and source invoice to analyze rule application. For instance, to retrieve all GTA transactions for a specific customer, one might use:

  • SELECT gta_header.gta_trx_header_id, gta_header.ra_trx_id, cust.account_number, rule.rule_name FROM jmf_gta_trx_headers_all gta_header JOIN hz_cust_accounts cust ON gta_header.bill_to_customer_id = cust.cust_account_id JOIN jmf_gta_rule_headers_all rule ON gta_header.rule_header_id = rule.rule_header_id WHERE cust.account_number = 'CUST123';

Another critical scenario is tracing the lifecycle of a specific invoice through the GTA system by querying this table using the RA_TRX_ID from Oracle Receivables.

Related Objects

JMF_GTA_TRX_HEADERS_ALL is a central node within a network of related objects. It has a direct one-to-many relationship with JMF_GTA_TRX_LINES_ALL, which holds the detailed line items for each header. As indicated by its foreign keys, it is fundamentally dependent on data from several key EBS tables: RA_CUSTOMER_TRX_ALL (transaction source), JMF_GTA_RULE_HEADERS_ALL (applied business rule), HZ_CUST_ACCOUNTS (trading partner), and FND_CURRENCIES. This structure ensures that GTA transactions are fully integrated with the core financial and customer master data of the EBS system.