Search Results ozf_mc_transactions_all




Overview
Explore in AI Chat

Overview

The OZF_MC_TRANSACTIONS_ALL table is a core data object within the Oracle Trade Management (OZF) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. As a multi-currency transaction table, its primary role is to store and manage financial transaction amounts in multiple currencies. This functionality is critical for organizations operating in global markets, enabling them to accurately record, track, and report on transactions such as claims and funds in both the transaction currency and a functional or reporting currency. The table serves as a central ledger for multi-currency conversions, ensuring financial integrity and supporting complex reporting requirements across different geographical entities within the enterprise.

Key Information Stored

While the provided metadata does not list all columns, the documented structure reveals essential fields. The primary key, MC_RECORD_ID, uniquely identifies each multi-currency transaction record. A pivotal column is SOURCE_OBJECT_ID, which functions as a foreign key to link the multi-currency data to its originating transaction in source tables like claims or funds. Typically, such a table would also store columns for the original transaction amount, transaction currency code, converted amount, functional currency code, conversion rate type, conversion date, and conversion rate used. These elements collectively allow the system to maintain a complete audit trail of currency conversions for financial reconciliation and compliance.

Common Use Cases and Queries

This table is fundamental for generating accurate financial reports that consolidate international operations. A common use case involves reconciling the local currency value of a trade promotion claim or fund with its value in the corporate functional currency. For reporting, analysts frequently join this table to its source transaction tables to present both currency perspectives. A typical query pattern would retrieve converted amounts for a specific claim or a set of transactions within a date range. For example, to analyze claim liabilities in the functional currency, a query would join OZF_MC_TRANSACTIONS_ALL to OZF_CLAIMS_ALL on SOURCE_OBJECT_ID, filtering by the relevant claim identifiers and selecting the converted amount and functional currency fields.

Related Objects

The OZF_MC_TRANSACTIONS_ALL table has defined foreign key relationships with two primary transaction tables, as per the provided metadata. These relationships are established through the SOURCE_OBJECT_ID column, which points to records in the following tables:

  • OZF_CLAIMS_ALL: This table stores trade promotion claims. The foreign key link allows each claim's financial data to be associated with its corresponding multi-currency conversion records.
  • OZF_FUNDS_ALL_B: This table stores budget funds for trade promotions. The relationship enables the tracking of fund allocations and utilizations across different currencies.
These relationships are critical for any data retrieval or reporting that requires a unified view of a transaction's monetary value in multiple currencies.