Search Results rcv_transactions




Overview
Explore in AI Chat

Overview

RCV_TRANSACTIONS is the core receiving transactions table in Oracle E-Business Suite, owned by the PO (Purchasing) schema and validated across release 12.1.1 and 12.2.2. Each row represents a single discrete receiving event performed in the Receiving module, whether a receipt, inspection, delivery, return to vendor, transfer, or correction. Because every quantity movement associated with inbound goods and services passes through this table, it functions as the authoritative record of material receipts and the pivot point between Procurement, Inventory, Payables, Cost Management, and WIP.

The table is classified heuristically as hub-leaning under a Data Vault modeling approach. With 134 documented columns, a stable unique surrogate key (TRANSACTION_ID), and an extensive web of foreign keys to purchasing, inventory, vendor, routing, and job definition objects, it behaves as a central transactional hub surrounded by numerous dependent link and satellite structures.

Key Information Stored

The primary key is RCV_TRANSACTIONS_PK, defined on the TRANSACTION_ID column, which is also documented as the single-business-key unique index (RCV_TRANSACTIONS_U1). TRANSACTION_ID is the surrogate identifier used by all downstream dependent tables.

Common Use Cases and Queries

Receiving analysts, buyers, and cost accountants query RCV_TRANSACTIONS to reconcile receipts against purchase orders, confirm accrual postings, trace returns, and validate the receipt-to-invoice match. A typical pattern retrieves receipts for a purchase order line:

SELECT transaction_id, transaction_type, transaction_date, quantity,
       unit_of_measure, inspection_status_code
FROM   rcv_transactions
WHERE  po_line_id = :po_line_id
AND    transaction_type IN ('RECEIVE','DELIVER','RETURN TO VENDOR');

Returns and corrections are located through the self-join on PARENT_TRANSACTION_ID, while reconciliation reporting frequently joins RCV_TRANSACTIONS to MTL_MATERIAL_TRANSACTIONS on INV_TRANSACTION_ID to confirm that each receipt generated a valid inventory movement. Subscription and period-end reporting often aggregate quantities by VENDOR_ID, ORGANIZATION_ID, or TRANSACTION_DATE.

Related Objects