Results for “total_adjustment_amount”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JL_ZZ_FA_RETIREMNT_ADJS is a table owned by the JL schema (Latin America Localizations) in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores information about retired fixed assets that require inflation adjustment, supporting the localized inflation accounting and adjustment processes mandated by Latin American statutory requirements (for example, Argentine and Mexican inflation adjustment legislation). Records in this table associate a retirement transaction with the depreciation distribution line and the generated journal entry line, providing the audit trail necessary to reconcile the tax and book impact of inflation on asset retirements. The object is documented in ETRM as a VALID base table with a documented physical schema of 17 columns.

Based on the foreign key structure, a heuristic Data Vault classification suggests this table functions as a link entity. It resolves relationships between retirement records, distribution history, and journal entry lines, rather than acting as a standalone hub or a pure descriptive satellite.

Key Information Stored

The primary key of the table is JL_ZZ_FA_RETIREMNT_ADJS_PK, defined on the composite columns RETIREMENT_ID, PERIOD_COUNTER, and DISTRIBUTION_ID. A unique index, JL_ZZ_FA_RETIREMNT_ADJS_U1, covers the same three-column combination, confirming it as the business-key candidate. The most important columns include:

• RETIREMENT_ID — Identifier of the asset retirement transaction, referenced from FA_RETIREMENTS.
• PERIOD_COUNTER — The accounting period against which the adjustment is applied; part of the composite key.
• DISTRIBUTION_ID — The depreciation distribution line affected, referencing FA_DISTRIBUTION_HISTORY.
• ASSET_ID — The fixed asset being retired and adjusted.
• BOOK_TYPE_CODE — The depreciation book in which the adjustment is recorded (for example, a corporate or tax book).
• TRANSACTION_HEADER_ID — The header identifying the originating transaction batch.
• JE_LINE_ID — The journal entry line generated for the inflation adjustment, referencing JL_ZZ_FA_RETIREMNT_JES.
• ORIGINAL_YTD_DEPRECIATION — The year-to-date depreciation amount recorded before the inflation adjustment.
• PERIOD_ADJUSTMENT_AMOUNT — The inflation adjustment amount calculated for the specific period.
• TOTAL_ADJUSTMENT_AMOUNT — The cumulative adjusted amount resulting from the inflation process.
• STATUS — The processing state of the adjustment record.
• RETIRE_REINST_FLAG — Indicates whether the transaction relates to a retirement or a reinstatement.
• LAST_UPDATED_BY / LAST_UPDATE_DATE / CREATED_BY / CREATION_DATE / LAST_UPDATE_LOGIN — Standard Oracle EBS audit "WHO" columns tracking record creation and modification.

Common Use Cases and Queries

Typical use cases include validating inflation adjustment calculations for retired assets, reconciling adjustment journal entries to the general ledger, and reporting on period-by-period adjustment amounts for localization compliance. A representative query joins the table to FA_RETIREMENTS and FA_DISTRIBUTION_HISTORY:

• SELECT a.ASSET_ID, a.BOOK_TYPE_CODE, a.PERIOD_ADJUSTMENT_AMOUNT, a.TOTAL_ADJUSTMENT_AMOUNT FROM JL_ZZ_FA_RETIREMNT_ADJS a WHERE a.PERIOD_COUNTER = :period;
• SELECT r.RETIREMENT_ID, j.JE_LINE_ID, a.ORIGINAL_YTD_DEPRECIATION FROM JL_ZZ_FA_RETIREMNT_ADJS a JOIN FA_RETIREMENTS r ON a.RETIREMENT_ID = r.RETIREMENT_ID JOIN JL_ZZ_FA_RETIREMNT_JES j ON a.JE_LINE_ID = j.JE_LINE_ID;
• SELECT STATUS, RETIRE_REINST_FLAG, COUNT(*) FROM JL_ZZ_FA_RETIREMNT_ADJS GROUP BY STATUS, RETIRE_REINST_FLAG;

These patterns support reconciliation reports, exception auditing for unprocessed adjustments (STATUS), and analysis of the retirement versus reinstatement impact.

Related Objects

The table participates in the following documented foreign key relationships, which define the primary join paths:

• FA_RETIREMENTS — Joined via JL_ZZ_FA_RETIREMNT_ADJS.RETIREMENT_ID = FA_RETIREMENTS.RETIREMENT_ID; the source retirement transaction.
• FA_DISTRIBUTION_HISTORY — Joined via JL_ZZ_FA_RETIREMNT_ADJS.DISTRIBUTION_ID = FA_DISTRIBUTION_HISTORY.DISTRIBUTION_ID; the affected depreciation distribution line.
• JL_ZZ_FA_RETIREMNT_JES — Joined via JL_ZZ_FA_RETIREMNT_ADJS.JE_LINE_ID = JL_ZZ_FA_RETIREMNT_JES.JE_LINE_ID; the inflation adjustment journal entry lines.
• FA_ASSETS — Indirectly referenced through ASSET_ID for asset master validation and reporting.
• GL_JE_LINES — The general ledger destination of the generated adjustment journal entries, useful for GL reconciliation reporting.