Search Results fa_book_controls_mrc_v




Overview
Explore in AI Chat

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:

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

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.