Search Results attribute_category_code

Overview

FII_BIS_FANBV_V is an internal database view shipped within the Oracle E-Business Suite Financial Intelligence (FII) module. Its documented purpose is to support the Asset Aging PM Viewer Reports, a class of Oracle Business Intelligence (BIS/PM) dashboards and Oracle Daily Business Intelligence reporting pages that present fixed asset aging and net book value information to financial managers. The view is not exposed as a public interface and is not intended for direct end-user querying; it functions as a reporting data source consumed by the FII/PM viewer layer.

The view projects asset cost, prior-year cost, accumulated depreciation, and net book value by fiscal year, ledger, and organization, aggregated at the asset attribute category level. Because it is delivered as an internal object, it is documented as "Not implemented in this database" in environments where the corresponding FII/BIS patch level is not applied, and it carries no documented owner or base object registration in the ETRM metadata. Its presence therefore depends on the specific FII and Fixed Assets patch set installed.

Underlying Base Objects

Although the ETRM metadata records no referenced base objects, the embedded view text reveals the Fixed Assets (FA) tables over which the view is constructed. The outer query selects from an inline aggregate whose sources include FA_DEPRN_SUMMARY, FA_DEPRN_PERIODS, FA_CALENDAR_TYPES, FA_ADDITIONS, FA_CATEGORY_BOOKS, FA_BOOKS, and FA_BOOK_CONTROLS. A correlated subquery within the aggregation additionally references FA_DEPRN_PERIODS, FA_CALENDAR_TYPES, FA_ADDITIONS, FA_CATEGORY_BOOKS, FA_BOOK_CONTROLS, and FA_BOOKS to derive the prior-year acquisition cost.

The join logic is driven by BOOK_CLASS = 'CORPORATE' and by DATE_INEFFECTIVE IS NULL, restricting results to active corporate books. Assets are linked through CATEGORY_ID between FA_CATEGORY_BOOKS and FA_ADDITIONS, and the depreciation calendar is aligned through CALENDAR_TYPE across FA_CALENDAR_TYPES and FA_BOOK_CONTROLS. Period reconciliation uses LAST_PERIOD_COUNTER and NUMBER_PER_FISCAL_YEAR to identify the correct closing period.

Key Columns

• NUM_YEAR / FISCAL_YEAR — The fiscal year of the depreciation period; NUM_YEAR is the numeric form used for ordering, while FISCAL_YEAR is the character representation.
• REPORT_DATE — SYSDATE at query execution, labeling the reporting snapshot.
• ORG_ID / SET_OF_BOOKS_ID / BOOK_TYPE_CODE — Organization, ledger, and book identifiers sourced from FA_BOOK_CONTROLS, enabling multi-organization and multi-ledger reporting.
• ATTRIBUTE_CATEGORY_CODE — The Descriptive Flexfield context on the asset (FA_ADDITIONS), used to group or classify assets for aging analysis. This is the column most commonly referenced when users search on "attribute_category_code."
• ACQ_RET_ACTIVITY — Current cost less prior-year cost, representing acquisition and retirement activity.
• PY_COST / COST — Prior-year and current cost, divided by 1000 to present amounts in thousands.
• DEPRECIATION — Accumulated depreciation reserve divided by 1000.
• NET_BOOK_VALUE — Cost less accumulated depreciation, divided by 1000.

Common Use Cases and Queries

The view is typically consumed by the Asset Aging PM Viewer report to trend asset balances by category and flexfield context. Analysts reconstructing similar logic can query it directly for verification:
SELECT fiscal_year, org_id, book_type_code, attribute_category_code, cost, depreciation, net_book_value FROM fii_bis_fanbv_v WHERE set_of_books_id = :ledger ORDER BY fiscal_year, attribute_category_code;

Because amounts are scaled by 1000, downstream reports must multiply accordingly or disclaim the unit of measure. Given the internal and undocumented nature of the view, sites should treat it as subject to change across FII patches and validate column availability before building dependent extracts.