Search Results ubr_amount




Overview
Explore in AI Chat

Overview

PA_UBR_UER_PROJ_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Projects (PA) product family. Its purpose is to present a consolidated project-level summary of Unbilled Receivable (UBR) and Unearned Revenue (UER) balances. The view is not used by core transaction processing; rather, it exists specifically to support UBR and UER reporting, providing a denormalized, query-ready result set that joins project attributes, project type, GL period information, and summarized UBR/UER account balances from the underlying summary accounting table.

The view is valid in both 12.1.1 and 12.2.2 and behaves identically in either release, since it is a pure SQL definition layered over standard PA and GL objects. Users searching for the term "ubr_amount" will typically land on this view because UBR_AMOUNT is one of its principal derived columns, computed as the sum of the prior-period UBR debit balance and the current unbilled receivable debit amount, rounded through the PA_CURRENCY rounding API.

Underlying Base Objects

The view is defined over a small set of documented base objects:

A correlated NOT EXISTS subquery on PA_UBR_UER_SUMM_ACCT ensures that, for each project/cost center/account combination, only the latest summary row whose GL_PERIOD_START_DATE is less than or equal to the GL period start date is returned, preventing duplicate or overlapping period rows.

Key Columns

Common Use Cases and Queries

The view is typically queried by project accountants and reporting tools to reconcile unbilled receivables and unearned revenue by project and period. A basic balance listing is:

SELECT project_number, project_name, gl_period_name, cost_center, account, ubr_amount, uer_amount, zero_balance_flag FROM apps.pa_ubr_uer_proj_v WHERE org_id = :p_org_id AND gl_period_name = :p_period ORDER BY project_number;

To isolate projects carrying a non-zero unbilled receivable at a point in time:

SELECT project_number, project_name, SUM(ubr_amount) ubr_total FROM apps.pa_ubr_uer_proj_v WHERE set_of_books_id = :p_sob_id AND zero_balance_flag = 'N' GROUP BY project_number, project_name HAVING SUM(ubr_amount) <> 0;

Because SET_OF_BOOKS_ID and ORG_ID are exposed, queries should always be filtered by ledger or operating unit to avoid cross-organization results. Reporting is generally restricted to rows where PROCESS_FLAG and REQUEST_ID reflect the most recent successful summarization run, ensuring the reported UBR_AMOUNT and UER_AMOUNT align with the current period balance carried forward from the prior period.