Search Results jmf_gta_rule_dffs_all




Overview
Explore in AI Chat

Overview

The table JMF_GTA_RULE_DFFS_ALL is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Supply Chain Localizations module (JMF). Its primary function is to store descriptive flexfield (DFF) segment data associated with Golden Tax Authority (GTA) rule lines. In the context of Chinese tax compliance, GTA rules govern the processing of value-added tax (VAT) invoices. This table enables the extension and customization of rule line attributes beyond the standard application columns, allowing organizations to capture additional, implementation-specific information required for local fiscal reporting and rule processing logic.

Key Information Stored

The table's structure is designed to hold flexfield-specific data linked to individual rule lines. The primary key column, RULE_LINE_ID, uniquely identifies each flexfield record and ties it to a specific line in a GTA rule. The foreign key column, RULE_HEADER_ID, links the flexfield data to its parent rule header stored in JMF_GTA_RULE_HEADERS_ALL. Beyond these key columns, the table contains standard descriptive flexfield columns (e.g., ATTRIBUTE1-20, ATTRIBUTE_CATEGORY) that store the customized segment values. These segments are defined administratively within the application, and their purpose is determined by the specific localization setup.

Common Use Cases and Queries

The primary use case is querying extended attributes for GTA rule lines during tax determination and invoice generation processes. For instance, a report may need to extract all rule lines where a custom segment (e.g., "Special Industry Flag") has a specific value. A common query pattern involves joining this table to its parent rule line table (not explicitly named in the metadata but implied) to retrieve both standard and flexfield data.

SELECT jgrh.rule_name,
       jgrd.rule_line_id,
       jgrdff.attribute1 AS custom_qualifier,
       jgrdff.attribute2 AS custom_rate_code
FROM   jmf_gta_rule_headers_all jgrh,
       jmf_gta_rule_lines_all jgrd, -- Example related line table
       jmf_gta_rule_dffs_all jgrdff
WHERE  jgrd.rule_header_id = jgrh.rule_header_id
AND    jgrdff.rule_line_id = jgrd.rule_line_id
AND    jgrdff.attribute_category = 'CUSTOM_TAX_FIELDS';

Data in this table is typically maintained via the application's GTA rule definition forms, where the descriptive flexfield segments are rendered.

Related Objects

  • JMF_GTA_RULE_HEADERS_ALL: This is the primary parent table, as documented by the foreign key relationship. The column JMF_GTA_RULE_DFFS_ALL.RULE_HEADER_ID references JMF_GTA_RULE_HEADERS_ALL. This relationship ensures that all flexfield data for rule lines is scoped to a valid GTA rule header.
  • JMF_GTA_RULE_DFFS_ALL_PK: The primary key constraint on the RULE_LINE_ID column, guaranteeing uniqueness for each rule line's flexfield record.
  • The metadata suggests the existence of a rule lines table (e.g., JMF_GTA_RULE_LINES_ALL) which would hold the core data for a rule line. The RULE_LINE_ID in JMF_GTA_RULE_DFFS_ALL is almost certainly a foreign key to such a table, though this specific relationship is not detailed in the provided excerpt.