Results for “deferred_deprn”

4 results




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

Overview

FA.FA_MC_DEFERRED_DEPRN is an MRC (Multiple Reporting Currency) sub-table of FA_DEFERRED_DEPRN within the Oracle Assets (FA) module. It stores currency and financial information about deferred depreciation amounts per asset in each reporting book, and is associated with the corresponding parent record in FA_DEFERRED_DEPRN. Oracle Assets uses this information to generate deferred journal entries to the Reporting Set of Books in Oracle General Ledger.

The object is owned by the FA schema, has a status of VALID, and carries the FND Design Data identifier OFA.FA_MC_DEFERRED_DEPRN. It resides in the APPS_TS_TX_DATA tablespace with PCT Free 10. In the documented physical schema for 12.2.2, the table comprises 15 columns.

From a Data Vault modeling perspective, the mined FK structure suggests a link classification: the table resolves relationships among assets, distributions, book controls, and General Ledger journal headers, functioning as an associative entity rather than a standalone hub or satellite.

Key Information Stored

The table’s documented primary key is FA_MC_DEFERRED_DEPRN_PK, defined on (ASSET_ID, TAX_BOOK_TYPE_CODE, TAX_PERIOD_COUNTER, DISTRIBUTION_ID). This composite key serves as the business-key candidate, uniquely identifying a deferred depreciation record for a specific asset, tax book, period, and distribution. No separate surrogate key column is documented.

The most significant columns include:

  • SET_OF_BOOKS_ID — Reporting set of books identification number for GL sets of books.
  • CORP_BOOK_TYPE_CODE — Corporate depreciation book identifier.
  • TAX_BOOK_TYPE_CODE — Tax depreciation book identifier.
  • ASSET_ID — Asset identification number.
  • DISTRIBUTION_ID — Distribution identification number, linking the deferred amount to a specific asset distribution.
  • DEFERRED_DEPRN_EXPENSE_CCID — Accounting Flexfield combination for deferred depreciation expense.
  • DEFERRED_DEPRN_RESERVE_CCID — Deferred depreciation reserve Accounting Flexfield combination from the tax book and distribution.
  • DEFERRED_DEPRN_EXPENSE_AMOUNT — Deferred depreciation expense amount.
  • DEFERRED_DEPRN_RESERVE_AMOUNT — Deferred depreciation reserve amount.
  • CORP_PERIOD_COUNTER — Deferred depreciation period counter in the corporate book.
  • TAX_PERIOD_COUNTER — Deferred depreciation period counter in the tax book.
  • JE_HEADER_ID, EXPENSE_JE_LINE_NUM, RESERVE_JE_LINE_NUM — Journal header and line references that tie the deferred amounts to generated GL entries.
  • EVENT_ID — Event identifier, indexed for reconciliation with the transaction event model.

Common Use Cases and Queries

Typical use cases include reconciling deferred depreciation by reporting book, generating deferred journal entries to GL, and reporting deferred expense and reserve balances across corporate and tax books. The non-unique indexes support these patterns: FA_MC_DEFERRED_DEPRN_N5 on (EVENT_ID, SET_OF_BOOKS_ID), FA_MC_DEFERRED_DEPRN_N6 on (ASSET_ID, CORP_BOOK_TYPE_CODE, CORP_PERIOD_COUNTER, TAX_BOOK_TYPE_CODE, TAX_PERIOD_COUNTER, SET_OF_BOOKS_ID), and FA_MC_DEFERRED_DEPRN_N7 on (CORP_BOOK_TYPE_CODE, TAX_BOOK_TYPE_CODE, CORP_PERIOD_COUNTER, TAX_PERIOD_COUNTER, SET_OF_BOOKS_ID).

A representative query joining the accounting flexfield combinations:

  • SELECT d.asset_id, d.deferred_deprn_expense_amount, d.deferred_deprn_reserve_amount, c.concatenated_segments FROM fa_mc_deferred_deprn d, gl_code_combinations_kfv c WHERE d.deferred_deprn_expense_ccid = c.code_combination_id AND d.set_of_books_id = :p_sob_id;

Reporting scenarios frequently filter by CORP_PERIOD_COUNTER and TAX_PERIOD_COUNTER to isolate a period, or by ASSET_ID to trace deferred amounts against a single asset. Journal reconciliation joins JE_HEADER_ID to GL_JE_HEADERS and the line numbers to GL_JE_LINES.

Related Objects

The documented foreign keys connect FA_MC_DEFERRED_DEPRN to several parent and reference objects:

  • FA.FA_DEFERRED_DEPRN — Parent table; this is its MRC sub-table.
  • FA.FA_BOOK_CONTROLS — Referenced via CORP_BOOK_TYPE_CODE and TAX_BOOK_TYPE_CODE.
  • FA.FA_ADDITIONS_B — Referenced via ASSET_ID.
  • FA.FA_DISTRIBUTION_HISTORY — Referenced via DISTRIBUTION_ID.
  • GL.GL_CODE_COMBINATIONS — Referenced via DEFERRED_DEPRN_EXPENSE_CCID and DEFERRED_DEPRN_RESERVE_CCID.
  • GL.GL_JE_HEADERS — Referenced via JE_HEADER_ID.
  • GL.GL_JE_LINES — Referenced via JE_HEADER_ID.