Search Results initial_date




Overview
Explore in AI Chat

Overview

APPS.OKX_ASST_BK_CONTROLS_V is a reporting view in Oracle E-Business Suite that exposes the asset book control information stored in the Fixed Assets (FA) module. Despite the OKX (Oracle Contracts) naming prefix, the view is defined entirely over the FA_BOOK_CONTROLS table, which is the definitive repository for depreciation book configuration within Oracle Assets. The view presents one row per asset book and is primarily intended to support reporting, integration, and data-mapping scenarios in which book-level controls must be surfaced through a stable, denormalized interface. It is available in both EBS 12.1.1 and 12.2.2, and the documented metadata for 12.2.2 confirms the same SELECT structure.

The view includes the column FULLY_RESERVED_FLAG, which is the field most frequently sought by users. This flag indicates whether a book is designated to hold fully reserved assets, a control that affects how Oracle Assets treats assets whose net book value has reached their salvage value.

Underlying Base Objects

The view is defined over a single documented base object: FA_BOOK_CONTROLS (referenced through a synonym). No joins, unions, or aggregations are applied; the view is a straightforward projection that renames and, in a few cases, transforms columns from the underlying table. Because it reads directly from FA_BOOK_CONTROLS, data returned by the view reflects the live book configuration at query time and carries no separate persistence of its own. The relationship is strictly one-to-one: each FA_BOOK_CONTROLS row maps to exactly one view row.

Key Columns

Common Use Cases and Queries

The view is commonly used to list active books, confirm book-control settings during implementations, and drive integrations that require book metadata. A typical query to inspect fully reserved books is:

SELECT book_type_code, name, status, fully_reserved_flag, deprn_calendar FROM apps.okx_asst_bk_controls_v WHERE fully_reserved_flag = 'Y';

To list only currently active books:

SELECT book_type_code, name, set_of_books_id, last_deprn_run_date FROM apps.okx_asst_bk_controls_v WHERE status = 'A' ORDER BY book_type_code;

Because the view is a thin projection of FA_BOOK_CONTROLS, it should be treated as read-only reference data; modifications must be performed through the Fixed Assets application or directly against the base table under controlled conditions.