Results for “beginning_balance_flag”

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

Overview

FA_BOOKS_GROUPS_MRC_V is an APPS-owned database view in the Oracle E-Business Suite Assets (OFA) module, valid in both 12.1.1 and 12.2.2. It exposes group asset book information for the reporting set of books resolved at runtime from the session context, rather than from a user-supplied bind variable. The view is one of the Multiple Reporting Currencies (MRC) family of objects that Oracle Assets uses to present financial data in a reporting currency alongside the primary ledger. Instead of requiring the caller to pass a set of books identifier, the view derives it from the CLIENT_INFO value maintained by the application, making it suitable for concurrent programs, forms-based queries, and embedded reporting logic that must always return data scoped to the current reporting book.

The view is particularly relevant to users searching for the retirement_pending_flag column, since that flag is exposed directly by this view and is used to identify group assets that have a retirement transaction awaiting processing or confirmation before the retirement is finalized.

Underlying Base Objects

The documented base object for this view is FA_MC_BOOKS_GROUPS, referenced through a synonym, and aliased as IMBG in the view text. FA_MC_BOOKS_GROUPS is the MRC counterpart of the FA_BOOKS_GROUPS table, holding the reporting-currency copy of group asset book balances and attributes. The view definition selects from FA_MC_BOOKS_GROUPS and applies a single filter predicate:

• IMBG.SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'), 45, 10)), -1)

This predicate extracts a ten-character substring beginning at position 45 of the CLIENT_INFO string, converts it to a number, and defaults to -1 when no value is present. The net effect is that the view returns only rows belonging to the set of books currently designated as the reporting context. Because the predicate is applied inside the view, any query against FA_BOOKS_GROUPS_MRC_V is automatically restricted to the active reporting book.

Key Columns

The view projects the complete column list of FA_MC_BOOKS_GROUPS, including identifiers, cost attributes, depreciation tracking columns, and twenty global attribute columns.

• SET_OF_BOOKS_ID, BOOK_TYPE_CODE, GROUP_ASSET_ID — composite key identifying the reporting book, the book type, and the group asset.
• COST, ORIGINAL_COST, SALVAGE_VALUE, ADJUSTED_COST, ADJUSTED_RECOVERABLE_COST, RECOVERABLE_COST — the cost and value basis amounts carried for the group in the reporting currency.
• PERIOD_COUNTER, PERIOD_COUNTER_CAPITALIZED, PERIOD_COUNTER_FULLY_RESERVED, PERIOD_COUNTER_FULLY_RETIRED, PERIOD_COUNTER_LIFE_COMPLETE — depreciation calendar references tracking capitalization, full reservation, full retirement, and life completion.
• RETIREMENT_ID, RETIREMENT_PENDING_FLAG — the retirement reference and the indicator that a retirement is pending for the group asset. The pending flag is the column most commonly used to drive exception reports and reconciliation checks.
• CAPITALIZE_FLAG, COST_CHANGE_FLAG, IDLED_FLAG, BEGINNING_BALANCE_FLAG — status flags controlling capitalization, cost adjustment, idle status, and beginning balance treatment.
• DATE_EFFECTIVE, DATE_INEFFECTIVE — the effective date range for the group row.
• ITC_AMOUNT, ITC_AMOUNT_ID, ITC_BASIS, PERCENT_SALVAGE_VALUE — investment tax credit and salvage percentage attributes.
• TRANSACTION_HEADER_ID_IN, TRANSACTION_HEADER_ID_OUT, YTD_PROCEEDS, LTD_PROCEEDS — transaction linkage and proceeds tracking for additions and retirements.
• Audit and descriptive columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, and GLOBAL_ATTRIBUTE1 through GLOBAL_ATTRIBUTE20.

Common Use Cases and Queries

Typical uses include reporting-currency group asset inquiries, reconciliation between primary and reporting books, and exception reporting around pending retirements. To list group assets with a retirement pending in the current reporting book:

• SELECT group_asset_id, book_type_code, cost, retirement_id, retirement_pending_flag FROM fa_books_groups_mrc_v WHERE retirement_pending_flag = 'Y';
• SELECT group_asset_id, book_type_code, cost, adjusted_cost FROM fa_books_groups_mrc_v WHERE idled_flag = 'Y' ORDER BY book_type_code, group_asset_id;
• SELECT book_type_code, COUNT(*) FROM fa_books_groups_mrc_v GROUP BY book_type_code;

Because the set of books predicate is embedded, results always reflect the reporting context established by the application. Custom concurrent programs or reports that call this view outside of the standard Assets login flow must set CLIENT_INFO appropriately, or no rows will be returned.