Results for “short_fiscal_year_flag”

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

Overview

FA_EXTENDED_DEPRN_V is an Oracle E-Business Suite view owned by the APPS schema and defined within the OFA (Oracle Assets) product. It consolidates asset descriptive data, depreciation book attributes, transaction header information, and periodic depreciation summary balances into a single denormalized structure. The view is designed specifically for assets subject to the extended depreciation feature, where depreciation continues beyond the point at which an asset becomes fully reserved.

The name "EXTENDED_DEPRN" reflects its primary filter: the view selects assets where depreciation has been extended beyond normal useful life. This is particularly relevant for tax books or regulatory environments that permit or require depreciation to continue past the original cost basis. Because the view joins books, transaction headers, depreciation periods, and depreciation summaries, it supports reporting and integration scenarios that need a combined snapshot of an asset's extended depreciation state, including the short fiscal year attribute captured by the SHORT_FISCAL_YEAR_FLAG column.

Underlying Base Objects

The ETRM metadata documents the view as being defined over the following synonym references: FA_ADDITIONS_B, FA_ADDITIONS_TL, FA_ADJUSTMENTS, FA_BOOKS, FA_DEPRN_PERIODS, FA_DEPRN_SUMMARY, and FA_TRANSACTION_HEADERS. The view text joins these objects on ASSET_ID and BOOK_TYPE_CODE, providing a multi-table perspective of a single asset-book combination.

• FA_ADDITIONS_B / FA_ADDITIONS_TL — Supply the asset number, description, asset type, and attribute category.
• FA_BOOKS — Supplies depreciation method, life, cost basis, prorate convention, rates, salvage value, and the SHORT_FISCAL_YEAR_FLAG, which is a column of FA_BOOKS carried into the view.
• FA_TRANSACTION_HEADERS — Provides the transaction name and amortization start date associated with the asset's active transaction.
• FA_DEPRN_SUMMARY — Provides depreciation reserve, year-to-date depreciation, revaluation reserve, and revaluation expense amounts.
• FA_DEPRN_PERIODS — Supplies the depreciation period name and is used to constrain the results to open or unclosed periods.
• FA_ADJUSTMENTS — Referenced in metadata as a base object, reflecting adjustment-related dependency in the underlying definition.

Key Columns

Prominent columns exposed by the view include ASSET_NUMBER, DESCRIPTION, ASSET_TYPE, BOOK_TYPE_CODE, and DATE_PLACED_IN_SERVICE. Depreciation attributes include DEPRN_METHOD_CODE, LIFE_IN_MONTHS, COST, ORIGINAL_COST, SALVAGE_VALUE, PRORATE_CONVENTION_CODE, DEPRECIATE_FLAG, BASIC_RATE, and ADJUSTED_RATE.

• SHORT_FISCAL_YEAR_FLAG — The column referenced in the user's search. It originates in FA_BOOKS and indicates whether the asset's book is subject to a short fiscal year, affecting depreciation calculation timing.
• EXTENDED_DEPRN_FLAG and EXTENDED_DEPRECIATION_PERIOD — Identify assets flagged for extended depreciation and the associated extension period.
• DEPRN_RESERVE, YTD_DEPRN, REVAL_RESERVE, YTD_REVAL_DEPRN_EXPENSE — Periodic depreciation and revaluation balances from FA_DEPRN_SUMMARY.
• PERIOD_NAME — The depreciation period associated with the summary record.
• FULLY_RSVD_REVALS_COUNTER, PERIOD_COUNTER_FULLY_RESERVED — Track the fully reserved state used to determine extended depreciation eligibility.

Common Use Cases and Queries

The view is most useful for reporting on fully reserved assets that continue to depreciate under the extended depreciation feature, and for diagnostics involving the SHORT_FISCAL_YEAR_FLAG to confirm short fiscal year treatment.

A representative query filtering on the extended depreciation and short fiscal year flags:

• SELECT asset_number, book_type_code, short_fiscal_year_flag, extended_deprn_flag, deprn_reserve, ytd_deprn FROM fa_extended_deprn_v WHERE extended_deprn_flag = 'Y';
• SELECT asset_number, book_type_code, short_fiscal_year_flag FROM fa_extended_deprn_v WHERE book_type_code = 'CORP';

Typical scenarios include reconciling extended depreciation balances, auditing short fiscal year treatment across books, and feeding downstream reporting or interface programs that require a combined asset-book-period record without writing custom multi-table joins.