Results for “ap_trial_balance_mrc_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The view AP_TRIAL_BALANCE_MRC_V is an Oracle Payables reporting object that exposes trial balance information for Multiple Reporting Currencies (MRC) environments. It is delivered as a retrofitted object, meaning it is carried forward from earlier Oracle EBS releases to preserve backward compatibility for customizations, reports, and integrations that reference the view name. In Oracle EBS 12.1.1 and 12.2.2, the view provides a simplified, reporting-currency-aware projection of payable invoice distribution amounts, allowing users to retrieve accounting and payment information at the distribution level.

The view is significant because it filters records by a set of books identifier derived dynamically from the session context. Specifically, the view restricts output using the predicate SET_OF_BOOKS_ID = NVL(TO_NUMBER(SUBSTRB(USERENV('CLIENT_INFO'), 45, 10)), -99). This mechanism extracts the current reporting set of books from the client information string, enabling the view to return data relevant only to the reporting currency ledger associated with the active user session. In the ETRM documentation, the object is marked as "Not implemented in this database," indicating that it may not exist in every environment and that its availability depends on the installed product and patch level.

Underlying Base Objects

The documented base object for AP_TRIAL_BALANCE_MRC_V is the table AP_MC_TRIAL_BALANCE. The view is defined directly over this table, projecting a subset of its columns without joins to other documented objects in the ETRM metadata. AP_MC_TRIAL_BALANCE stores trial balance rows for reporting currencies, and the view adds a session-based filter on the SET_OF_BOOKS_ID column.

Although the ETRM metadata lists no additional referenced base objects, in practice the underlying table is part of the MRC schema infrastructure in Oracle Payables, which maintains parallel accounting entries for each reporting currency. The view therefore acts as a lightweight, secured access layer over this MRC table, hiding the SET_OF_BOOKS_ID column from the select list while using it as a filtering predicate.

Key Columns

• INVOICE_ID — Identifier of the invoice associated with the trial balance row. This can be used to join back to AP invoices and related tables.
• ACCOUNTING_DATE — The accounting date assigned to the transaction, used for period-based reporting and reconciliation.
• PAYMENT_AMOUNT — The payment amount recorded for the invoice in the reporting currency context.
• DISTRIBUTION_AMOUNT — The amount attributed to the invoice distribution, representing the accounting entry value in the reporting set of books.
• DISTRIBUTION_LINE_NUMBER — The line number of the distribution, which the user specifically searched for. This column identifies the sequential distribution line within the invoice and is essential for drill-down and reconciliation at the distribution granularity.

Common Use Cases and Queries

The view is typically used in custom reports and reconciliation queries that require payable trial balance data in a reporting currency. A common pattern is to select distribution-level amounts for a given accounting period or invoice. For example:

SELECT invoice_id, accounting_date, payment_amount, distribution_amount, distribution_line_number FROM ap_trial_balance_mrc_v WHERE accounting_date BETWEEN :start_date AND :end_date ORDER BY invoice_id, distribution_line_number;

Because the view automatically restricts rows by the session's reporting set of books, callers do not supply a SET_OF_BOOKS_ID predicate. This makes it convenient for multi-currency reporting where the reporting ledger is determined by the user's environment. A frequent use case is joining the view to AP invoice headers or distributions to reconcile MRC trial balance figures with operational Payables data, using DISTRIBUTION_LINE_NUMBER as part of the join or ordering key.

Since the ETRM documentation marks the view as not implemented in the documented database, developers should verify its existence before relying on it. When present, it serves as a stable, retrofitted interface for MRC trial balance reporting in Oracle EBS 12.1.1 and 12.2.2.