Results for “allow_impairment_flag”

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

Overview

FA_MC_BOOK_CONTROLS is an Oracle Assets (OFA) table that stores control information governing the behavior of a reporting (multi-currency / MRC) depreciation book. It is the reporting-book counterpart to FA_BOOK_CONTROLS, which holds the equivalent control rows for the primary asset books. Each row in FA_MC_BOOK_CONTROLS corresponds to a single combination of depreciation book (BOOK_TYPE_CODE) and General Ledger set of books (SET_OF_BOOKS_ID), and the settings recorded on that row apply uniformly to every asset assigned to that reporting book. The table is therefore a controlling reference object rather than a transactional one: it does not record individual asset movements, but it determines whether depreciation and retirement processing may proceed, what currency the reporting book uses, and how results flow to the General Ledger.

Under the heuristic Data Vault classification supplied with the metadata, this object is described as satellite-leaning. In Data Vault modeling terms it is best represented as a satellite attached to a book/set-of-books hub, since the row carries descriptive control attributes (statuses, flags, counters) keyed by the business key rather than by an independently generated surrogate. Modelers should note this is a heuristic suggestion, not a certified classification.

Key Information Stored

The table is owned by the FA schema and contains 24 documented columns in ETRM 12.2.2. The primary key, FA_MC_BOOK_CONTROLS_PK, is a composite business key comprising BOOK_TYPE_CODE and SET_OF_BOOKS_ID; it is not a system-generated surrogate. The most operationally significant columns are:

• BOOK_TYPE_CODE — identifies the reporting depreciation book; part of the primary key and a foreign key to FA_BOOK_CONTROLS.
• SET_OF_BOOKS_ID — the GL set of books in which the reporting book resides; part of the primary key and a foreign key to GL_SETS_OF_BOOKS_11I.
• CURRENCY_CODE — the reporting book's operational currency, validated against FND_CURRENCIES.
• PRIMARY_SET_OF_BOOKS_ID and PRIMARY_CURRENCY_CODE — identify the source primary book and its currency from which reporting-book values are derived.
• DEPRN_STATUS and DEPRN_REQUEST_ID — control and identify the depreciation run for the reporting book.
• LAST_DEPRN_RUN_DATE and LAST_PERIOD_COUNTER — track the most recent depreciation execution and its period.
• CURRENT_FISCAL_YEAR — the fiscal year currently open for the reporting book.
• RETIRED_STATUS, RETIRED_REQUEST_ID, SOURCE_RETIRED_STATUS, and SOURCE_RETIRED_REQUEST_ID — govern retirement processing, including status propagated from the source book.
• ENABLED_FLAG, CONVERSION_STATUS, and MRC_CONVERTED_FLAG — indicate whether the book is active and whether MRC conversion has been performed.
• NBV_AMOUNT_THRESHOLD, MASS_REQUEST_ID, ALLOW_IMPAIRMENT_FLAG, and GL_POSTING_ALLOWED_FLAG — control threshold-based processing, mass request identification, impairment entry, and GL posting eligibility.

Common Use Cases and Queries

Typical scenarios include verifying that a reporting book is enabled and converted before running period-close processes, reconciling the last depreciation run date against expectations, and confirming GL posting is permitted. A representative query retrieves control state for one reporting book:

SELECT book_type_code, set_of_books_id, currency_code,
       deprn_status, last_deprn_run_date, current_fiscal_year,
       gl_posting_allowed_flag, enabled_flag
FROM   fa_mc_book_controls
WHERE  book_type_code = :book
AND    set_of_books_id = :sob;

A second pattern joins to GL_SETS_OF_BOOKS_11I to display readable ledger names alongside the control flags, and a third compares the primary and reporting rows side by side to detect configuration drift between FA_BOOK_CONTROLS and FA_MC_BOOK_CONTROLS. Reporting use cases include depreciation-status dashboards across reporting books, retirement-status exception reports (RETIRED_STATUS versus SOURCE_RETIRED_STATUS), and an audit of books where ENABLED_FLAG is set but GL_POSTING_ALLOWED_FLAG is not.

Related Objects

• FA_BOOK_CONTROLS — joined on BOOK_TYPE_CODE; the primary-book control row that the reporting row mirrors.
• FA_MC_BOOKS — joined on BOOK_TYPE_CODE and SET_OF_BOOKS_ID; defines the reporting book itself.
• FA_MC_RETIREMENTS — joined on BOOK_TYPE_CODE and SET_OF_BOOKS_ID; retirement transactions governed by this table's status columns.
• GL_SETS_OF_BOOKS_11I — joined on SET_OF_BOOKS_ID and PRIMARY_SET_OF_BOOKS_ID; supplies ledger context.
• FND_CURRENCIES — joined on CURRENCY_CODE and PRIMARY_CURRENCY_CODE; provides currency validation and descriptions.
• FA_BOOKS and FA_MC_ASSETS — reporting-book asset records that depend on the control settings defined here.