Search Results rcv_mc_shipment_headers_u1




Overview
Explore in AI Chat

Overview

PO.RCV_MC_SHIPMENT_HEADERS is the Multiple Reporting Currencies (MRC) sub-table for RCV_SHIPMENT_HEADERS in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores currency-related information about shipment and receipt headers for each reporting Set of Books associated with the parent record in RCV_SHIPMENT_HEADERS. While the parent table holds the transactional (primary) currency values of a receipt or shipment header, this table persists the exchange rate metadata needed to restate those amounts in each reporting currency defined for the organization.

The object resides in the PO schema, carries a status of VALID, and is registered in FND Design Data as PO.RCV_MC_SHIPMENT_HEADERS. Physically it is stored in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, while its unique index lives in APPS_TS_TX_IDX. From a heuristic Data Vault modeling perspective, this object is best classified as standalone, meaning it exhibits no mined foreign-key dependencies on other documented objects and functions primarily as a currency-attribution satellite keyed against the shipment header and reporting ledger.

Key Information Stored

The table contains five documented columns and operates on a composite primary key, RCV_MC_SHIPMENT_HEADERS_PK, defined over (SET_OF_BOOKS_ID, SHIPMENT_HEADER_ID). A separate unique index, RCV_MC_SHIPMENT_HEADERS_U1, is defined over the same two columns in the reverse order (SHIPMENT_HEADER_ID, SET_OF_BOOKS_ID) and serves as the primary business-key candidate for direct lookups by header.

  • SET_OF_BOOKS_ID (NUMBER, 15, mandatory) — The reporting Set of Books identifier, indicating which ledger the reporting-currency amounts belong to. Part of both the primary key and the unique index.
  • SHIPMENT_HEADER_ID (NUMBER, 15, mandatory) — The receipt/shipment header identifier that joins directly to RCV_SHIPMENT_HEADERS.SHIPMENT_HEADER_ID. Part of both the primary key and the unique index.
  • CONVERSION_RATE_TYPE (VARCHAR2, 30) — The conversion type (for example, a corporate or spot rate type) governing the exchange rate applied for that reporting ledger.
  • CONVERSION_DATE (DATE) — The effective date used to determine which exchange rate was selected for conversion.
  • CONVERSION_RATE (NUMBER) — The actual rate used to convert the transactional-currency amount into the reporting-currency amount for that Set of Books.

The surrogate primary key is the composite (SET_OF_BOOKS_ID, SHIPMENT_HEADER_ID); no separate single-column surrogate is documented. The unique index effectively enforces one row per header per reporting ledger.

Common Use Cases and Queries

This table is queried almost exclusively when reporting-currency restatement of receipt and shipment amounts must be reconciled or audited. Typical scenarios include verifying the exchange rate applied to a receipt in a secondary ledger, diagnosing discrepancies between transactional and reporting currency balances, and rebuilding MRC data when ledgers or rates change.

A representative join against the parent header table is shown below. Note that the query text mirrors the documented column projection:

  • SELECT m.SET_OF_BOOKS_ID, m.SHIPMENT_HEADER_ID, m.CONVERSION_RATE_TYPE, m.CONVERSION_DATE, m.CONVERSION_RATE FROM PO.RCV_MC_SHIPMENT_HEADERS m WHERE m.SHIPMENT_HEADER_ID = :header_id;
  • SELECT h.SHIPMENT_HEADER_ID, m.SET_OF_BOOKS_ID, m.CONVERSION_RATE FROM PO.RCV_SHIPMENT_HEADERS h, PO.RCV_MC_SHIPMENT_HEADERS m WHERE h.SHIPMENT_HEADER_ID = m.SHIPMENT_HEADER_ID AND m.SET_OF_BOOKS_ID = :sob_id;

Because RCV_MC_SHIPMENT_HEADERS_U1 leads with SHIPMENT_HEADER_ID, single-header lookups are index-supported. Auditors frequently filter by CONVERSION_RATE_TYPE and CONVERSION_DATE to validate rate policy compliance across a period.

Related Objects

The documented dependency list indicates that PO.RCV_MC_SHIPMENT_HEADERS does not reference any database object through declared foreign keys, and is referenced by the APPS synonym RCV_MC_SHIPMENT_HEADERS. The most significant related objects and their join columns are:

  • RCV_SHIPMENT_HEADERS — Parent transactional header table; joined on SHIPMENT_HEADER_ID.
  • RCV_SHIPMENT_LINES — Receipt/shipment lines; linked indirectly via the parent header.
  • RCV_TRANSACTIONS — Receiving transactions referencing the same header and shipment lineage.
  • GL_SETS_OF_BOOKS / FND_SET_OF_BOOKS — Ledger definition joined on SET_OF_BOOKS_ID.
  • APPS.RCV_MC_SHIPMENT_HEADERS — Application synonym used by MRC-enabled forms and concurrent programs.
  • MRC APIs and concurrent programs — MRC conversion and reconciliation processes that read and write these rate rows.