Results for “open_flag”

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

Overview

GMF_XLA_COST_RVAL_V is an APPS-owned database view in Oracle E-Business Suite, shipped as part of the GMF (Process Manufacturing Financials) product family. It belongs to the subledger accounting valuation layer of Oracle Process Manufacturing and exposes period-end inventory valuation balances in a denormalized, reporting-friendly form. Unlike the underlying transactional tables, which store identifiers and foreign keys, this view resolves those keys into descriptive attributes such as ledger name, period name, organization code, item number, lot number, and UOM codes.

Its principal role is to serve as a single query surface for cost valuation reporting and for downstream integration. Because it joins the GMF period balance table to the XLA extract headers, each row represents a valuation balance for a specific ledger, cost type, accounting period, organization, item, and lot. The view includes a large number of TO_CHAR conversions on numeric and date columns, which makes the output directly consumable by reporting tools and external systems that expect character-formatted values. This view is common on both Oracle EBS 12.1.1 and 12.2.2, where it is used within the same schema context, though the XLA-based subledger architecture is more fully integrated in 12.2.x.

Underlying Base Objects

The view is defined over six documented base objects in the APPS schema: GL_LEDGERS (synonym), GMF_PERIOD_BALANCES (synonym), GMF_XLA_EXTRACT_HEADERS (synonym), MTL_ITEM_FLEXFIELDS (view), MTL_PARAMETERS (synonym), and ORG_ACCT_PERIODS (synonym). The primary driving table is GMF_PERIOD_BALANCES, aliased BAL, which supplies the period balance identifier, quantities, subinventory, and lot details.

GMF_XLA_EXTRACT_HEADERS (EH) is joined on transaction identifier, organization, and inventory item, and contributes the valuation cost type, event class code, ledger identifier, and transaction date. GL_LEDGERS (LED) provides the ledger name. ORG_ACCT_PERIODS (OACP) supplies the accounting period attributes, including period set name, year, number, start date, close dates, and the summarized indicator. MTL_ITEM_FLEXFIELDS (ITEM) resolves the item number and UOM codes, while MTL_PARAMETERS (MP) supplies the organization code. Because all joins are inner joins on matching identifiers, only balances with a corresponding extract header and complete reference data are returned.

Key Columns

• TRANSACTION_ID — derived from BAL.PERIOD_BALANCE_ID, the unique balance identifier.
• LEDGER_ID / LEDGER_NAME — the ledger context for the valuation, from GL_LEDGERS.
• VALUATION_COST_TYPE_ID / VALUATION_COST_TYPE — the cost method associated with the extracted event.
• EVENT_CLASS_CODE — the XLA event class driving the valuation.
• ACCT_PERIOD_ID, PERIOD_NAME, PERIOD_YEAR, PERIOD_NUM — accounting period identification from ORG_ACCT_PERIODS.
• PERIOD_START_DATE, SCHEDULE_CLOSE_DATE, PERIOD_CLOSE_DATE, OPEN_FLAG, SUMMARIZED_FLAG — period status and lifecycle attributes. SUMMARIZED_FLAG, the term the user searched for, indicates whether the accounting period has been summarized, which is significant for reconciliation and period-close reporting.
• ORGANIZATION_CODE / SUBINVENTORY_CODE — inventory location context.
• ITEM_NAME, LOT_NUMBER, PRIMARY_UOM_CODE, SECONDARY_UOM_CODE — item and lot identification.
• PRIMARY_QUANTITY, INTRANSIT_PRIMARY_QUANTITY, SECONDARY_QUANTITY, INTRANSIT_SECONDARY_QUANTITY — on-hand and in-transit quantities formatted as character strings.

Common Use Cases and Queries

Typical uses include period-end cost valuation reports, subledger reconciliation, lot-level inventory inquiry, and data extraction for external costing systems. A representative query filtering on summarized periods is shown below.

SELECT ledger_name, period_name, organization_code, item_name, lot_number, primary_quantity, summarized_flag FROM app.gmf_xla_cost_rval_v WHERE summarized_flag = 'Y' AND period_name = :p_period ORDER BY ledger_name, organization_code, item_name;

Analysts often aggregate quantities by organization and cost type, or join the view back to item master and cost tables for margin and valuation analysis. Because the view performs formatting conversions, consumers should cast quantities appropriately if numeric arithmetic is required. The documented structure confirms that the view is a straightforward, fully joined projection across the GMF period balance, XLA extract header, and GL period reference data.