Search Results burdenable_cost

Overview

GMS_RXI_EXP_DETAILS_V is a reporting view in the Oracle EBS Grants Accounting (GMS) module that consolidates expenditure, award, and burden (indirect cost) information into a single denormalized result set. It is primarily used to support proposal and award financial reporting, cost reconciliation, and burdenable cost analysis across sponsored projects. The view joins award master data, project and task structures, expenditure items, cost distribution lines, and indirect cost compilation logic to produce a complete picture of raw cost, burdenable cost, and calculated burden (indirect) cost for each expenditure transaction.

Because indirect costing in Grants Accounting requires alignment between expenditure types, cost bases, compiled multiplier sets, and indirect rate schedule revisions, this view encapsulates that complex relationship. It exposes both the raw amount distributed to a project and the burdenable portion of that amount, as well as the compiled multiplier and the resulting burden cost amount. As documented, the view is not implemented in the reference database, meaning it is provided for reporting definition but may not exist in every environment.

Underlying Base Objects

The view is defined over a substantial set of base tables, spanning Grants and Projects schemas:

• GMS_AWARDS_ALL (A) — primary award header, supplying award number, status, and end date.
• PA_PROJECTS_ALL (P) and PA_TASKS (T) — project and task structures linked to the award.
• PA_COST_DISTRIBUTION_LINES_ALL (CDL) — raw cost line amounts and project configuration currency.
• PA_EXPENDITURE_ITEMS (EI) and PA_EXPENDITURES_ALL (E) — expenditure type, incurred-by organization, and item linkage.
• GMS_AWARD_DISTRIBUTIONS (ADL) — award-level burdenable raw cost and compiled set references.
• GMS_RXI_BURDEN_VARIANCE (VAR) — burden variance source ID.
• HR_ORGANIZATION_UNITS (O) — expenditure organization name.
• PA_IND_COST_CODES (ICC), PA_COMPILED_MULTIPLIERS (CM), PA_IND_COMPILED_SETS (ICS), PA_COST_BASE_EXP_TYPES (CBET), PA_IND_RATE_SCH_REVISIONS (IRSR) — indirect cost compilation logic that yields the multiplier applied to burdenable cost.

The joins constrain results to active award distributions (ADL_STATUS = 'A') and indirect cost bases, ensuring only valid burden calculations are reflected.

Key Columns

• PROJECT_NUMBER, TASK_NUMBER, AWARD_NUMBER — identifiers for the project, task, and award.
• STATUS, STATUS_FLAG — award status; the flag resolves to 'N' when closed, 'Y' otherwise.
• EXPENDITURE_ORG — incurring organization name.
• EXPENDITURE_TYPE, ICC_EXPENDITURE_TYPE — raw and indirect cost code expenditure types.
• EXPENDITURE_ITEM_ID, LINE_NUM, SOURCE_ID — transaction linkage keys.
• RAW_COST — distributed amount from the cost distribution line.
• BURDENABLE_COST — burdenable raw cost, taken from award distribution where present, otherwise the raw cost.
• IDC_MULTIPLIER — compiled indirect cost multiplier applied to burdenable cost.
• BURDEN_COST — calculated indirect cost, rounded via PA_CURRENCY.ROUND_TRANS_CURRENCY_AMT1.
• REQUEST_ID — exposed as NULL in the view definition.
• PROJECT_ID, TASK_ID, AWARD_ID — numeric surrogate keys.

Common Use Cases and Queries

The view supports burdenable cost analysis, indirect cost reconciliation, and award expenditure reporting. A typical query retrieves burdenable cost and burden cost by award:

• SELECT award_number, project_number, task_number, expenditure_type, raw_cost, burdenable_cost, idc_multiplier, burden_cost FROM gms_rxi_exp_details_v WHERE award_number = :p_award;
• Comparing RAW_COST against BURDENABLE_COST to identify unallowable or non-burdenable portions.
• Aggregating BURDEN_COST by EXPENDITURE_ORG or EXPENDITURE_TYPE for indirect cost reporting.
• Filtering on STATUS_FLAG = 'Y' to restrict results to open awards.

Because the view is not implemented in the documented database, DBAs should verify its existence before referencing it in custom reports or integrations.