Search Results gms_draft_revenues_v




Overview
Explore in AI Chat

Overview

GMS_DRAFT_REVENUES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the GMS – Grants Accounting product. Its documented description is simply "Retrofitted," indicating that the object was carried forward, with modifications, from an earlier release line (notably the 11i family) into the 12.1.1 and 12.2.2 code lines without a conceptual redesign. Functionally, the view presents draft revenue records generated for award-funded projects, joining revenue processing data with award, project, customer, agreement, organization, and lookup attributes so that revenue can be reviewed, released, and transferred to General Ledger.

The view is the primary read interface for the Draft Revenue window, related concurrent program output, and any custom reporting that needs award-aware revenue visibility. Because it exposes security functions and multi-currency columns, it supports both operational review and downstream integration. The column UNBILLED_CODE_COMBINATION_ID is a frequent search target: it identifies the accounting flexfield combination to which unbilled receivable amounts are posted when a draft revenue is transferred, making it central to reconciliation between Grants Accounting and General Ledger.

Underlying Base Objects

The view is defined over a mix of synonyms, views, packages, and DUAL. The principal transactional sources are PA_DRAFT_REVENUES (synonym) and PA_DRAFT_REVENUE_ITEMS (synonym), aliased as R and RI respectively; revenue amounts are aggregated with SUM(NVL(...)) across the item rows, which is why currency and amount columns repeat in the projection. Master data is supplied by GMS_AWARDS, PA_PROJECTS, PA_PROJECT_STATUSES, PA_PROJECT_TYPES, PA_AGREEMENTS_ALL, HZ_CUST_ACCOUNTS, and HZ_PARTIES. HR_ORGANIZATION_UNITS and HR_GENERAL provide organization context. PA_LOOKUPS supplies decoded lookup meanings such as transfer status and generation status.

Security and currency behavior is encapsulated in packages: PA_SECURITY and GMS_SECURITY supply ALLOW_UPDATE and VIEW_LABOR_COSTS calls, while HR_SECURITY is referenced in the dependency list. PA_CURRENCY is invoked for currency conversion and formatting logic. The view therefore acts as a secured, pre-joined projection rather than a simple table alias.

Key Columns

Common Use Cases and Queries

Typical usage includes reconciling unbilled balances by accounting combination, identifying drafts that failed generation or transfer, and reporting accrued revenue by award, project, and currency. A common query resolving the searched column is:

SELECT award_number, draft_revenue_num, project_id,
       unbilled_code_combination_id, unbilled_receivable_dr,
       uneared_revenue_cr, transfer_status_code
FROM   apps.gms_draft_revenues_v
WHERE  unbilled_code_combination_id IS NOT NULL
AND    transfer_status_code = 'N';

Draft revenues awaiting release can be listed with RELEASED_DATE IS NULL, and error conditions with GENERATION_ERROR_FLAG = 'Y'. Because aggregation is performed inside the view, callers should group or filter carefully when joining to item-level detail.