Results for “fa_ace_books_pk”

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

Overview

FA_ACE_BOOKS is a table in the Oracle Assets (OFA) module, residing in the FA schema, that stores the financial information required for updating the ACE (Asset Capitalization and Expensing) book. In Oracle EBS 12.1.1 and 12.2.2, this table acts as the staging and computation surface where the depreciation attributes of an asset are reconciled against their ACE-book equivalents before the ACE book is refreshed. It supports tax-driven book calculations by holding cost, method, life, prorate convention, and year-to-date/life-to-date depreciation figures in a form the ACE book update process can consume directly.

The ETRM metadata classifies FA_ACE_BOOKS as a link object under the heuristic Data Vault model. This reflects the fact that the table's primary key (ASSET_ID) is also a foreign key to FA_ADDITIONS_B, and its other foreign keys point to reference tables such as FA_METHODS and FA_CONVENTION_TYPES. Functionally, therefore, FA_ACE_BOOKS behaves as a relationship table binding assets to their ACE-specific depreciation parameters rather than as a standalone entity hub or a pure descriptive satellite.

Key Information Stored

The table contains 15 documented columns. The most operationally significant are:

• ASSET_ID — Surrogate and primary key (FA_ACE_BOOKS_PK); also the FK to FA_ADDITIONS_B. It identifies the asset whose ACE book is being computed and is the only true business-key candidate in the documented structure.
• MLC_UPDATE_FLAG — Controls whether the record participates in the MLC (Multi-Ledger Currency) update process for the ACE book.
• COST and ADJUSTED_COST — Original and adjusted acquisition cost for the ACE computation.
• DEPRN_METHOD_CODE — Foreign key to FA_METHODS; identifies the depreciation method applied to the ACE book.
• LIFE_IN_MONTHS — Remaining or total life in months used with DEPRN_METHOD_CODE and PRORATE_CONVENTION_CODE.
• PRORATE_CONVENTION_CODE — Foreign key to FA_CONVENTION_TYPES; determines the prorate convention for the ACE book.
• RATE_ADJUSTMENT_FACTOR, ADJUSTED_RATE, and BASIC_RATE — Rate components used to recompute ACE depreciation.
• YTD_DEPRN and DEPRN_RESERVE — Year-to-date and accumulated depreciation balances carried into the ACE update.
• PRODUCTION_CAPACITY, ADJUSTED_CAPACITY, and LTD_PRODUCTION — Units-of-production and activity-based parameters for the ACE book.

Common Use Cases and Queries

Typical scenarios include verifying which assets are flagged for ACE book update, reconciling ACE cost and depreciation against the corporate book, and troubleshooting method or convention mismatches. A representative query joining the primary reference tables:

• SELECT a.asset_id, a.cost, a.adjusted_cost, a.deprn_method_code, a.life_in_months, a.prorate_convention_code, a.ytd_deprn, a.deprn_reserve FROM fa_ace_books a WHERE a.mlc_update_flag = 'Y';
• Join to FA_METHODS on DEPRN_METHOD_CODE and LIFE_IN_MONTHS to retrieve method descriptions for reporting.
• Join to FA_CONVENTION_TYPES on PRORATE_CONVENTION_CODE to audit prorate conventions used in ACE calculations.
• Join to FA_ADDITIONS_B on ASSET_ID to constrain results to a specific asset number or book.

These patterns are commonly embedded in reconciliation extracts, period-close validations, and tax-book reporting.

Related Objects

The documented foreign keys and primary key identify the following key related objects:

• FA_ADDITIONS_B — Joined on FA_ACE_BOOKS.ASSET_ID = FA_ADDITIONS_B.ASSET_ID; the parent asset definition.
• FA_METHODS — Referenced via DEPRN_METHOD_CODE and LIFE_IN_MONTHS; supplies depreciation method definitions.
• FA_CONVENTION_TYPES — Referenced via PRORATE_CONVENTION_CODE; supplies prorate convention definitions.
• FA_BOOK_CONTROLS and FA_BOOKS — Book-level context used by the ACE update process alongside this table.
• FA_DEPRN_SUMMARY and FA_DEPRN_DETAIL — Depreciation figures reconciled when the ACE book is updated.
• FA_ACE_BOOKS_PK — The primary key constraint enforcing the ASSET_ID uniqueness used by all dependent processes.