Search Results rcv_accounting_events_pk

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:

• RCV_TRANSACTION_ID — the receiving transaction that generated the event; the primary linkage back to the RCV transaction detail.
• EVENT_TYPE_ID — identifies the accounting event type, resolving to RCV_ACCOUNTING_EVENT_TYPES.
• EVENT_SOURCE and EVENT_SOURCE_ID — indicate the originating subsystem and its document identifier.
• DEBIT_ACCOUNT_ID and CREDIT_ACCOUNT_ID — the GL code combination identifiers for the debit and credit sides of the entry.
• PO_HEADER_ID, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_DISTRIBUTION_ID, and PO_RELEASE_ID — the full purchasing document context of the event.
• ORGANIZATION_ID and TRANSFER_ORGANIZATION_ID — the receiving organization and, where applicable, the destination organization for inter-org activity.
• INVENTORY_ITEM_ID, TRANSACTION_QUANTITY, TRANSACTION_UNIT_OF_MEASURE, and PRIMARY_QUANTITY — item and quantity detail.
• TRANSACTION_AMOUNT, UNIT_PRICE, CURRENCY_CODE, CURRENCY_CONVERSION_RATE, and CURRENCY_CONVERSION_TYPE — monetary and currency conversion detail.
• SET_OF_BOOKS_ID and GL_GROUP_ID — the accounting books and GL transfer grouping.
• ACCOUNTED_FLAG — indicates whether the event has been processed into the subledger.
• PROCUREMENT_ORG_FLAG and CROSS_OU_FLAG — flags governing procurement and cross-operating-unit accounting behavior.

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:

• SELECT ae.ACCOUNTING_EVENT_ID, ae.ORGANIZATION_ID, ae.TRANSFER_ORGANIZATION_ID, gcc.CONCATENATED_SEGMENTS FROM PO.RCV_ACCOUNTING_EVENTS ae, GL.GL_CODE_COMBINATIONS_KFV gcc WHERE ae.DEBIT_ACCOUNT_ID = gcc.CODE_COMBINATION_ID;

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

Related Objects

• RCV_TRANSACTIONS — joined on RCV_ACCOUNTING_EVENTS.RCV_TRANSACTION_ID = RCV_TRANSACTIONS.TRANSACTION_ID; the source receiving transaction.
• RCV_ACCOUNTING_EVENT_TYPES — joined on EVENT_TYPE_ID; defines event type semantics.
• RCV_RECEIVING_SUB_LEDGER — references this table on ACCOUNTING_EVENT_ID; the subledger accounting record derived from the event.
• GL_CODE_COMBINATIONS — joined on DEBIT_ACCOUNT_ID and CREDIT_ACCOUNT_ID.
• PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS_ALL, and PO_RELEASES_ALL — the purchasing document hierarchy referenced by the PO foreign keys.
• MTL_PARAMETERS — joined on ORGANIZATION_ID and TRANSFER_ORGANIZATION_ID.
• GL_DAILY_CONVERSION_TYPES and FND_CURRENCIES — provide currency conversion and currency definition context.