Search Results fa_budget_distribution




Overview
Explore in AI Chat

Overview

The FA_BUDGET_DISTRIBUTION table is a core data structure within the Oracle E-Business Suite (EBS) Fixed Assets module (OFA). It serves as the primary repository for detailed capital budget information. This table stores the distribution of budgeted amounts across specific accounting dimensions, such as asset categories and general ledger accounts, for a given capital budget. The data can originate from two primary sources: manual entry through the application's user interface or an automated upload process via the FA_BUDGET_INTERFACE staging table. Its existence is critical for enabling capital budgeting and expenditure control workflows, allowing organizations to plan, track, and compare actual asset acquisitions against planned budgets.

Key Information Stored

The table's structure is designed to link a budget to specific accounting flexfields and asset classifications. While the full column list is not detailed in the provided metadata, the documented foreign key relationships and primary key identify its most significant columns. The primary key column, BUDGET_ID, uniquely identifies each budget distribution record. The table links this budget to operational setup data through foreign keys: BOOK_TYPE_CODE references the FA_BOOK_CONTROLS table to associate the budget with a specific asset book, CATEGORY_ID references FA_CATEGORIES_B to tie the budget to an asset category, and CODE_COMBINATION_ID references GL_CODE_COMBINATIONS to specify the accounting flexfield (general ledger account) for the budgeted amount. The table would also contain at least one amount column to store the budgeted value for the specified combination of book, category, and account.

Common Use Cases and Queries

The primary use case is reporting and analysis of capital budgets. Financial controllers and asset managers query this table to review budget allocations, monitor spending against plans, and generate variance reports. A typical query would join FA_BUDGET_DISTRIBUTION with related setup tables to produce a readable budget report. For example:

  • SELECT fbd.BUDGET_ID, fbc.BOOK_TYPE_CODE, cat.SEGMENT1, cat.DESCRIPTION, gcc.SEGMENT1, gcc.SEGMENT2, fbd.BUDGET_AMOUNT FROM FA_BUDGET_DISTRIBUTION fbd, FA_BOOK_CONTROLS fbc, FA_CATEGORIES_B cat, GL_CODE_COMBINATIONS gcc WHERE fbd.BOOK_TYPE_CODE = fbc.BOOK_TYPE_CODE AND fbd.CATEGORY_ID = cat.CATEGORY_ID AND fbd.CODE_COMBINATION_ID = gcc.CODE_COMBINATION_ID AND fbd.BUDGET_ID = :p_budget_id;

Another critical process involves data migration or integration, where budget data is loaded into the FA_BUDGET_INTERFACE table before being validated and transferred into FA_BUDGET_DISTRIBUTION.

Related Objects

FA_BUDGET_DISTRIBUTION maintains integral relationships with several key EBS tables, as documented in the provided metadata. The table references the following objects via foreign keys:

  • FA_BOOK_CONTROLS: Joined on BOOK_TYPE_CODE to validate the asset book.
  • FA_CATEGORIES_B: Joined on CATEGORY_ID to validate the asset category.
  • GL_CODE_COMBINATIONS: Joined on CODE_COMBINATION_ID to validate the general ledger account.

Furthermore, it is referenced by the following object:

  • FA_CAPITAL_BUDGET: The FA_CAPITAL_BUDGET table references FA_BUDGET_DISTRIBUTION via its BUDGET_ID column. This suggests FA_CAPITAL_BUDGET may store header-level budget information, while FA_BUDGET_DISTRIBUTION stores the detailed distribution lines.

The FA_BUDGET_INTERFACE table, mentioned in the description, is a related staging object used for uploading budget data but is not linked via a documented foreign key constraint.

  • Table: FA_BUDGET_DISTRIBUTION 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BUDGET_DISTRIBUTION,  object_name:FA_BUDGET_DISTRIBUTION,  status:VALID,  product: OFA - Assets ,  description: Capital budget information entered manually or uploaded from the FA_BUDGET_INTERFACE table ,  implementation_dba_data: FA.FA_BUDGET_DISTRIBUTION , 

  • Table: FA_BUDGET_DISTRIBUTION 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_BUDGET_DISTRIBUTION,  object_name:FA_BUDGET_DISTRIBUTION,  status:VALID,  product: OFA - Assets ,  description: Capital budget information entered manually or uploaded from the FA_BUDGET_INTERFACE table ,  implementation_dba_data: FA.FA_BUDGET_DISTRIBUTION , 

  • Table: FA_CAPITAL_BUDGET 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_CAPITAL_BUDGET,  object_name:FA_CAPITAL_BUDGET,  status:VALID,  product: OFA - Assets ,  description: Budget assets used to run depreciation projections and reports ,  implementation_dba_data: FA.FA_CAPITAL_BUDGET , 

  • Table: FA_CAPITAL_BUDGET 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_CAPITAL_BUDGET,  object_name:FA_CAPITAL_BUDGET,  status:VALID,  product: OFA - Assets ,  description: Budget assets used to run depreciation projections and reports ,  implementation_dba_data: FA.FA_CAPITAL_BUDGET , 

  • Table: FA_CATEGORIES_B 12.1.1

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_CATEGORIES_B,  object_name:FA_CATEGORIES_B,  status:VALID,  product: OFA - Assets ,  description: Default financial information for asset categories (base MLS table) ,  implementation_dba_data: FA.FA_CATEGORIES_B , 

  • Table: FA_CATEGORIES_B 12.2.2

    owner:FA,  object_type:TABLE,  fnd_design_data:OFA.FA_CATEGORIES_B,  object_name:FA_CATEGORIES_B,  status:VALID,  product: OFA - Assets ,  description: Default financial information for asset categories (base MLS table) ,  implementation_dba_data: FA.FA_CATEGORIES_B , 

  • 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 , 

  • 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 ,