Search Results ar_gta_rule_headers_all




Overview
Explore in AI Chat

Overview

The AR_GTA_RULE_HEADERS_ALL table is a core data structure within Oracle E-Business Suite Receivables (AR) module, specifically supporting the Global Transfer Accounting (GTA) functionality. It serves as the master repository for header-level definitions of transfer rules. These rules govern the automated creation of intercompany accounting entries, facilitating the transfer of revenue, cost, and receivables between different legal entities or operating units within an organization. The table's role is critical for ensuring compliant and consistent cross-charging and financial reporting in multi-org implementations. As an ALL table, it is partitioned by ORG_ID to store data for multiple operating units, aligning with Oracle's Multi-Org architecture.

Key Information Stored

The table stores the defining attributes for each unique transfer rule. Its primary key is RULE_HEADER_ID, which uniquely identifies a rule across the system. A secondary unique key constraint on the combination of ORG_ID and RULE_NAME ensures rule names are unique within an operating unit. Key descriptive and control columns include RULE_NAME for identification, DESCRIPTION, and SPECIFIC_CURRENCY_CODE (a foreign key to FND_CURRENCIES) which defines the currency to be used for transactions generated by the rule. The table also contains standard Oracle EBS audit columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY to track changes.

Common Use Cases and Queries

Primary use cases involve the setup, maintenance, and auditing of GTA transfer rules. Common activities include generating a list of all active rules for a specific operating unit, validating rule setup before period-end close, and troubleshooting intercompany transaction issues. A typical query retrieves rule header information along with its associated transaction types.

SELECT rule_header_id,
       org_id,
       rule_name,
       description,
       specific_currency_code
FROM ar_gta_rule_headers_all
WHERE org_id = :p_org_id
ORDER BY rule_name;

For reporting and integration purposes, developers often join this table to its child detail tables (AR_GTA_RULE_DFFS_ALL, AR_GTA_RULE_TRX_TYPES_ALL) to get a complete picture of a rule's configuration and its application criteria.

Related Objects

The AR_GTA_RULE_HEADERS_ALL table is central to the GTA rule definition hierarchy. It has direct foreign key relationships with several key child tables that store the rule's detailed components:

  • AR_GTA_RULE_DFFS_ALL: Stores the detailed From and To assignments (e.g., accounts, companies) for the rule, linked by RULE_HEADER_ID.
  • AR_GTA_RULE_TRX_TYPES_ALL: Defines which transaction types (e.g., Invoice, Credit Memo) the rule applies to, linked by RULE_HEADER_ID.
  • AR_GTA_TRX_HEADERS_ALL: References the rule header for transactions that have been generated by the GTA process.
  • FND_CURRENCIES: Validates the SPECIFIC_CURRENCY_CODE used by the rule.

This structure ensures that the rule header acts as the parent record, with its details and applications managed in related transactional tables.