Search Results inv_rev_num

Overview

APPS.PA_UBR_UER_ACCT_DTLS_V is a reporting view in Oracle EBS Projects (PA) that exposes the accounting detail behind Unbilled Receivable (UBR) and Unearned Revenue (UER) processing. It joins the UBR/UER summary accounting table (PA_UBR_UER_SUMM_ACCT) to the originating draft invoice and draft invoice item records, then links the resulting rows to their corresponding General Ledger journal lines, headers, and batches. The view presents, in a single denormalized result set, the project, project type, cost center and account segments, the transaction type (UBR or UER), the associated invoice/revenue number, and the GL distribution amounts and identifiers.

The view is chiefly used for reconciliation and audit reporting. It answers questions such as: which GL journals were generated for a given UBR or UER summary, what invoice number (inv_rev_num) is tied to that accounting entry, and how the accounted amounts compare to the receivable distribution in AR. Because it bridges Projects and General Ledger, it is heavily used in period-end subledger-to-GL reconciliation, and in support of Oracle subledger accounting diagnostics for unearned and unbilled revenue.

Underlying Base Objects

The view is defined over the following documented objects:

• PA_UBR_UER_SUMM_ACCT (SYNONYM) — the driving summary accounting table containing the UBR/UER rows, period name, summary identifiers, and zero-balance flag.
• PA_PROJECTS (SYNONYM), PA_PROJECT_TYPES_ALL (SYNONYM), PA_IMPLEMENTATIONS_ALL (SYNONYM) — project, project type, org, and set-of-books context.
• PA_DRAFT_INVOICES_ALL (SYNONYM), PA_DRAFT_INVOICE_ITEMS (SYNONYM), PA_DRAFT_REVENUES_ALL (SYNONYM) — the draft invoice, draft invoice item, and draft revenue source records.
• PA_LOOKUPS (VIEW) — supplies the transaction type meaning from the PA_UBR_UER_TRANS_TYPE lookup type.
• RA_CUSTOMER_TRX_LINES_ALL (SYNONYM), RA_CUST_TRX_LINE_GL_DIST_ALL (SYNONYM) — the AR transaction line and its GL distribution, used to correlate the GL journal lines.
• GL_JE_LINES, GL_JE_HEADERS, GL_JE_BATCHES (SYNONYMS) — the General Ledger journal lines, headers, and batches that hold the accounted amounts.
• PA_CURRENCY (PACKAGE) and PA_UBR_UER_SUMM_PKG (PACKAGE) — provide currency rounding and summarization logic used by the view expressions.

The joins are driven from the summary accounting table to the draft invoice by project and by UBR/UER summary identifier, then to the AR distribution via matching CODE_COMBINATION_ID, and on to GL journal lines via the journal reference columns and period name. This chain is what ties a Projects accounting event to its GL posting.

Key Columns

• INV_REV_NUM — the invoice/revenue number, sourced from PA_DRAFT_INVOICES_ALL.RA_INVOICE_NUMBER. This is the column users search for as "inv_rev_num."
• PROJECT_ID, SEGMENT1, NAME — project identifier, project number, and project name.
• PROJECT_TYPE — project type classification.
• TYPE — the UBR/UER transaction type meaning, derived from PA_LOOKUPS via the PA_UBR_UER_TRANS_TYPE lookup.
• COST_CENTER_SEGMENT, ACCOUNT_SEGMENT — accounting flexfield segments for the distribution.
• UBR_SUMMARY_ID, UER_SUMMARY_ID — the summary identifiers for unbilled receivable and unearned revenue.
• AMOUNT — the currency-rounded accounted amount, computed by PA_CURRENCY.ROUND_CURRENCY_AMT with sign logic distinguishing UBR from UER.
• GL_HEADER_ID, GL_LINE_NUM, GL_HEADER_NAME, GL_BATCH_NAME — the GL journal line, header, and batch identifiers and names.
• GL_PERIOD_NAME, GL_PERIOD_START_DATE, ZERO_BALANCE_FLAG, LINE_NUM, TEXT — accounting period, period start date, zero-balance indicator, line number, and descriptive text.
• SET_OF_BOOKS_ID, ORG_ID — ledger and operating unit context.

Common Use Cases and Queries

Typical uses include locating the accounting detail for a specific invoice or revenue number, reconciling UBR/UER balances to GL, and auditing unearned or unbilled revenue by period. A representative query to locate a transaction by invoice/revenue number is:

SELECT project_id, segment1, name, type, inv_rev_num, amount, gl_header_id, gl_line_num, gl_period_name
FROM apps.pa_ubr_uer_acct_dtls_v
WHERE inv_rev_num = :invoice_number;

To review all UBR/UER activity for a period, filtering on gl_period_name and grouping by type yields period-to-date totals. Reconciliation queries join amount against GL_JE_LINES balances for the same header and line. Because the view joins numerous tables and applies sign-based decode logic for UBR versus UER, queries should filter on indexed columns such as project or invoice number and period to limit result sets. Note that the view text is documented only in excerpt form, so consumers should validate the exact join and filter behavior against the deployed 12.1.1/12.2.2 instance before relying on it for automated reconciliation.