Search Results rcv_accounting_events




Overview
Explore in AI Chat

Overview

PO.RCV_ACCOUNTING_EVENTS is the base table that stores receiving accounting events in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Each row represents a discrete, account-generating event that originates from a receiving transaction — for example a receipt, delivery, return to vendor, correction, or a transfer between organizations or operating units. The table captures the event header, the associated purchase order context, the debit and credit account assignments, the transaction quantities and amounts, currency information, and the processing status flags that determine whether the event has been accounted. It is the central staging structure from which receiving accounting entries are created and ultimately transferred to the Receiving subledger and then to General Ledger.

The table is owned by the PO schema in the Purchasing product and is documented in ETRM as VALID with 62 columns. A heuristic Data Vault classification mined from its foreign-key structure places this object as satellite-leaning. In modeling terms, this suggests RCV_ACCOUNTING_EVENTS should be treated as a descriptive satellite of the receiving transaction hub rather than as an independent hub: its identity and much of its business meaning are inherited from RCV_TRANSACTIONS and the surrounding purchasing entities it references by foreign key.

Key Information Stored

The surrogate primary key is ACCOUNTING_EVENT_ID, enforced by the primary key constraint RCV_ACCOUNTING_EVENTS_PK and by the unique index RCV_ACCOUNTING_EVENTS_U1 on the same column. This column is the documented business-key candidate referenced by the Receiving subledger.

The most operationally significant columns include:

Common Use Cases and Queries

Typical uses include reconciliation of receiving activity against GL balances, investigation of unaccounted or failed receipt events, and reporting on accrual and inter-org receiving costs.

To identify unaccounted receiving events for a period:

  • SELECT ACCOUNTING_EVENT_ID, RCV_TRANSACTION_ID, EVENT_TYPE_ID, TRANSACTION_AMOUNT FROM PO.RCV_ACCOUNTING_EVENTS WHERE ACCOUNTED_FLAG = 'N';

To trace an event to its receiving transaction and purchase order line:

  • SELECT ae.ACCOUNTING_EVENT_ID, rt.TRANSACTION_ID, ae.PO_HEADER_ID, ae.PO_LINE_ID, ae.TRANSACTION_AMOUNT FROM PO.RCV_ACCOUNTING_EVENTS ae, PO.RCV_TRANSACTIONS rt WHERE ae.RCV_TRANSACTION_ID = rt.TRANSACTION_ID;

To report on account distribution and organizational impact:

Similar joins support currency reporting through FND_CURRENCIES on CURRENCY_CODE, and intercompany analysis through the organization columns.

Related Objects