Search Results jai_retro_tax_changes




Overview
Explore in AI Chat

Overview

The JAI_RETRO_TAX_CHANGES table is a core data object within the JA — Asia/Pacific Localizations product of Oracle E-Business Suite. It resides in the JA schema and is classified as VALID in the ETRM repository for releases 12.1.1 and 12.2.2. The table stores the retroactive tax adjustments applied to document taxes, capturing the before-and-after state of tax amounts whenever a retroactive change is processed against a document line. This makes it the tax-level ledger of retroactive activity, complementing the line-level changes recorded elsewhere in the localization model.

From a modeling perspective, the mined foreign-key structure suggests a Data Vault classification of link. The table principally resolves relationships between two independent entities — the retroactive line change and the tax definition — while also carrying descriptive and additive attributes (such as original and modified amounts) along the link. No physical columns are provided in the metadata beyond those listed, so the link interpretation is offered as a heuristic rather than a definitive classification.

Key Information Stored

The table documents 18 columns. The most significant are summarized below.

The surrogate key is TAX_CHANGE_ID; no separate business-key column is documented, although LINE_CHANGE_ID, TAX_LINE_NO, and TAX_ID together function as the natural composite identifier of a tax change on a line change.

Common Use Cases and Queries

Typical usage centers on audit, reconciliation, and reporting of retroactive tax impacts. A common query retrieves all tax changes for a specific line change:

  • Audit of retroactive tax adjustments per document line — join JAI_RETRO_TAX_CHANGES to JAI_RETRO_LINE_CHANGES on LINE_CHANGE_ID.
  • Tax impact analysis by tax definition — join to JAI_CMN_TAXES_ALL on TAX_ID to aggregate variance between ORIGINAL_TAX_AMOUNT and MODIFIED_TAX_AMOUNT.
  • Recoverability reporting filtered on RECOVERABLE_FLAG and THIRD_PARTY_FLAG.

A representative pattern:

SELECT t.TAX_NAME, t.ORIGINAL_TAX_AMOUNT, t.MODIFIED_TAX_AMOUNT FROM JAI_RETRO_TAX_CHANGES t WHERE t.LINE_CHANGE_ID = :line_change_id;

Related Objects

  • JAI_RETRO_LINE_CHANGES — Parent entity referenced via JAI_RETRO_TAX_CHANGES.LINE_CHANGE_ID → JAI_RETRO_LINE_CHANGES.
  • JAI_CMN_TAXES_ALL — Tax definition referenced via JAI_RETRO_TAX_CHANGES.TAX_ID → JAI_CMN_TAXES_ALL.
  • JAI_RETRO_TAX_CHANGES_PK — Primary key constraint on TAX_CHANGE_ID.
  • JAI_RETRO_TAX_CHANGES_U1 — Unique index on TAX_CHANGE_ID.