Search Results pa_mc_txn_interface_all




Overview
Explore in AI Chat

Overview

The PA_MC_TXN_INTERFACE_ALL table is a core data structure within Oracle E-Business Suite (EBS) Projects module, specifically for versions 12.1.1 and 12.2.2. It serves as a staging table for multi-currency transaction data imported from external sources into the Projects application. Its primary role is to hold transactional information, such as costs and revenue, for each reporting set of books (SOB) during the interface process. This enables the system to manage and convert project transactions across different currencies and ledgers, which is essential for organizations operating in a global environment with multiple reporting requirements. The table is a critical component in the flow of data from external feeder systems into the Projects module's multi-currency accounting infrastructure.

Key Information Stored

The table stores interface records keyed by the reporting set of books and the original transaction interface identifier. While the full column list is not exhaustively detailed in the provided metadata, the primary and foreign key relationships indicate the core data elements. Each record is uniquely identified by the combination of SET_OF_BOOKS_ID and TXN_INTERFACE_ID. The table holds currency-specific information for each transaction, including the CURRENCY_CODE for the amount and the RATE_TYPE used for conversion. It logically stores the transaction amounts (e.g., raw cost, burdened cost) in the specified currency, which are later converted and transferred to the primary project accounting tables.

Common Use Cases and Queries

The primary use case is troubleshooting and validating the multi-currency interface process. When transactions fail to transfer from the interface tables to the final project expenditure tables, this table is queried to identify currency conversion or set of books mapping issues. Common SQL patterns involve joining to the primary transaction interface table to get source transaction details and to the sets of books table to identify the reporting ledger.

  • Identifying Pending Interface Records for a Reporting SOB: SELECT * FROM pa_mc_txn_interface_all WHERE set_of_books_id = &reporting_sob_id;
  • Validating Currency Conversion for Interfaced Transactions: SELECT mc.*, txn.source_trx_reference FROM pa_mc_txn_interface_all mc, pa_transaction_interface_all txn WHERE mc.txn_interface_id = txn.txn_interface_id AND mc.currency_code IS NULL;

Related Objects

The table maintains defined foreign key relationships with several fundamental EBS tables, as documented in the metadata.

  • PA_TRANSACTION_INTERFACE_ALL: The source transaction interface. Joined via TXN_INTERFACE_ID to retrieve the original imported transaction details.
  • GL_SETS_OF_BOOKS (GL_SETS_OF_BOOKS_11I): The reporting set of books. Joined via SET_OF_BOOKS_ID to identify the specific ledger for which the multi-currency record is staged.
  • FND_CURRENCIES: The currency of the transaction amount. Joined via CURRENCY_CODE.
  • GL_DAILY_CONVERSION_TYPES: The exchange rate type (e.g., Corporate, Spot) used for conversion. Joined via RATE_TYPE.

These relationships position PA_MC_TXN_INTERFACE_ALL as a central link between the project transaction interface, the general ledger structure, and the currency conversion mechanism.