Search Results gms_expend_items_adjust_v




Overview
Explore in AI Chat

Overview

GMS_EXPEND_ITEMS_ADJUST_V is a Grants Accounting (GMS) reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents expenditure item and cost distribution detail in a denormalized form, joining award distribution lines, project and task attributes, expenditure classifications, employee and vendor identifiers, and organization hierarchies. The view is typically used by grants administrators, project accountants, and interfaces that must reconcile or adjust expenditure items at the distribution level without traversing the full PA and GMS base table set.

The view is particularly relevant to the EMPLOYEE_VENDOR_NUMBER column, which resolves the payee of an expenditure item to a single identifier regardless of whether the cost originated as labor (employee) or non-labor (vendor). This is a common search term because reconciliation, subledger transfer, and third-party reporting frequently require a unified payee reference.

Underlying Base Objects

The view is defined over the PA and GMS transactional and reference tables. The principal base objects documented in ETRM 12.2.2 are:

The view is anchored by a hint (INDEX(ADL GMS_ADL_UK)) to drive the award distribution join efficiently, and only exposes rows where distribution values and expenditure items align.

Key Columns

Common Use Cases and Queries

The view supports reconciliation of award distributions to expenditure items, payee-level analysis, and extracts for third-party reporting. A typical query filtering on the searched column would be:

  • SELECT PROJECT_NUMBER, EXPENDITURE_ITEM_ID, EMPLOYEE_VENDOR_NUMBER, EMPLOYEE_VENDOR_NAME, RAW_COST, BURDENED_COST FROM GMS_EXPEND_ITEMS_ADJUST_V WHERE EMPLOYEE_VENDOR_NUMBER = :payee AND EXPENDITURE_ITEM_DATE BETWEEN :start AND :end;

Other practical scenarios include aggregating burdened cost by expenditure organization, validating that award distribution percentages total 100, and identifying unmatched payees where both employee and vendor columns are null. Because the view references HR_SECURITY, results are subject to the operating unit and security profile of the executing user, which must be considered when scheduling concurrent extracts.