Search Results icx_rcv_returns_v




Overview
Explore in AI Chat

Overview

APPS.ICX_RCV_RETURNS_V is a reporting view owned by the APPS schema and delivered as part of the ICX (Oracle iProcurement) product family. Its documented description is "Returned Item Receipts View," and its purpose is to expose receipt transactions of the return variety in a denormalized, user-friendly form suitable for inquiry pages, self-service receipt correction, and downstream reporting. The view consolidates receiving transaction data with shipment, purchasing, supplier, employee, and organization context so that a single row describes a returned receipt line in business terms rather than raw foreign keys.

In Oracle EBS 12.1.1 and 12.2.2 the view is used primarily by iProcurement's receipt and return flows, where a buyer or requester reviews goods returned to a supplier, to inventory, or to another organization. Because it joins RCV, PO, HR, and MTL constructs, it is also a convenient source for custom reports and for integration extracts that must reconcile returned quantities against receipts. The view is read-only and derives all values from its base objects; it holds no data of its own.

A notable attribute is RECEIPT_EXCEPTION_FLAG, which is projected directly from RCV_TRANSACTIONS. This flag indicates whether the return transaction is in an exception state and is a frequent filter for users who need to isolate problem receipts from clean ones.

Underlying Base Objects

The view is defined over the following documented base objects:

The view therefore joins transactional receiving data to its purchasing and human-resources context, applying the iProcurement quantity helper to derive net quantities.

Key Columns

Common Use Cases and Queries

Typical scenarios include reviewing returned receipts for a supplier, reconciling net returned quantities against received quantities, and identifying receipts flagged with exceptions.

SELECT receipt_num, po_num, supplier, item_desc, transact_qty,
       primary_uom, transaction_date, receipt_exception_flag
FROM   apps.icx_rcv_returns_v
WHERE  receipt_exception_flag = 'Y'
ORDER BY transaction_date DESC;

The view can also be filtered by supplier or item to support return analysis and by organization to scope results to a specific inventory organization. Because it exposes purchasing and HR-derived columns, it is well suited to ad hoc reporting and to extracts that feed exception dashboards in both 12.1.1 and 12.2.2.