Results for “recoverable_flag”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
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.
- TAX_CHANGE_ID — Surrogate primary key, enforced by
JAI_RETRO_TAX_CHANGES_PKand reinforced by unique indexJAI_RETRO_TAX_CHANGES_U1. - LINE_CHANGE_ID — Foreign key linking each tax change to its parent line-level retroactive change in
JAI_RETRO_LINE_CHANGES. - TAX_ID — Foreign key to
JAI_CMN_TAXES_ALL, identifying the tax definition affected. - TAX_LINE_NO — Sequential tax line number, disambiguating multiple taxes on a single line change.
- TAX_NAME and TAX_TYPE — Descriptive denormalized attributes describing the tax applied.
- CURRENCY_CODE — Currency in which the original and modified tax amounts are expressed.
- ORIGINAL_TAX_AMOUNT — The tax amount recorded prior to the retroactive adjustment.
- MODIFIED_TAX_AMOUNT — The tax amount after the retroactive adjustment is applied.
- RECOVERABLE_FLAG — Indicates whether the tax amount is recoverable.
- ADHOC_FLAG and THIRD_PARTY_FLAG — Flags governing ad hoc treatment and third-party tax status.
- OBJECT_VERSION_NUMBER — Optimistic locking column supporting concurrent update control.
- Audit columns: CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.
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_CHANGEStoJAI_RETRO_LINE_CHANGESonLINE_CHANGE_ID. - Tax impact analysis by tax definition — join to
JAI_CMN_TAXES_ALLonTAX_IDto aggregate variance betweenORIGINAL_TAX_AMOUNTandMODIFIED_TAX_AMOUNT. - Recoverability reporting filtered on
RECOVERABLE_FLAGandTHIRD_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.
-
This table is used to store the Retroactive changes made for document taxes
-
This table is used to store the Retroactive changes made for document taxes
-
Stores details of all MISCELLANEOUS distributions added for tax in AP invoice.
-
APPS.ZX_REC_NREC_DIST_QUOTE_V·↳ ZX_LINES_DET_FACTORS·↳ ZX_REC_NREC_DIST·↳ ZX_REC_NREC_DIST_GT·Explore FND module →
-
APPS.ZX_AP_DEF_TAX_EXTRACT_V·↳ ZX_ACCOUNTS·↳ ZX_REC_NREC_DIST·Explore FND module →
-
APPS.ZX_REC_NREC_DIST_QUOTE_V·↳ ZX_LINES_DET_FACTORS·↳ ZX_REC_NREC_DIST·↳ ZX_REC_NREC_DIST_GT·Explore FND module →
-
APPS.ZX_AP_DEF_TAX_EXTRACT_V·↳ ZX_ACCOUNTS·↳ ZX_REC_NREC_DIST·Explore FND module →
-
Term History table.
-
Stores recovery expense lines and recovery expense line allocations information.
-
Payment and billing terms defined in a lease
-
Stores details of all MISCELLANEOUS distributions added for tax in AP invoice.
-
View: PN_LOC_ACC_MAP_V 12.2.2
Stores the information for mapping of expense accounts to the location.
APPS.PN_LOC_ACC_MAP_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ PN_LOCATIONS·Explore PN module →
-
This global temporary table is used to cache tax distributions during tax processing for transactions.
-
Stores recovery expense lines and recovery expense line allocations information.
-
This table is used by the payment module to store the details for each payment worksheet. The records that are created in this table are dependent on the value of the profile Pay by Transaction. When this profile is set to Y(es), the data i
-
Stores the information for mapping of expense accounts to the location.
-
Term History Form View.
APPS.PN_PAYMENT_TERMS_HISTORY_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore PN module →
-
View: PN_PAYMENT_TERMS_V 12.2.2
Form view used to input payment terms information
APPS.PN_PAYMENT_TERMS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore PN module →
-
This table is used by the payment module to store the details for each payment worksheet. The records that are created in this table are dependent on the value of the profile Pay by Transaction. When this profile is set to Y(es), the data i
-
View: PN_LOC_ACC_MAP_V 12.1.1
Stores the information for mapping of expense accounts to the location.
APPS.PN_LOC_ACC_MAP_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ PN_LOCATIONS·Explore PN module →
-
Term History Form View.
APPS.PN_PAYMENT_TERMS_HISTORY_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore PN module →
-
View: PN_PAYMENT_TERMS_V 12.1.1
Form view used to input payment terms information
APPS.PN_PAYMENT_TERMS_V·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ HZ_CUST_ACCOUNTS·Explore PN module →
-
This table stores tax distributions. Each record stores a recoverable or non-recoverable tax distribution line.
-
This global temporary table is used to cache tax distributions during tax processing for transactions.
-
This table stores tax distributions. Each record stores a recoverable or non-recoverable tax distribution line.
-
View: ZX_REC_NREC_DIST_V 12.2.2
APPS.ZX_REC_NREC_DIST_V·↳ ZX_RATES_TL·↳ ZX_REC_NREC_DIST·↳ ZX_REGIMES_TL·Explore FND module →
-
View: ZX_REC_NREC_DIST_V 12.1.1
APPS.ZX_REC_NREC_DIST_V·↳ ZX_RATES_TL·↳ ZX_REC_NREC_DIST·↳ ZX_REGIMES_TL·Explore FND module →
-
Stores the information for mapping of expense accounts to the location.
-
Term History table.
-
Payment and billing terms defined in a lease
-
VIEW: PN.PN_LOC_ACC_MAP_ALL# 12.2.2