Search Results proposal_budget_category_code




Overview
Explore in AI Chat

Overview

IGW_REPORT_BUDGET_V is a reporting view in the Oracle E-Business Suite Grants Proposal module (product code IGW), an obsolete component that was delivered only in the 10SC (10g Single Customer / Grants) environment. The ETRM metadata explicitly classifies this object as "Obsolete" and records its description as "10SC Only," and further states that it is "Not implemented in this database." Consequently, in Oracle EBS 12.1.1 and 12.2.2, the view is not a supported or generally available database object; it survives in documentation and in legacy 10SC installations as a reference definition only. Its role was to support grants budget reporting, specifically the presentation of proposal budget data formatted for the PHS 398 form, aggregating period totals by budget category for use in printed or extracted grant proposal reports.

Underlying Base Objects

The documented ETRM metadata lists no referenced base objects, and the view definition provided confirms that its only underlying source is the table IGW_REPORT_BUDGET. The view selects from IGW_REPORT_BUDGET filtered to rows where PROPOSAL_FORM_NUMBER = 'PHS 398', and it restricts the budget period to the row with the lowest BUDGET_PERIOD_ID returned by a MIN subquery over the same table. Beyond the physical table, the view depends on the PL/SQL function IGW_REPORT_PROCESSING.GET_PERIOD_TOTAL, which is invoked five times to compute period totals from the PROPOSAL_BUDGET_CATEGORY_CODE argument. The distinct combination of the two category columns drives the DISTINCT clause, so each category appears once in the result set with its rolling period figures.

Key Columns

  • PROPOSAL_BUDGET_CATEGORY_CODE — the code identifying the budget category (for example, personnel, equipment, or supplies) used as the key passed to GET_PERIOD_TOTAL.
  • PROPOSAL_BUDGET_CATEGORY — the descriptive name of the budget category presented on the report output.
  • PERIOD1_TOTAL through PERIOD5_TOTAL — five numeric columns, each produced by ROUND(IGW_REPORT_PROCESSING.GET_PERIOD_TOTAL(PROPOSAL_BUDGET_CATEGORY_CODE, n)), returning the rounded budget total for budget periods 1 through 5 respectively.

The five period columns reflect the standard multi-period grant budget layout, and the rounding applied by ROUND ensures the reported figures conform to whole-number presentation requirements.

Common Use Cases and Queries

The view was designed to feed the PHS 398 budget report in 10SC Grants Proposal, providing a ready-to-print category-by-period matrix without requiring the report to call the period total function directly. A typical query mirrors the view structure, for example:

  • SELECT PROPOSAL_BUDGET_CATEGORY, PERIOD1_TOTAL, PERIOD2_TOTAL, PERIOD3_TOTAL, PERIOD4_TOTAL, PERIOD5_TOTAL FROM IGW_REPORT_BUDGET_V ORDER BY PROPOSAL_BUDGET_CATEGORY;
  • SELECT PROPOSAL_BUDGET_CATEGORY_CODE, PERIOD1_TOTAL + PERIOD2_TOTAL + PERIOD3_TOTAL + PERIOD4_TOTAL + PERIOD5_TOTAL AS TOTAL_BUDGET FROM IGW_REPORT_BUDGET_V;

Because the view restricts data to PHS 398 and the earliest budget period, it cannot be reused for other proposal forms or period ranges without modification. In EBS 12.1.1 and 12.2.2 environments where it is not implemented, any query against IGW_REPORT_BUDGET_V returns an ORA-00942 table or view does not exist error, and developers should rely on IGW_REPORT_BUDGET plus IGW_REPORT_PROCESSING directly. The object is best treated as historical documentation of the 10SC grants reporting design.