Search Results pa_mc_budget_lines




Overview
Explore in AI Chat

Overview

The PA_MC_BUDGET_LINES table is a core data object within the Oracle E-Business Suite Projects (PA) module, specifically supporting its Multi-Currency (MC) functionality. Its primary role is to store the converted budget line amounts for all reporting sets of books associated with a primary set of books. When a project budget is created in a primary ledger currency, this table holds the equivalent raw cost, burdened cost, and revenue amounts translated into each defined reporting currency. This enables consolidated financial reporting and analysis across multiple ledgers and currencies, a critical requirement for global project management and accounting in releases 12.1.1 and 12.2.2.

Key Information Stored

The table stores a record for each budget line per reporting set of books. Key columns include the composite primary key (BUDGET_LINE_ID, SET_OF_BOOKS_ID), which uniquely identifies a converted budget line for a specific reporting ledger. The SET_OF_BOOKS_ID column identifies the reporting ledger, while the BUDGET_LINE_ID links back to the original budget line in the primary currency. Critical financial data columns store the converted amounts for raw cost, burdened cost, and revenue. The table also holds currency conversion metadata, such as REPORTING_CURRENCY_CODE, COST_RATE_TYPE, REV_RATE_TYPE, and associated exchange rates, which document how the monetary conversions were performed.

Common Use Cases and Queries

The primary use case is generating project budget reports in any reporting currency without requiring real-time conversion. This is essential for period-end financial closing, comparative budget analysis across subsidiaries, and audit trails of currency conversions. A common query pattern involves joining this table to the primary budget lines and project tables to retrieve a consolidated budget view. For example:

  • SELECT pmcbl.*, pbl.raw_cost, pbl.burdened_cost FROM pa_mc_budget_lines pmcbl JOIN pa_budget_lines pbl ON pmcbl.budget_line_id = pbl.budget_line_id WHERE pmcbl.project_id = :p_project_id AND pmcbl.set_of_books_id = :p_sob_id;

This retrieves all converted budget lines for a specific project and reporting ledger, alongside the original amounts. Reporting use cases include variance analysis (budget vs. actuals) in reporting currencies and ledger-specific budget summaries.

Related Objects

PA_MC_BUDGET_LINES maintains integral foreign key relationships with several fundamental EBS tables, as documented in the ETRM. These relationships are crucial for data integrity and join logic:

  • PA_BUDGET_LINES: The source table for the original budget line (PA_MC_BUDGET_LINES.BUDGET_LINE_ID = PA_BUDGET_LINES.BUDGET_LINE_ID).
  • GL_SETS_OF_BOOKS: Identifies the reporting ledger (PA_MC_BUDGET_LINES.SET_OF_BOOKS_ID = GL_SETS_OF_BOOKS.SET_OF_BOOKS_ID).
  • PA_PROJECTS_ALL: Links to the master project definition (PA_MC_BUDGET_LINES.PROJECT_ID = PA_PROJECTS_ALL.PROJECT_ID).
  • FND_CURRENCIES: Validates the reporting currency code (PA_MC_BUDGET_LINES.REPORTING_CURRENCY_CODE = FND_CURRENCIES.CURRENCY_CODE).
  • GL_DAILY_CONVERSION_TYPES: References the conversion rate types used for cost and revenue (PA_MC_BUDGET_LINES.COST_RATE_TYPE = GL_DAILY_CONVERSION_TYPES.CONVERSION_TYPE and PA_MC_BUDGET_LINES.REV_RATE_TYPE = GL_DAILY_CONVERSION_TYPES.CONVERSION_TYPE).
  • PA_BUDGET_VERSIONS: Provides context for the budget version via the budget line identifier.