Results for “fa_deprn_periods”

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

Overview

FA_DEPRN_PERIODS is a core table within the Oracle E-Business Suite Fixed Assets module (OFA), owned by the FA schema. It stores information about each depreciation period for every depreciation book defined in the application. In Oracle EBS 12.1.1 and 12.2.2, this table functions as the authoritative calendar of depreciation activity: for each book, it records which accounting periods exist, when they open and close, and whether depreciation and other asset transactions have been run and transferred to General Ledger. Because depreciation, additions, retirements, reclassifications, transfers, revaluations, and Capital In Progress (CIP) events must be tied to a discrete period, FA_DEPRN_PERIODS underpins nearly all periodic asset processing and reporting.

From a dimensional modeling perspective, the ETRM metadata classifies this object heuristically as a hub — that is, a durable business entity with a stable business key around which related data clusters. This is a modeling suggestion only; in EBS terms, it is best understood as a period control table that links book definitions to General Ledger journal batches and to period-keyed asset transaction records.

Key Information Stored

FA_DEPRN_PERIODS contains 27 documented columns. The most functionally significant are:

• BOOK_TYPE_CODE — Identifies the depreciation book; a primary key component and the principal link to book-level configuration.
• PERIOD_COUNTER — The internal surrogate period identifier; combined with BOOK_TYPE_CODE it forms the primary key FA_DEPRN_PERIODS_PK.
• PERIOD_NAME — The accounting period name (e.g., JAN-24); a business-key candidate via unique index FA_DEPRN_PERIODS_U1.
• FISCAL_YEAR and PERIOD_NUM — The fiscal year and period number; together with BOOK_TYPE_CODE they form business-key candidate FA_DEPRN_PERIODS_U2.
• PERIOD_OPEN_DATE and PERIOD_CLOSE_DATE — The open and close dates of the depreciation period.
• DEPRECIATION_BATCH_ID — References the GL_JE_BATCHES batch created by the depreciation run, tying FA to GL.
• DEPRN_RUN and GL_TRANSFER_FLAG — Indicate whether depreciation has been run and whether the resulting journal entries have been transferred to General Ledger.
• ADDITION_BATCH_ID, RETIREMENT_BATCH_ID, RECLASS_BATCH_ID, TRANSFER_BATCH_ID, ADJUSTMENT_BATCH_ID, REVAL_BATCH_ID, and DEPRN_ADJUSTMENT_BATCH_ID — Batch references for the major asset transaction streams.
• DEFERRED_DEPRN_BATCH_ID and the CIP_*_BATCH_ID columns — Batch references for deferred depreciation and Capital In Progress events.
• CALENDAR_PERIOD_OPEN_DATE and CALENDAR_PERIOD_CLOSE_DATE — The corresponding GL calendar dates.

A unique index FA_DEPRN_PERIODS_U3 (BOOK_TYPE_CODE, PERIOD_COUNTER) mirrors the primary key, while U1 and U2 provide alternate business-key candidates. The surrogate key is PERIOD_COUNTER combined with BOOK_TYPE_CODE; PERIOD_NAME and (FISCAL_YEAR, PERIOD_NUM) are the human-readable business keys.

Common Use Cases and Queries

Typical reporting and integration scenarios include determining the current open period for a book, verifying depreciation run status, and reconciling FA-to-GL transfers.

• Find the open period for a book: query where BOOK_TYPE_CODE = :book and PERIOD_CLOSE_DATE is null or greater than SYSDATE.
• Check whether depreciation has run: select DEPRN_RUN, DEPRECIATION_BATCH_ID, GL_TRANSFER_FLAG for a given book and period.
• Obtain the period counter for a period name: select PERIOD_COUNTER where BOOK_TYPE_CODE = :book and PERIOD_NAME = :period, then use it to join FA_DEPRN_SUMMARY or FA_DEPRN_DETAIL.
• Reconcile to GL: join the various *_BATCH_ID columns to GL_JE_BATCHES to confirm journal batches were posted.
• Period-over-period reporting: join on BOOK_TYPE_CODE and PERIOD_COUNTER to aggregate depreciation by fiscal year and period.

Related Objects

• FA_BOOK_CONTROLS — the parent book definition; joined on BOOK_TYPE_CODE.
• FA_DEPRN_SUMMARY — period-level depreciation totals; joined on BOOK_TYPE_CODE and PERIOD_COUNTER.
• FA_DEPRN_DETAIL — asset-level depreciation lines; joined on BOOK_TYPE_CODE and PERIOD_COUNTER.
• FA_ADJUSTMENTS — references this table via BOOK_TYPE_CODE with PERIOD_COUNTER_ADJUSTED and PERIOD_COUNTER_CREATED.
• FA_BOOKS — references PERIOD_COUNTER_FULLY_RESERVED, PERIOD_COUNTER_FULLY_RETIRED, and PERIOD_COUNTER_CAPITALIZED.
• FA_JOURNAL_ENTRIES and FA_DEFERRED_DEPRN — period-keyed journal and deferred depreciation data.
• GL_JE_BATCHES — target of the numerous *_BATCH_ID foreign keys, enabling FA-to-GL reconciliation.
• FA_MC_CONVERSION_HISTORY and FA_MC_DEPRN_DETAIL — multi-currency period data joined on BOOK_TYPE_CODE.