Search Results receipt_excp




Overview
Explore in AI Chat

Overview

APPS.PA_RCV_EXCEPTIONS_SUM_V is a Projects (PA) module reporting view in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents receiving-related expenditure exceptions that arise when receipt accounting activity cannot be added to a project as an expenditure item. The view brings together purchasing distribution data, receiving transaction data, receiving sub-ledger accounting entries, and Projects implementation settings to expose each exception with its reason and suggested corrective action.

The view is read-only and is used primarily for reporting, inquiry, and integration. It surfaces rows attributable to the RCV_HDR receiving shipment header, and its output is typically consumed by exception dashboards, reconciliation reports, and interfaces that notify project accountants of receipts that failed the automatic expenditure import process. Because it depends on the PA_EXCEPTION_REASONS_PUB messages, it delivers both a coded exception and human-readable explanatory text.

Underlying Base Objects

The view is defined over the following documented base objects:

Key Columns

Common Use Cases and Queries

The view is commonly used to list exception receipts for a project, expenditure organization, or ledger.

  • Project exception listing:

    SELECT project_id, task_id, transaction_id,Exception_code, Exception_reason, Corrective_action FROM apps.pa_rcv_exceptions_sum_v WHERE project_id = :project_id;

  • Exceptions by expenditure organization and PA period:

    SELECT expenditure_organization_id, period_name, exception_code, COUNT(*) FROM apps.pa_rcv_exceptions_sum_v GROUP BY expenditure_organization_id, period_name, exception_code;

  • Receipt header drill-down (matching the "rcv_hdr" search):

    SELECT transaction_id, shipment_header_id, po_header_id, vendor_id,exception_reason FROM apps.pa_rcv_exceptions_sum_v WHERE shipment_header_id = :shipment_header_id;