Results for “period_counter_adjusted”

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

Overview

FA_CURR_DEPRN_ADJ_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite, belonging to the OFA (Oracle Assets) product family. Its documented purpose is to provide the total depreciation adjustment amount for the current open period for each asset within each depreciation book. The view is part of the standard Oracle Assets data model and is available in both release 12.1.1 and 12.2.2, with a status of VALID in the ETRM repository.

Because depreciation adjustments can be triggered by a variety of business events — expense adjustments, reserve adjustments, and group correction or price reserve adjustments — the view normalizes these amounts into a single, signed figure. The view is commonly consumed by reporting layers, custom concurrent programs, and integration extracts that require a consolidated current-period adjustment figure without navigating the raw FA_ADJUSTMENTS structure. It also serves as a convenient reference point for reconciliation between the asset-level adjustment table and period-level depreciation reporting.

Underlying Base Objects

The view is defined over two documented base objects, both accessed via APPS synonyms:

• FA_ADJUSTMENTS — the primary source of adjustment rows. It supplies the ADJUSTMENT_AMOUNT, ADJUSTMENT_TYPE, DEBIT_CREDIT_FLAG, BOOK_TYPE_CODE, ASSET_ID, and PERIOD_COUNTER_ADJUSTED columns used in the SELECT list, WHERE clause, and GROUP BY.
• FA_DEPRN_PERIODS — used in a correlated subquery to identify the most recent (current) period counter for the given book. The subquery selects MAX(PERIOD_COUNTER) filtered by BOOK_TYPE_CODE, ensuring only adjustments belonging to the current period are returned.

Each row in FA_ADJUSTMENTS represents an individual adjustment transaction. The view aggregates these rows by grouping on BOOK_TYPE_CODE, ASSET_ID, and PERIOD_COUNTER_ADJUSTED, thereby collapsing multiple adjustments per asset into a single net figure per book and period.

Key Columns

• CURR_ADJUSTMENT_TOTAL — the summed, sign-adjusted adjustment amount. The sign is derived through nested DECODE logic keyed on ADJUSTMENT_TYPE and DEBIT_CREDIT_FLAG. For EXPENSE adjustments, a CR flag yields a negative amount; for RESERVE, GRP COR RESERVE, and GRP PRC RESERVE, a DR flag yields a negative amount. This produces a signed total consistent with depreciation accounting conventions.
• BOOK_TYPE_CODE — identifies the depreciation book (for example, a corporate or tax book) to which the adjustment belongs.
• ASSET_ID — the unique identifier of the asset, joinable to FA_ADDITIONS and related asset tables.
• PERIOD_COUNTER_ADJUSTED — the period counter of the adjusted period, which in this view equals the maximum period counter for the book, i.e., the current open period.

Common Use Cases and Queries

The view is typically used to report or validate depreciation adjustments for the current period, to feed downstream subledger or GL reconciliations, and to support exception reporting where adjustment activity is unexpected.

Retrieve all current-period adjustments for a specific book:

• SELECT asset_id, book_type_code, curr_adjustment_total FROM apps.fa_curr_deprn_adj_v WHERE book_type_code = 'CORP';

Join to the asset table for descriptive reporting:

• SELECT v.asset_id, a.asset_number, a.description, v.curr_adjustment_total FROM apps.fa_curr_deprn_adj_v v, apps.fa_additions a WHERE v.asset_id = a.asset_id AND v.book_type_code = 'CORP';

Aggregate at the book level for reconciliation totals:

• SELECT book_type_code, SUM(curr_adjustment_total) FROM apps.fa_curr_deprn_adj_v GROUP BY book_type_code;

Because the WHERE clause restricts rows to the current period counter, the view always reflects the open period at query time. Care should be taken when running reports across period-end close, as the underlying period counter will shift as periods are closed and new ones opened.