Search Results retn_accounting_flag




Overview
Explore in AI Chat

Overview

PA_PROJ_BILLING_STATUS_VIEW_O is a reporting view in the Oracle E-Business Suite Projects (PA) module that consolidates the billing status of projects into a single row per project. It is defined as an aggregation over PA_PROJ_BILLING_DETAIL_VIEW, grouping by PROJECT_ID and applying MAX or SUM to the remaining columns. The view is intended for reporting on billing activity, revenue generation, invoice amounts, pending billing events, and retention balances at the project level.

For users searching on projfunc_revenue_amount, this view exposes the column PROJFUNC_REVENUE_AMOUNT, which represents the revenue amount derived through the Project Functions (ProjFunc) accounting basis. This makes the view relevant for reconciliation between standard revenue amounts and ProjFunc-generated revenue, as well as for analyzing uninvoiced and unbilled balances under the ProjFunc method.

Underlying Base Objects

The documented view text indicates that PA_PROJ_BILLING_STATUS_VIEW_O selects entirely from PA_PROJ_BILLING_DETAIL_VIEW and performs aggregation using GROUP BY PROJECT_ID. No additional base tables are documented as directly referenced by this view; the detail view serves as the single upstream source. Consequently, the granularity and filter characteristics of PA_PROJ_BILLING_STATUS_VIEW_O are inherited from the detail view, with the final result collapsed to one row per project.

The metadata notes that this object is "Not implemented in this database," meaning the view text is documented in ETRM but the object may not exist in every environment, particularly where the underlying detail view is unavailable or where customization practices differ. Its documented referenced base objects list is empty, confirming that only the detail view is involved.

Key Columns

Common Use Cases and Queries

Typical scenarios include project billing status dashboards, unbilled receivable and retention analysis, and comparison of standard versus ProjFunc revenue and invoice amounts. Because the view aggregates to one row per project, it suits summary reporting rather than transactional detail.

  • Project billing status report showing last invoice details and next billing date.
  • Reconciliation of PROJFUNC_REVENUE_AMOUNT against REVENUE_AMOUNT to detect basis differences.
  • Analysis of pending and unbilled amounts by project, including ProjFunc variants.
  • Retention reporting that respects the RETN_ACCOUNTING_FLAG condition applied in the view definition.

Sample query:

SELECT project_number,
project_name,
billing_method,
projfunc_revenue_amount,
revenue_amount,
projfunc_invoice_amount,
invoice_amount
FROM pa_proj_billing_status_view_o
WHERE projfunc_revenue_amount <> revenue_amount;

This query identifies projects where ProjFunc revenue diverges from standard revenue, a frequent reconciliation point in Projects billing analysis. Users should confirm object availability in their environment, as the metadata indicates the view may not be implemented everywhere.