Search Results pa_rcv_exceptions_sum_v




Overview
Explore in AI Chat

Overview

PA_RCV_EXCEPTIONS_SUM_V is an Oracle Projects (PA) reporting view owned by the APPS schema that summarizes purchasing receipts which prevent an accounting period from being closed. Within the Oracle E-Business Suite 12.1.1 and 12.2.2 architecture, the view acts as a diagnostic and reconciliation utility, exposing the specific receipt and subledger transactions that block the Projects period close process. Because receipts are processed through Purchasing and Receiving and subsequently distributed to Projects, unresolved receipt accounting can create exceptions that halt period-end activities. This view consolidates those exceptions so that project accountants can identify, investigate, and correct them.

Underlying Base Objects

The view is defined over several base and reference objects. The primary tables are PO_DISTRIBUTIONS_ALL (aliased PODIST), RCV_TRANSACTIONS (RCV), RCV_RECEIVING_SUB_LEDGER (RCV_SUB), RCV_SHIPMENT_HEADERS (RCV_HDR), and PA_IMPLEMENTATIONS_ALL (IMP). The view also invokes packaged logic from PA_UTILS, PA_EXCEPTION_REASONS_PUB, and PA_EXPENDITURES_UTILS. Documented referenced objects include PA_EXCEPTION_REASONS_PUB (PACKAGE), PA_EXPENDITURES_UTILS (PACKAGE), PA_IMPLEMENTATIONS_ALL (SYNONYM), PA_UTILS (PACKAGE), PO_DISTRIBUTIONS_ALL (SYNONYM), RCV_RECEIVING_SUB_LEDGER (SYNONYM), RCV_SHIPMENT_HEADERS (SYNONYM), and RCV_TRANSACTIONS (SYNONYM).

The join logic links distributions to receipt transactions and their receiving subledger entries, filtering to records where PA_ADDITION_FLAG is 'N' or 'I', actual_flag is 'A', and accrue_on_receipt_flag is 'Y'. It also constrains destination types to EXPENSE or specific RETURN transaction types, ensuring only project-related distributions with a valid project_id are surfaced. Packaged functions such as PA_UTILS.GET_PA_DATE and GET_PA_PERIOD_NAME derive the Projects accounting date and period, while PA_EXCEPTION_REASONS_PUB.GET_EXCEPTION_TEXT supplies human-readable exception and corrective action descriptions.

Key Columns

The view exposes identifiers and accounting attributes used to diagnose close-blocking receipts. Key columns include PROJECT_ID and TASK_ID, which locate the affected project and task; TRANSACTION_ID and SHIPMENT_HEADER_ID, which identify the receipt and shipment; and VENDOR_ID, CURRENCY_CODE, and the currency conversion columns (CONVERSION_DATE, CONVERSION_TYPE, CONVERSION_RATE). Accounting values include ENTERED_DR, ACCOUNTED_DR, and FUNCTIONAL_CURRENCY_CODE from the receiving subledger, along with PA_ADDITION_FLAG, which is repurposed as EXCEPTION_CODE. The view also returns EXPENDITURE_ORGANIZATION_ID, EXPENDITURE_TYPE, EXPENDITURE_ITEM_DATE, GL_DATE, PA_DATE, and PERIOD_NAME derived via PA_UTILS, alongside GL_PERIOD_NAME from the subledger. EXCEPTION_REASON and CORRECTIVE_ACTION deliver descriptive text via the exception reasons package, while SAME_PA_GL_PERIOD, SET_OF_BOOKS_ID, PO_HEADER_ID, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_DISTRIBUTION_ID, and DISTRIBUTION_NUM provide supporting context.

Common Use Cases and Queries

Project accountants use this view during period-end close to list all receipts preventing close and to review the corrective action suggested by the exception framework. A typical query filters by organization or period to isolate actionable items:

  • SELECT project_id, task_id, transaction_id, exception_reason, corrective_action FROM pa_rcv_exceptions_sum_v WHERE org_id = :org_id;
  • SELECT period_name, gl_period_name, same_pa_gl_period, accounted_dr FROM pa_rcv_exceptions_sum_v WHERE period_name = :period;
  • SELECT po_header_id, po_line_id, distribution_num, expenditure_type FROM pa_rcv_exceptions_sum_v WHERE project_id = :project_id ORDER BY transaction_id;

Because the view already applies the exception filters at the database level, reports and integrations built against it avoid re-implementing the complex join and flag logic. It is commonly used in custom concurrent programs, Oracle Projects period-close diagnostics, and reconciliation extracts that need a consolidated list of blocking receipt exceptions before the Projects period can be closed.