Search Results jmf_gta_rule_headers_all




Overview
Explore in AI Chat

Overview

The JMF_GTA_RULE_HEADERS_ALL table is a core data object within the Oracle E-Business Suite (EBS) Supply Chain Localizations module, specifically under the JMF (Joint Management of Funds) product family. It serves as the master definition table for Golden Tax Authority (GTA) rules. These rules are critical for configuring and enforcing region-specific tax and fiscal compliance requirements, particularly in markets like China where electronic invoicing and tax reporting are mandated. The table stores the high-level, reusable parameters and conditions that govern how transactions are processed for GTA compliance, acting as a parent record for more detailed rule components.

Key Information Stored

The table's primary identifier is the RULE_HEADER_ID, which is the primary key for the table and is referenced by numerous child entities. While the provided ETRM metadata does not list all columns, the documented foreign key relationship to FND_CURRENCIES via the SPECIFIC_CURRENCY_CODE column indicates that each rule header can be associated with a particular currency. This suggests the table likely stores other rule-defining attributes such as rule name, description, effective dates (START_DATE, END_DATE), status (e.g., ACTIVE, INACTIVE), rule type, and the operating unit identifier (ORG_ID), inferred from the "_ALL" suffix which denotes multi-organization support.

Common Use Cases and Queries

This table is central to setup, reporting, and troubleshooting for GTA-related processes. Common operational scenarios include validating active rules for a transaction, auditing rule configurations, and generating compliance reports. A typical query would join the rule header to its details and transaction data to analyze rule application.

  • Listing Active Rules for an Operating Unit:
    SELECT RULE_HEADER_ID, NAME, SPECIFIC_CURRENCY_CODE FROM JMF_GTA_RULE_HEADERS_ALL WHERE ORG_ID = 123 AND SYSDATE BETWEEN START_DATE AND NVL(END_DATE, SYSDATE+1);
  • Identifying Rules Used on Transactions:
    SELECT h.RULE_HEADER_ID, h.NAME, COUNT(t.TRX_HEADER_ID) FROM JMF_GTA_RULE_HEADERS_ALL h, JMF_GTA_TRX_HEADERS_ALL t WHERE h.RULE_HEADER_ID = t.RULE_HEADER_ID GROUP BY h.RULE_HEADER_ID, h.NAME;

Related Objects

The JMF_GTA_RULE_HEADERS_ALL table has a central role in the GTA data model, with several key foreign key relationships documented in the ETRM.

  • Parent Reference: FND_CURRENCIES via SPECIFIC_CURRENCY_CODE. This links the rule to a specific currency defined in the application.
  • Child Tables (referenced by RULE_HEADER_ID):
    • JMF_GTA_RULE_DFFS_ALL: Likely stores detailed rule conditions or formulas.
    • JMF_GTA_RULE_TRX_TYPES_ALL: Associates the rule header with specific transaction types it governs.
    • JMF_GTA_TRX_HEADERS_ALL: The transactional table that applies a specific rule header to a business document, providing a direct link from compliance execution back to its governing rule definition.