Search Results total_invoice_amount




Overview
Explore in AI Chat

Overview

PA_PROJ_RELEASED_INVOICES_VIEW is a reporting view owned by the APPS schema in Oracle E-Business Suite, classified under the Projects (PA) product family. Its documented purpose is to present released invoices for projects — that is, project-related invoices that have completed the release step of the invoice lifecycle and are therefore eligible for transfer to Oracle Receivables and subsequent general ledger accounting. The view is defined as a filtered projection over PA_PROJ_INVOICES_VIEW, exposing the same column set but restricting the result set to rows where RELEASED_DATE IS NOT NULL. In Oracle EBS 12.1.1 and 12.2.2 this makes the view a stable, read-only source for reporting on finalized billing activity without the burden of re-implementing the release filter in every query.

Because the view carries no procedural logic of its own beyond the RELEASED_DATE predicate, it is suitable for operational reports, reconciliation extracts, and integration staging where only released documents are of interest. The question of total invoice value, commonly searched as "total_invoice_amount," is answered directly by the TOTAL_INVOICE_AMOUNT column, which the view inherits from the underlying invoice view.

Underlying Base Objects

The ETRM metadata documents two referenced base objects: PA_PROJ_INVOICES_VIEW (VIEW) and PA_PERIOD_PROCESS_PKG (PACKAGE). PA_PROJ_INVOICES_VIEW is the direct source of the SELECT list; PA_PROJ_RELEASED_INVOICES_VIEW is a thin wrapper that applies the release-date predicate against it. PA_PERIOD_PROCESS_PKG is a Projects period-processing package that participates in the invoice aggregation chain beneath PA_PROJ_INVOICES_VIEW, supplying derived period and processing attributes. The full lineage therefore runs from project invoice and draft invoice base tables through the period-process package, into PA_PROJ_INVOICES_VIEW, and finally into this released-invoices view.

  • PA_PROJ_INVOICES_VIEW — supplies every projected column, including amounts, statuses, and customer and agreement attributes.
  • PA_PERIOD_PROCESS_PKG — period processing logic underlying the invoice view.
  • APPS schema — owner of the view; grants must be verified for any reporting or integration user.

Key Columns

The column list mirrors the source view and supports both financial and workflow analysis.

Common Use Cases and Queries

Typical usage includes released-invoice registers, period-based revenue and billing reconciliations, and aging or exception reports. Because the release filter is already applied, queries remain simple and index-friendly.

  • Total released billing by project and GL period.
  • Listing invoices awaiting transfer or previously rejected by Receivables.
  • Reconciling retained amounts against gross invoice value.
SELECT project_id,
       ra_invoice_number,
       gl_period,
       total_invoice_amount,
       retention_amount,
       invoice_amount
  FROM apps.pa_proj_released_invoices_view
 WHERE released_date BETWEEN :p_from AND :p_to
 ORDER BY project_id, released_date;

Aggregate pattern for the searched column:

SELECT project_id,
       gl_period,
       SUM(total_invoice_amount) total_released
  FROM apps.pa_proj_released_invoices_view
 WHERE invoice_status = 'RELEASED'
 GROUP BY project_id, gl_period;

Additional filters on agreement_id, customer_id, or transfer_status_code allow the same view to serve contract-level and integration monitoring requirements without modification.