Results for “revalue_on_retirement_flag”

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

Overview

FA_BOOK_CONTROLS_MRC_V is an APPS-owned view in the Oracle E-Business Suite Fixed Assets (OFA) module. It exposes book control configuration data combined with the multi-reporting-currency (MRC) book control attributes, so that reporting and integration consumers can retrieve, for each reporting book, the accounting setup and depreciation-processing state across the set of books defined in the environment. The "MRC" designation indicates that the view joins the primary book controls with their reporting-currency counterparts. Its documented description in ETRM is simply "- Retrofitted," reflecting that the object was carried forward into the 12.1.1 / 12.2.2 code line to preserve backward compatibility with earlier MRC-based reporting logic.

For users searching on "deprn_status," the relevant column is FMCBC.DEPRN_STATUS, which originates from the multi-currency book controls source and reflects the depreciation status of the reporting book. This makes the view a convenient single source for determining whether depreciation has been run and how each reporting book is positioned in the depreciation cycle.

Underlying Base Objects

Per the documented ETRM metadata for 12.2.2, the view is defined over two referenced base objects:

• FA_BOOK_CONTROLS (SYNONYM) — the primary book definition, supplying book type code and name, initial date, calendar, accounting flexfield structure, journal entry categories and source, and the various control flags.
• FA_MC_BOOK_CONTROLS (SYNONYM) — the multi-currency (reporting) book controls, supplying the SET_OF_BOOKS_ID, LAST_DEPRN_RUN_DATE, CURRENT_FISCAL_YEAR, DEPRN_REQUEST_ID, and DEPRN_STATUS.

The view aliases these as FBC and FMCBC respectively in its defining SQL, joining them to present a unified row per reporting book. Because both are referenced via synonyms, the view resolves through the APPS schema to the underlying OFA tables.

Key Columns

• DEPRN_STATUS (FMCBC.DEPRN_STATUS) — the depreciation status of the reporting book; the column users most frequently query.
• BOOK_TYPE_CODE / BOOK_TYPE_NAME — identifier and descriptive name of the asset book.
• SET_OF_BOOKS_ID — the general ledger set of books associated with the reporting book.
• LAST_DEPRN_RUN_DATE and DEPRN_REQUEST_ID — date and concurrent request reference of the last depreciation run for the reporting book.
• DEPRN_CALENDAR / PRORATE_CALENDAR — depreciation and prorate calendars assigned to the book.
• GL_POSTING_ALLOWED_FLAG, GL_JE_SOURCE — controls governing transfer of depreciation and related journal entries to General Ledger.
• ALLOW_DEPRN_ADJUSTMENTS, ALLOW_MASS_CHANGES, ALLOW_PURGE_FLAG, ALLOW_REVAL_FLAG — configuration flags that gate asset maintenance operations.
• CURRENT_FISCAL_YEAR — the open fiscal year for the reporting book.
• Standard WHO columns — CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The view is typically used to report book-level configuration and depreciation readiness, and to determine whether a book has completed depreciation before downstream close or interface processes. A representative query filtering on the depreciation status is:

• SELECT book_type_code, book_type_name, set_of_books_id, deprn_status, last_deprn_run_date FROM apps.fa_book_controls_mrc_v WHERE deprn_status IS NOT NULL;
• To check open books awaiting depreciation: SELECT book_type_code, deprn_status, last_deprn_run_date FROM apps.fa_book_controls_mrc_v ORDER BY book_type_code;
• To join configuration to asset-level reporting, combine BOOK_TYPE_CODE and SET_OF_BOOKS_ID with asset and depreciation tables for reconciliation.

Because it joins primary and reporting book controls, the view should be used for MRC-aware reporting; single-book environments may return one row per book, while multi-currency environments produce a row per reporting set of books.