Search Results rcv_receiving_sub_ledger




Overview
Explore in AI Chat

Overview

RCV_RECEIVING_SUB_LEDGER is the receiving subledger table in Oracle E-Business Suite, owned by the PO (Purchasing) schema. It stores the accounting distributions generated by Oracle Receiving for inventory and non-inventory receipt transactions. Every time a receipt, delivery, return, correction, or adjustment is processed in the receiving module, the accounting engine derives debit and credit entries that are persisted as rows in this table before being transferred to Oracle General Ledger through the Subledger Accounting (SLA) or the legacy Journal Import interface. In release 12.x, this table operates alongside the Receiving Accounting Events and SLA models, but it remains the physical store of the create-accounting entry distributions that feed GL_JE_LINES and, in SLA-enabled installations, the corresponding XLA tables.

From a Data Vault modeling perspective, the FK structure suggests this object be modelled as a link table. It resolves multiple relationships: the receiving transaction that triggered the accounting (RCV_TRANSACTION_ID), the event that grouped it (ACCOUNTING_EVENT_ID), the accounting flexfield combination (CODE_COMBINATION_ID), the ledger (SET_OF_BOOKS_ID), and the currency used (CURRENCY_CODE). Each row is a definite accounting fact and should be treated as immutable once posted.

Key Information Stored

The documented physical schema contains 77 columns. The most significant are:

Common Use Cases and Queries

The table is heavily used for reconciliation between Receiving and General Ledger, and for extraction into custom subledger data warehouses.

  • Reconcile receiving accounting to GL by period: 
    SELECT r.period_name, SUM(r.accounted_dr), SUM(r.accounted_cr)
FROM   po.rcv_receiving_sub_ledger r
WHERE  r.set_of_books_id = :ledger_id
AND    r.period_name = :period
GROUP BY r.period_name;
  • Trace a receipt to its accounting entries: 
    SELECT r.rcv_transaction_id, r.code_combination_id, r.accounted_dr, r.accounted_cr
FROM   po.rcv_receiving_sub_ledger r
WHERE  r.rcv_transaction_id = :transaction_id;
  • Identify entries not yet transferred to GL (missing GL_SL_LINK_ID or DATE_CREATED_IN_GL is null) to diagnose stalled SLA/Journal Import processes.
  • Report accrue-on-receipt versus accrue-at-period-end splits via ACCRUAL_METHOD_FLAG.

Related Objects

  • RCV_TRANSACTIONS — joined on RCV_TRANSACTION_ID; the receipt/delivery source transaction.
  • RCV_ACCOUNTING_EVENTS — joined on ACCOUNTING_EVENT_ID; event that grouped accounting lines.
  • GL_CODE_COMBINATIONS — joined on CODE_COMBINATION_ID; account definition.
  • GL_SETS_OF_BOOKS — joined on SET_OF_BOOKS_ID; ledger definition.
  • FND_CURRENCIES — joined on CURRENCY_CODE and FUNCTIONAL_CURRENCY_CODE.
  • GL_ENCUMBRANCE_TYPES — joined on ENCUMBRANCE_TYPE_ID for budgetary entries.
  • GL_MGT_SEG_UPGRADE_H — joined on CHART_OF_ACCOUNTS_ID; chart of accounts structure reference.
  • XLA subledger tables (e.g., XLA_AE_LINES) where SLA is enabled, linked via GL_SL_LINK_ID.