Search Results fa_distribution_accounts




Overview
Explore in AI Chat

Overview

The FA_DISTRIBUTION_ACCOUNTS table is a core data repository within the Oracle E-Business Suite Fixed Assets (OFA) module, specifically for versions 12.1.1 and 12.2.2. Its primary function is to store the Chart of Accounts ID (CCID) mappings for all accounting distributions associated with an asset within a specific asset book. This table acts as the critical link between an asset's physical distribution history (location, assigned-to information) and the detailed general ledger accounts used for financial transactions such as depreciation, revaluation, retirement, and bonus depreciation. Each record is uniquely identified by a combination of BOOK_TYPE_CODE and DISTRIBUTION_ID, ensuring account integrity per asset book and distribution line.

Key Information Stored

The table's structure is dominated by foreign key columns referencing the GL_CODE_COMBINATIONS table, each representing a specific accounting flexfield for a transaction type. The primary key consists of BOOK_TYPE_CODE and DISTRIBUTION_ID. Key columns include DEPRN_EXPENSE_ACCOUNT_CCID and DEPRN_RESERVE_ACCOUNT_CCID for regular depreciation accounting. For asset revaluation, columns such as REVAL_RSV_ACCOUNT_CCID, REVAL_RSV_GAIN_ACCOUNT_CCID, and REVAL_RSV_LOSS_ACCOUNT_CCID are used. Retirement accounting utilizes NBV_RETIRED_GAIN_CCID, NBV_RETIRED_LOSS_CCID, and PROCEEDS_SALE_CLEARING_CCID. The table also stores accounts for bonus depreciation (BONUS_EXP_ACCOUNT_CCID, BONUS_RSV_ACCOUNT_CCID), deferred depreciation (DEFERRED_EXP_ACCOUNT_CCID, DEFERRED_RSV_ACCOUNT_CCID), and depreciation adjustments (DEPRN_ADJ_ACCOUNT_CCID).

Common Use Cases and Queries

This table is essential for troubleshooting account generation, auditing asset transactions, and creating custom financial reports. A common use case is tracing the specific general ledger accounts posted for a particular asset's depreciation. The following query retrieves the key accounts for a given asset distribution:

  • SELECT fda.distribution_id,
  • fda.deprn_expense_account_ccid,
  • fda.deprn_reserve_account_ccid,
  • fda.bonus_exp_account_ccid
  • FROM fa_distribution_accounts fda
  • WHERE fda.book_type_code = '&BOOK'
  • AND fda.distribution_id = &DIST_ID;

Another critical scenario involves validating account assignments before running depreciation or mass transactions. Analysts often join this table with FA_DISTRIBUTION_HISTORY to link accounts to asset numbers and with GL_CODE_COMBINATIONS to translate CCIDs into readable account segments.

Related Objects

FA_DISTRIBUTION_ACCOUNTS maintains integral relationships with several key EBS objects. Its primary foreign key relationship is with FA_DISTRIBUTION_HISTORY on DISTRIBUTION_ID, linking accounts to the specific asset assignment record. It is also governed by FA_BOOK_CONTROLS via BOOK_TYPE_CODE. The most frequent relationships are with GL_CODE_COMBINATIONS, as nearly every account CCID column is a foreign key to this table, ensuring valid general ledger accounts. This table is directly referenced by the depreciation and retirement posting processes. Key related tables for comprehensive reporting include FA_ADDITIONS (asset master), FA_BOOKS (asset book controls), and FA_TRANSACTION_HEADERS for transaction-level analysis.

  • Table: FA_DISTRIBUTION_ACCOUNTS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_DISTRIBUTION_ACCOUNTS,  object_name:FA_DISTRIBUTION_ACCOUNTS,  status:VALID,  product: OFA - Assets ,  description: Table to store account ccids for all distributions for a book ,  implementation_dba_data: FA.FA_DISTRIBUTION_ACCOUNTS , 

  • Table: FA_DISTRIBUTION_ACCOUNTS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_DISTRIBUTION_ACCOUNTS,  object_name:FA_DISTRIBUTION_ACCOUNTS,  status:VALID,  product: OFA - Assets ,  description: Table to store account ccids for all distributions for a book ,  implementation_dba_data: FA.FA_DISTRIBUTION_ACCOUNTS , 

  • Table: FA_DISTRIBUTION_HISTORY 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_DISTRIBUTION_HISTORY,  object_name:FA_DISTRIBUTION_HISTORY,  status:VALID,  product: OFA - Assets ,  description: Employee, location, and Accounting Flexfield values assigned to each asset ,  implementation_dba_data: FA.FA_DISTRIBUTION_HISTORY , 

  • Table: FA_DISTRIBUTION_HISTORY 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_DISTRIBUTION_HISTORY,  object_name:FA_DISTRIBUTION_HISTORY,  status:VALID,  product: OFA - Assets ,  description: Employee, location, and Accounting Flexfield values assigned to each asset ,  implementation_dba_data: FA.FA_DISTRIBUTION_HISTORY , 

  • Table: FA_BOOK_CONTROLS 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BOOK_CONTROLS,  object_name:FA_BOOK_CONTROLS,  status:VALID,  product: OFA - Assets ,  description: Control information that affects all assets in a depreciation book ,  implementation_dba_data: FA.FA_BOOK_CONTROLS , 

  • Table: FA_BOOK_CONTROLS 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BOOK_CONTROLS,  object_name:FA_BOOK_CONTROLS,  status:VALID,  product: OFA - Assets ,  description: Control information that affects all assets in a depreciation book ,  implementation_dba_data: FA.FA_BOOK_CONTROLS ,