Search Results gl_subr_led_vw




Overview
Explore in AI Chat

Overview

APPS.PMITS_FINAL_SUBLEDGER_V is a subledger reporting view in Oracle E-Business Suite (EBS) 12.1.1 / 12.2.2, owned by the APPS schema and delivered as part of the Process Manufacturing (OPM) Financials / ETRM product family. The view presents finalized subledger accounting lines intended for reconciliation, transfer to General Ledger, and downstream reporting. It is a filtering and enrichment wrapper: it selects from the base view GL_SUBR_LED_VW and applies a row-level security predicate so that only subledger records the current user is authorized to see are returned.

The name is significant: the "FINAL" prefix denotes lines that have reached a completed subledger state (e.g., processed costing, closed events), as opposed to provisional subledger entries. This makes the view suitable for period-end close activities, audit trails, and interfaces where only committed subledger activity should be surfaced. Users searching for gl_subr_led_vw are typically trying to trace the origins of these rows; PMITS_FINAL_SUBLEDGER_V is the secured, filtered presentation layer built directly on top of that base view.

Underlying Base Objects

The ETRM metadata documents two referenced objects:

  • GL_SUBR_LED_VW (VIEW) — the primary data source, supplying all subledger columns (source, accounting period, amounts, currency, quantities, and descriptive attributes).
  • PMI_SECURITY_PKG (PACKAGE) — the Process Manufacturing security package, invoked through PMI_SECURITY_PKG.SHOW_RECORD(ORGN_CODE) to enforce organization-level access control.

The view adds one computed column, JOIN_DOC_ID, via a DECODE over DOC_TYPE, and adds a derived materiality flag based on SUB_EVENT_CODE. No base tables are directly referenced; the view is a pure projection over GL_SUBR_LED_VW.

Key Columns

Common Use Cases and Queries

Typical applications include period-end reconciliations, GL transfer verification, audit reporting, and custom ETRM interfaces. Because the view already applies PMI_SECURITY_PKG filtering, reporting tools automatically restrict output to the user's authorized organizations.

Sample query to review finalized subledger activity for an accounting period:

  • SELECT subledger_id, doc_no, acct_no, debit_credit_sign, amount_base, currency_base, gl_trans_date FROM apps.pmits_final_subleger_v WHERE fiscal_year = 2024 AND period = 5 AND orgn_code = 'M1' ORDER BY gl_trans_date;

Sample query isolating material events and joining on the normalized document key:

  • SELECT v.doc_type, v.join_doc_id, v.sub_event_desc, v.amount_trans, v.currency_trans FROM apps.pmits_final_subleger_v v WHERE DECODE(v.sub_event_code,'STEP','NONMATERIAL','CLOS','NONMATERIAL','RVAL','NONMATERIAL','MATERIAL') = 'MATERIAL';

These patterns support reconciliation of OPM subledger balances to GL and provide line-level detail for downstream financial reporting.