Results for “fa_book_controls_u1”

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

Overview

FA.FA_BOOK_CONTROLS is the master control table of the Oracle E-Business Suite Fixed Assets (FA) module. Each row defines a depreciation book — corporate, tax, or budgetary — and stores the accounting, calendar, and processing rules that govern how that book behaves across the entire asset lifecycle. The table is registered under FND Design Data as OFA.FA_BOOK_CONTROLS and resides in the APPS_TS_TX_DATA tablespace with PCTFREE 10. In the ETRM 12.2.2 physical schema it contains 153 columns and is documented as VALID in both 12.1.1 and 12.2.2.

Because a book control record must exist before any asset can be added, depreciated, adjusted, or retired within that book, this table is effectively the configuration root of the Fixed Assets data model. Its primary key, FA_BOOK_CONTROLS_PK on BOOK_TYPE_CODE, is a natural business key rather than a system-generated surrogate; the unique index FA_BOOK_CONTROLS_U1 enforces the same constraint and is the object referenced in the user's search. Heuristic Data Vault classification of the mined FK structure suggests a hub-leaning object: BOOK_TYPE_CODE is a stable, non-volatile business key referenced by dozens of dependent tables, while the profusion of descriptive columns (accounting flags, JE categories, book attributes) behaves like attached satellite context.

Key Information Stored

The most operationally significant columns are:

• BOOK_TYPE_CODE — VARCHAR2(15), the primary key and the unique business key enforced by FA_BOOK_CONTROLS_U1; joins to virtually every FA transaction table.
• BOOK_TYPE_NAME — the user-facing book name presented in the Books form and reports.
• SET_OF_BOOKS_ID — FK to GL_SETS_OF_BOOKS_11I, linking the FA book to its General Ledger ledger.
• INITIAL_DATE — the first depreciation period for which the book is active.
• DEPRN_CALENDAR — FK to FA_CALENDAR_TYPES, the depreciation calendar governing period generation.
• PRORATE_CALENDAR — FK to FA_CALENDAR_TYPES, controls prorate conventions for mid-period additions.
• BOOK_CLASS — distinguishes books intended for corporate, tax, or other purposes.
• CURRENT_FISCAL_YEAR and FISCAL_YEAR_NAME — track the book's open fiscal year (FK to FA_FISCAL_YEAR).
• LAST_DEPRN_RUN_DATE — the most recent depreciation program run; critical for period-close monitoring.
• GL_POSTING_ALLOWED_FLAG and GL_JE_SOURCE — determine whether and under which source journals post to GL.
• JE_*_CATEGORY columns — ADDITION, ADJUSTMENT, DEPRECIATION, RETIREMENT, RECLASS, REVAL, TRANSFER, DEFERRED_DEPRN and CIP variants, each FK to GL_JE_CATEGORIES_TL.
• ALLOW_MASS_CHANGES, ALLOW_DEPRN_ADJUSTMENTS, ALLOW_REVAL_FLAG, ALLOW_PURGE_FLAG, ALLOW_MASS_COPY — feature flags gating mass maintenance functions.
• DEPRN_STATUS, LAST_PERIOD_COUNTER, INITIAL_PERIOD_COUNTER — drive depreciation processing state.
• DISTRIBUTION_SOURCE_BOOK, MASS_COPY_SOURCE_BOOK — self-referencing FKs enabling book copy and transfer of distribution logic.
• ATTRIBUTE_CATEGORY_CODE, ATTRIBUTE1–15, GLOBAL_ATTRIBUTE1–20, ORG_ID — descriptive flexfield and multi-org support columns.

Common Use Cases and Queries

Typical uses include validating book configuration before period close, determining which books permit mass changes or revaluation, and joining controls to GL to reconcile JE categories. A representative query listing active corporate books and their depreciation calendars:

SELECT fbc.book_type_code, fbc.book_type_name, fbc.deprn_calendar,
       fbc.current_fiscal_year, fbc.last_deprn_run_date
FROM   fa_book_controls fbc
WHERE  fbc.book_class = 'CORPORATE'
AND   (fbc.date_ineffective IS NULL OR fbc.date_ineffective > SYSDATE);

Joining to General Ledger to surface the accounting configuration of a book:

SELECT fbc.book_type_code, gsob.name ledger, fbc.gl_je_source,
       fbc.je_depreciation_category, fbc.allow_reval_flag
FROM   fa_book_controls fbc, gl_sets_of_books gsob
WHERE  fbc.set_of_books_id = gsob.set_of_books_id;

Another frequent pattern is identifying books that have not been depreciated for the current period, which aids month-end close governance. Queries on FA_BOOK_CONTROLS_U1 directly resolve a book by its unique business key.

Related Objects

• FA_BOOKS — asset-level book assignment; joins on BOOK_TYPE_CODE.
• FA_DEPRN_PERIODS — open/closed period tracking per book; joins on BOOK_TYPE_CODE.
• FA_DEPRN_SUMMARY and FA_DEPRN_DETAIL — depreciation balances and detail; joins on BOOK_TYPE_CODE.
• FA_CATEGORY_BOOKS and FA_CATEGORY_BOOK_DEFAULTS — category-to-book defaults; joins on BOOK_TYPE_CODE.
• FA_TRANSACTION_HEADERS — transaction processing per book; joins on BOOK_TYPE_CODE.
• GL_SETS_OF_BOOKS_11I — ledger linkage via SET_OF_BOOKS_ID.
• GL_JE_CATEGORIES_TL — journal category validation for all JE_*_CATEGORY columns.
• FA_CALENDAR_TYPES — calendar validation for DEPRN_CALENDAR and PRORATE_CALENDAR.
• FA_FISCAL_YEAR — fiscal year validation for CURRENT_FISCAL_YEAR.
• FND_CONCURRENT_REQUESTS — referenced by DEPRN_REQUEST_ID, MASS_REQUEST_ID, and CREATE_ACCOUNTING_REQUEST_ID.