Search Results initial_date

Overview

OKX_ASST_BK_CONTROLS_V is a read-only view owned by the APPS schema and registered as VALID in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the OKX — Contracts Integration product family, which provides the integration layer between Oracle Contracts and Oracle Assets. The view exposes control information that applies uniformly to every asset within a given depreciation book, and it is consumed by the Contracts Integration flows to determine whether a book is available for asset-related transactions.

Because the view is a thin projection rather than a stored object, it introduces no physical storage of its own. Instead, it renames and filters columns from Oracle Assets book-level control data so downstream OKX logic can work against a stable, integration-friendly interface. The most significant derived attribute is STATUS, which converts the book's active date range into a single character flag using a nested DECODE over SYSDATE. A book is reported as 'I' (Inactive) when the current date precedes INITIAL_DATE or exceeds DATE_INEFFECTIVE, and as 'A' (Active) otherwise. This derivation is central to the "date_ineffective" search term: DATE_INEFFECTIVE is the source column that governs when a depreciation book stops accepting asset activity.

Underlying Base Objects

The view is defined exclusively over a single documented base object: FA_BOOK_CONTROLS, accessed through a synonym in the APPS schema. FA_BOOK_CONTROLS stores one row per depreciation book and holds the book class, associated depreciation calendar, prorate calendar, and the various mass-copy and mass-change flags. The view performs a one-to-one projection of those rows — no joins, unions, or aggregations are applied — so each row in OKX_ASST_BK_CONTROLS_V corresponds to exactly one depreciation book in FA_BOOK_CONTROLS.

The column mapping is largely literal, with rename exceptions applied for integration compatibility: BOOK_TYPE_CODE appears simultaneously as ID1 and as the NAME and BOOK_TYPE_CODE attributes, while ID2 is a hard-coded literal '#' that acts as a placeholder for the entity identifier convention used by OKX flexfield-style views. INITIAL_DATE maps to START_DATE_ACTIVE and DATE_INEFFECTIVE maps to END_DATE_ACTIVE. PRIMARY_UOM_CODE is returned as a literal NULL because depreciation books have no unit of measure at the book-control level.

Key Columns

• ID1 / ID2 / NAME / DESCRIPTION: Integration key surrogate columns. ID1 carries BOOK_TYPE_CODE; ID2 is a literal '#'; NAME mirrors BOOK_TYPE_CODE and DESCRIPTION mirrors BOOK_TYPE_NAME.
• BOOK_TYPE_CODE: The unique depreciation book identifier used throughout Oracle Assets.
• SET_OF_BOOKS_ID and ORG_ID: Ledger and operating unit context for the book.
• START_DATE_ACTIVE / END_DATE_ACTIVE: Renamed from INITIAL_DATE and DATE_INEFFECTIVE, bounding the period during which the book is available.
• STATUS: Derived flag ('A' active, 'I' inactive) computed from SYSDATE against the active date range.
• DEPRN_CALENDAR / PRORATE_CALENDAR: Calendars governing depreciation and proration for assets in the book.
• BOOK_CLASS / MASS_COPY_SOURCE_BOOK: Tax or corporate classification and the source book for mass copy.
• ALLOW_MASS_CHANGES, ALLOW_MASS_COPY, ALLOW_PURGE_FLAG, ALLOW_REVAL_FLAG: Operational permissions enforced at book level.
• COPY_ADDITIONS_FLAG, COPY_ADJUSTMENTS_FLAG, COPY_RETIREMENTS_FLAG, COPY_SALVAGE_VALUE_FLAG: Mass copy scope controls.
• AMORTIZE_FLAG, FULLY_RESERVED_FLAG, AMORTIZE_REVAL_RESERVE_FLAG: Amortization and reserve treatment indicators.
• LAST_DEPRN_RUN_DATE, LAST_PERIOD_COUNTER, LAST_MASS_COPY_PERIOD_COUNTER: Run-state tracking for depreciation and mass copy.

Common Use Cases and Queries

Typical scenarios include validating whether a book is currently active before permitting contract-driven asset creation, filtering available books for a given ledger, and reporting on book-level control flags.

SELECT book_type_code,
       start_date_active,
       end_date_active,
       status
  FROM apps.okx_asst_bk_controls_v
 WHERE status = 'A';

SELECT book_type_code,
       set_of_books_id,
       deprn_calendar,
       last_deprn_run_date
  FROM apps.okx_asst_bk_controls_v
 WHERE org_id = :p_org_id
   AND allow_mass_copy = 'Y';

Because DATE_INEFFECTIVE drives the STATUS derivation, queries that must surface recently inactivated books should filter on END_DATE_ACTIVE directly rather than relying solely on STATUS, since STATUS is evaluated at query time against SYSDATE.