Search Results pmits_final_subledger_v




Overview
Explore in AI Chat

Overview

The APPS.PMITS_FINAL_SUBLEDGER_V view is a reporting and integration object within the PMI (Process Manufacturing Intelligence) module of Oracle E-Business Suite, available in release 12.1.1 and 12.2.2. It exposes the final subsidiary ledger that serves as the liaison between the OPM (Oracle Process Manufacturing) subsystem and the General Ledger. The view consolidates all bookings of OPM subsystem transactions — collectively termed "documents" — into a single queryable structure that mirrors the accounting entries ultimately destined for GL. The view is populated indirectly through the OPM Subsidiary Ledger Update process, which writes accounting lines to the underlying tables that this view projects.

From a reporting perspective, the view is the principal point of access for users who need to reconcile process manufacturing activity against General Ledger balances, audit transaction-to-accounting lineage, or extract subledger detail for downstream data warehouses. Its name and the presence of the SUBLEDGER_ID column reflect its role as the identifier-bearing record set for subledger transactions, making it the natural target for the query term the user searched.

Underlying Base Objects

The documented ETRM metadata identifies two referenced base objects. The first is GL_SUBR_LED_VW, a view over which PMITS_FINAL_SUBLEDGER_V is defined. All columns projected by the final subledger view originate from GL_SUBR_LED_VW; the outer view applies two transformations rather than selecting raw data. The second referenced object is PMI_SECURITY_PKG, a PL/SQL package whose SHOW_RECORD function enforces organization-level security in the view's WHERE clause. Records are returned only when ORGN_CODE is null or when the package function authorizes the current user for that organization, ensuring that process manufacturing data is filtered by the caller's security profile.

Because PMITS_FINAL_SUBLEDGER_V wraps an existing subledger view rather than reading base tables directly, its contents inherit the currency, accounting, and transaction attributes already resolved in GL_SUBR_LED_VW. Analysts should be aware that the update mechanics reside below this layer; the OPM Subsidiary Ledger Update process maintains the data that ultimately flows through the view.

Key Columns

Common Use Cases and Queries

Typical uses include subledger-to-GL reconciliation, investigation of a specific subledger entry or document, and extraction of material versus nonmaterial transaction splits for cost analysis. The following queries reflect the view's structure and filtering behavior.

  • Retrieve all entries for a given subledger record: SELECT * FROM APPS.PMITS_FINAL_SUBLEDGER_V WHERE SUBLEDGER_ID = :p_subledger_id;
  • List material transactions for a period: SELECT DOC_NO, ACCT_NO, AMOUNT_BASE FROM APPS.PMITS_FINAL_SUBLEDGER_V WHERE PERIOD = :p_period AND TRANS_TYPE = 'MATERIAL';
  • Summarize by account and document type: SELECT ACCT_NO, DOC_TYPE, SUM(AMOUNT_BASE) FROM APPS.PMITS_FINAL_SUBLEDGER_V GROUP BY ACCT_NO, DOC_TYPE;
  • Reconcile a transfer document: filter on DOC_TYPE = 'XFER' and use JOIN_DOC_ID to pair related lines.
  • Extract for downstream staging: select SUBLEDGER_ID, VOUCHER_ID, LINE_ID, and amount columns, noting that organization security is applied automatically.