Search Results jai_retro_tax_changes_u1

Overview

The JA.JAI_RETRO_TAX_CHANGES table is a core transactional table within the Oracle E-Business Suite (EBS) Financials for India (JA) localization schema. It stores the retroactive tax adjustments applied to document taxes when a source transaction is amended after the original tax determination occurred. In the Indian localization context, this includes situations where tax rates, tax regimes, or tax applicability changed between the original posting date and a subsequent revision, requiring the system to retain a precise audit trail of both the original and revised tax values.

Under the heuristic Data Vault classification derived from the foreign key structure, this table exhibits the characteristics of a link table. It records associations between a line-level change record (LINE_CHANGE_ID referencing JAI_RETRO_LINE_CHANGES) and a tax definition record (TAX_ID referencing JAI_CMN_TAXES_ALL), while carrying descriptive and measure attributes of the relationship itself. In simpler relational terms, it functions as a child detail table of the retroactive line changes entity.

Key Information Stored

The table is composed of 18 documented columns. The most operationally significant are listed below.

• TAX_CHANGE_ID — Surrogate primary key (NUMBER(22)), uniquely identifying each retroactive tax change record. Documented as the unique index JAI_RETRO_TAX_CHANGES_U1, which is the business-key candidate enforced as unique.
• LINE_CHANGE_ID — Foreign key to JAI_RETRO_LINE_CHANGES, tying the tax change to its parent line-level change and indexed non-uniquely via JAI_RETRO_TAX_CHANGES_N1.
• TAX_ID — Foreign key to JAI_CMN_TAXES_ALL, identifying the tax definition involved; indexed non-uniquely via JAI_RETRO_TAX_CHANGES_N2.
• TAX_LINE_NO — Sequence position of the tax record within its parent document line.
• TAX_NAME and TAX_TYPE — Descriptive attributes of the tax at the time of the change.
• CURRENCY_CODE — Currency in which the tax amounts are expressed.
• ORIGINAL_TAX_AMOUNT — The tax amount before the retroactive adjustment.
• MODIFIED_TAX_AMOUNT — The revised tax amount after the adjustment; the delta between these two columns represents the retroactive impact.
• RECOVERABLE_FLAG, ADHOC_FLAG, THIRD_PARTY_FLAG — Indicator flags governing whether the tax is recoverable, adhoc, or third-party in nature.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard Who columns providing audit lineage.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the framework during concurrent updates.

Common Use Cases and Queries

Typical usage centers on tax reconciliation, audit reporting, and impact analysis of retroactive changes. Join patterns follow the documented foreign keys.

• Retrieving all tax changes tied to a specific line change: join on LINE_CHANGE_ID between JAI_RETRO_TAX_CHANGES and JAI_RETRO_LINE_CHANGES.
• Resolving tax master attributes: join TAX_ID to JAI_CMN_TAXES_ALL.
• Computing net retroactive impact per tax: SUM(MODIFIED_TAX_AMOUNT - ORIGINAL_TAX_AMOUNT) grouped by TAX_ID or TAX_NAME.
• Audit reconciliation filtered on the unique key TAX_CHANGE_ID (via JAI_RETRO_TAX_CHANGES_U1), which permits direct single-row retrieval.
• Reporting recoverable versus non-recoverable retroactive impacts using RECOVERABLE_FLAG.

A representative query pattern is:

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

Related Objects

• JA.JAI_RETRO_LINE_CHANGES — Parent table; joined on LINE_CHANGE_ID.
• JA.JAI_CMN_TAXES_ALL — Tax master definition; joined on TAX_ID.
• JA.JAI_RETRO_TAX_CHANGES_U1 — Unique index on TAX_CHANGE_ID; primary access path.
• JA.JAI_RETRO_TAX_CHANGES_N1 — Non-unique index on LINE_CHANGE_ID; supports parent-driven lookups.
• JA.JAI_RETRO_TAX_CHANGES_N2 — Non-unique index on TAX_ID; supports tax-driven lookups.
• JA.JAI_RETRO_TAX_CHANGES_PK — Primary key constraint on TAX_CHANGE_ID.