Search Results jai_cmn_taxctg_updates




Overview
Explore in AI Chat

Overview

The table JAI_CMN_TAXCTG_UPDATES is a core data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Asia/Pacific Localizations module (product code JA). It functions as a detailed audit and tracking repository for modifications made to tax categories. Tax categories are fundamental to configuring and applying country-specific indirect taxes, such as Goods and Services Tax (GST) or Value-Added Tax (VAT). This table's primary role is to maintain a historical record of every update—whether a rate change, effective date modification, or other attribute adjustment—applied to a tax category, ensuring traceability and supporting compliance reporting.

Key Information Stored

While the full column list is not detailed in the provided metadata, the structure revolves around capturing the "who, what, when, and why" of a tax category change. The primary key, TAX_CATEGORY_UPDATE_ID, uniquely identifies each update record. The critical foreign key column, TAX_CATEGORY_ID, links the update to the specific master tax category defined in the JAI_CMN_TAX_CTGS_ALL table. Other columns typically found in such audit tables would include the old and new values for the changed attribute (e.g., tax rate), the effective start and end dates of the change, the application or source of the update, and standard Oracle EBS audit columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY to track the user and timestamp of the modification.

Common Use Cases and Queries

This table is essential for compliance audits, historical analysis, and troubleshooting tax calculations. A common use case is generating a report of all tax rate changes within a specific period for regulatory filings. Support personnel may query it to identify which tax category update caused a discrepancy in a historical transaction's tax amount. A typical analytical query would join this table to the master tax category table to provide context.

Sample Query Pattern:
SELECT tc.tax_category_code,
tcu.old_tax_rate,
tcu.new_tax_rate,
tcu.effective_date,
tcu.last_updated_by
FROM jai_cmn_taxctg_updates tcu,
jai_cmn_tax_ctgs_all tc
WHERE tcu.tax_category_id = tc.tax_category_id
AND tcu.creation_date BETWEEN :p_start_date AND :p_end_date
ORDER BY tcu.effective_date DESC;

Related Objects

The table JAI_CMN_TAXCTG_UPDATES has a direct and documented dependency on the master tax category definition table. This relationship is enforced by a foreign key constraint.

  • Primary Key: JAI_CMN_TAXCTG_UPDATES_PK on column TAX_CATEGORY_UPDATE_ID.
  • Foreign Key (References): The column TAX_CATEGORY_ID in JAI_CMN_TAXCTG_UPDATES references the primary key of the table JAI_CMN_TAX_CTGS_ALL. This establishes that every update record must be associated with a valid, pre-existing tax category.

This table is likely referenced by various localization-specific reports, interfaces, and potentially by the tax engine itself for validating the active rate for a given historical date.