Results for “rev_rate_date_type”

8 results




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

Overview

PA_MC_BUDGET_LINES is a Projects (PA) module table that stores project budget lines converted into the reporting currencies of every reporting set of books associated with a primary set of books. In Oracle EBS multi-currency and multi-organization reporting scenarios, transactional data is maintained in the functional (primary) currency, and this table provides the equivalent raw cost, burdened cost, and revenue amounts expressed in each reporting currency. Its native key is composite: the budget line identifier combined with the set of books identifier, which allows the same source budget line to exist once per reporting set of books. The table is populated and maintained by concurrent processes, evidenced by the REQUEST_ID column, which links generated rows back to a specific concurrent request.

From a Data Vault modeling perspective, the documented foreign key structure suggests this object is best characterized as a link table. It resolves the many-to-many relationship between budget lines (PA_BUDGET_LINES) and reporting sets of books (GL_SETS_OF_BOOKS_11I), while carrying descriptive currency-conversion attributes. The conversion-oriented columns (rate types, conversion dates, exchange rates, converted amounts) are satellite-style attributes attached to that link, but the composite key behavior places the object firmly in the link classification.

Key Information Stored

The most significant columns are:

The surrogate unique index PA_MC_BUDGET_LINES_U1 is defined on (BUDGET_LINE_ID, SET_OF_BOOKS_ID), and the primary key constraint PA_MC_BUDGET_LINES_PK uses the same columns.

Common Use Cases and Queries

A frequent requirement is retrieving converted budget amounts for a specific reporting set of books, which is where the budget_line_id search term typically surfaces.

  • Reporting converted budget cost and revenue by project and reporting currency.
  • Reconciling reporting-currency budgets against the primary-set-of-books values in PA_BUDGET_LINES.
  • Auditing conversion rate usage across budget versions during period-close reviews.
SELECT mc.budget_line_id,
       mc.set_of_books_id,
       mc.reporting_currency_code,
       mc.raw_cost,
       mc.burdened_cost,
       mc.revenue
FROM   pa_mc_budget_lines mc
WHERE  mc.budget_line_id = :budget_line_id
AND    mc.set_of_books_id = :set_of_books_id;

Joining to the source budget line and project aids traceability:

SELECT p.project_number,
       mc.reporting_currency_code,
       SUM(mc.burdened_cost) AS burdened_cost,
       SUM(mc.revenue)       AS revenue
FROM   pa_mc_budget_lines mc,
       pa_projects_all     p
WHERE  mc.project_id = p.project_id
AND    mc.set_of_books_id = :set_of_books_id
GROUP  BY p.project_number, mc.reporting_currency_code;

Related Objects

  • PA_BUDGET_LINES — Source budget lines; joined on BUDGET_LINE_ID.
  • PA_BUDGET_VERSIONS — Budget version context; joined via BUDGET_LINE_ID / BUDGET_VERSION_ID.
  • PA_PROJECTS_ALL — Project master; joined on PROJECT_ID.
  • GL_SETS_OF_BOOKS_11I — Reporting set of books definition; joined on SET_OF_BOOKS_ID.
  • FND_CURRENCIES — Currency validation; joined on REPORTING_CURRENCY_CODE.
  • GL_DAILY_CONVERSION_TYPES — Rate type validation for both COST_RATE_TYPE and REV_RATE_TYPE.
  • FND_CONCURRENT_REQUESTS — Request traceability via REQUEST_ID.