About Project Budget Fact

The Budget Fact table (W_PROJ_BUDGET_F) stores baselined budget information extracted from Oracle E-Business Suite.

The grain of this fact table is Budget Line, with each record representing an individual budget line.

Only baselined budgets are extracted into the EBS Data Intelligence Analytics Warehouse. Once loaded, existing records in the Budget Fact table are not updated. During incremental runs, only new budget line records are inserted, ensuring that previously loaded baselined budgets remain unchanged.

The associated budget master data is stored in the Budget Dimension table (W_PROJ_BUDGET_D).