Search Results gl_line_id

Overview

APPS.PA_UBR_UER_PROJ_DTLS_V is a reporting view in Oracle EBS Projects (PA) that consolidates Unbilled Receivable (UBR) and Unearned Revenue (UER) project detail lines into a single, presentation-ready result set. In the Oracle EBS 12.1.1 and 12.2.2 data models, unbilled receivables and unearned revenue are generated when billing events, revenue distributions, and invoice transactions are processed but not yet fully reconciled to the General Ledger. This view assembles those transactions by joining project, project type, draft invoice, draft revenue, and UBR/UER summary accounting records, and then applies conditional decoding so that the correct amount appears under the appropriate amount column.

The view is frequently consulted by technical consultants and reporting specialists who need to reconcile UBR/UER balances at the project, invoice, and GL period level. Its output supports Period-Close reporting, unbilled balance analysis, and the investigation of stale or zero-balance UBR/UER summary records. The user search term "inv_rev_amount" maps directly to the column Inv_Rev_Amount, which is the rounded invoice/revenue amount computed by the view.

Underlying Base Objects

The documented base objects referenced by the view include:

• PA_PROJECTS (SYNONYM) — provides Project_Number, Project_Name, and Project_Id.
• PA_PROJECT_TYPES_ALL (SYNONYM) — supplies the project type classification.
• PA_DRAFT_INVOICES_ALL (SYNONYM) — supplies the draft invoice number (ra_invoice_number) and UBR/UER summary identifiers.
• PA_DRAFT_INVOICE_ITEMS (SYNONYM) — supplies line_num, acct_amount, unbilled_receivable_dr, unearned_revenue_cr, code combination IDs, and line text.
• PA_DRAFT_REVENUES_ALL (SYNONYM) — source of draft revenue detail linked into the invoice/summary join.
• PA_UBR_UER_SUMM_ACCT (SYNONYM) — the UBR/UER summary accounting table supplying cost center, account, GL period name, zero_balance_flag, gl_period_start_date, request_id, and process_flag.
• PA_IMPLEMENTATIONS_ALL (SYNONYM) — implementation-level context.
• PA_LOOKUPS (VIEW) — resolves the summary "type" meaning.
• PA_CURRENCY (PACKAGE) — provides the round_currency_amt function used to round each amount.
• PA_UBR_UER_SUMM_PKG (PACKAGE) — supplies get_inv_gl_header_id_line_num, used to derive GL header ID, line ID, header name, and batch name for a given UBR/UER accounting line.

Key Columns

• Inv_Rev_Amount — the searched column. It returns the invoice/revenue amount for the line, decoded so that when the summary referenced is the UBR summary, the UBR amount is used only if UBR equals UER; when the UER summary is referenced, the UER amount is used only if UER differs from UBR. The result is passed through PA_CURRENCY.round_currency_amt.
• UBR_Amount — the unbilled_receivable_dr amount when the summary is the UBR summary.
• UER_Amount — the unearned_revenue_cr amount when the summary is the UER summary.
• Inv_Rev_Num — the draft invoice number (di.ra_invoice_number).
• Line_Number — the draft invoice item line number.
• UBR_Summary_Id / UER_Summary_Id — identifiers of the associated summary records.
• Gl_Period_Name, Gl_Period_Start_Date — the GL period and its start date for the summary line.
• Gl_Header_Id, gl_line_Id, gl_header_name, gl_batch_name — GL context derived via PA_UBR_UER_SUMM_PKG.
• Zero_Balance_Flag, Process_Flag, Request_Id — status and concurrency attributes used to filter active or completed records.
• Type — the lookup meaning describing the summary category.

Common Use Cases and Queries

Typical use cases include reconciling unbilled and unearned balances per project and GL period, identifying zero-balance summary lines that remain in the system, and tracing a draft invoice line back to its GL header and batch. A simple query returning the searched amount is:

SELECT project_number, project_name, inv_rev_num, line_number, inv_rev_amount, ubr_amount, uer_amount, gl_period_name FROM apps.pa_ubr_uer_proj_dtls_v WHERE inv_rev_amount <> 0 ORDER BY project_number, gl_period_name;

To locate lines tied to a specific project and period:

SELECT project_number, project_name, inv_rev_amount, ubr_amount, uer_amount FROM apps.pa_ubr_uer_proj_dtls_v WHERE project_number = :p_project AND gl_period_name = :p_period;

For GL reconciliation, filter on the derived header:

SELECT inv_rev_num, line_number, gl_header_id, gl_line_id, gl_header_name, gl_batch_name FROM apps.pa_ubr_uer_proj_dtls_v WHERE gl_header_id IS NOT NULL AND zero_balance_flag = 'N';

Because the view performs package calls for each row, queries should be constrained by project, GL period, or summary identifier to keep execution cost reasonable on large volumes.