Search Results currency_conversion_rate_date




Overview
Explore in AI Chat

Overview

The APPS.POFV_MC_INBOUND_SHIPMENTS view is a Business Intelligence System view within the Oracle E-Business Suite (EBS) Purchasing application. Its principal function is to expose Multiple Reporting Currencies (MRC) information for inbound shipments. MRC functionality allows an alternative currency to be specified for an inbound shipment based on a given Set of Books, enabling organizations operating under multiple reporting currencies to view shipment and receipt data in the currency appropriate to each reporting ledger.

The view is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2 and carries the FND Design Data identifier PO.POFV_MC_INBOUND_SHIPMENTS. Because it presents a business intelligence-oriented projection of shipment header data joined to currency conversion metadata, it is typically consumed by reporting tools, MRC reconciliation queries, and integration interfaces rather than by transactional forms. Users searching for the column CURRENCY_CONVERSION_RATE_DATE will find it surfaced here, along with the associated rate, rate type, and rate type descriptive attributes.

Underlying Base Objects

The view is defined over two documented base objects:

Both are referenced through APPS synonyms. The view itself is not referenced by any other database object, meaning it functions as a terminal reporting layer with no downstream dependencies within the schema. This design is consistent with a read-only Business Intelligence view intended for query and extraction purposes.

Key Columns

  • SET_OF_BOOKS_ID / SET_OF_BOOKS_NAME — identifies the reporting ledger (Set of Books) under which the MRC amount is expressed; central to MRC segregation.
  • SHIPMENT_ID, SHIPMENT_NUMBER, RECEIPT_NUMBER — the inbound shipment and receipt identifiers sourced from RCV_SHIPMENT_HEADERS.
  • CURRENCY_CONVERSION_RATE_DATE — the date on which the currency conversion rate is effective; this is the column most relevant to the user's search and is critical for rate-timing validation.
  • CURRENCY_CONVERSION_RATE — the numeric exchange rate applied to the shipment.
  • CURRENCY_CONVERSION_RATE_TYPE — the conversion type code linking to GL rate type definitions.
  • RATE_TYPE_NAME / RATE_TYPE_DESCRIPTION — descriptive attributes from GL_DAILY_CONVERSION_TYPES that classify the rate (for example, spot, corporate, or user-defined).

Common Use Cases and Queries

Typical scenarios include reconciling inbound shipment values across reporting currencies, auditing the conversion rate date used for MRC postings, and feeding downstream analytics. A representative query is:

  • Retrieve all MRC shipments for a ledger with their conversion rate details: 
    SELECT set_of_books_name
     , shipment_number
     , receipt_number
     , currency_conversion_rate_date
     , currency_conversion_rate
     , rate_type_name
  FROM apps.pofv_mc_inbound_shipments
 WHERE set_of_books_id = :p_sob_id
 ORDER BY currency_conversion_rate_date;
  • Filter shipments converted using a specific rate type within a date range to validate rate-type usage against GL definitions.
  • Join the view to RCV_SHIPMENT_HEADERS on SHIPMENT_ID to enrich reporting with additional shipment attributes not exposed here.

Because the view is read-only and not referenced by other objects, it is safe to query in parallel reporting jobs without impacting transactional processing.