Search Results current_fiscal_year

Overview

PMIFV_INVENTORY_TRANSACTIONS_V is an APPS-owned database view within the Process Manufacturing Intelligence (PMI) product family of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. It consolidates detail information about all completed and pending inventory transactions into a single unified result set, allowing reporting and analytical tools to query transaction activity without joining separate completion and pending tables directly.

The view is particularly relevant to users searching on the term current_period. Because each transaction row is joined to the PMI inventory calendar through date-range logic, the view exposes fiscal year, period, period description, and period start/end dates. This makes it the natural source for period-aware inventory reporting, where users need to isolate transactions falling within the open or current accounting period rather than filtering raw transaction dates manually.

Underlying Base Objects

The view is defined as a UNION ALL of two symmetric branches. The first selects from IC_TRAN_CMP (completed transactions) and the second from IC_TRAN_PND (pending transactions); each branch is literaled with a discriminator value ('C' for completed, 'P' for pending). Both branches are joined to IC_ITEM_MST for item attributes and to PMI_INV_CALENDAR_V for calendar attributes.

• IC_TRAN_CMP (SYNONYM) — source of completed inventory transactions.
• IC_TRAN_PND (SYNONYM) — source of pending inventory transactions.
• IC_ITEM_MST (SYNONYM) — item master providing ITEM_NO, ITEM_DESC1, and ITEM_UM.
• PMI_INV_CALENDAR_V (VIEW) — supplies FISCAL_YEAR, PERIOD, PERIOD_DESC, START_DATE, and END_DATE.
• GMICUOM (PACKAGE) — provides I2UOM_CV for unit-of-measure conversion.
• PMI_COST_ANALZ_PACK (PACKAGE) — provides GMCA_GET_MEANING for decoding line type.
• PMI_SECURITY_PKG (PACKAGE) — enforces organization-level record security through SHOW_RECORD.
• SY_ORGN_MST (SYNONYM) — organization master referenced in the documented object set.

Key Columns

• Type discriminator — the first column ('C' or 'P') distinguishes completed from pending transactions.
• TRANS_ID, LINE_ID, ITEM_ID — primary transaction and item identifiers.
• CO_CODE, ORGN_CODE, WHSE_CODE, LOCATION — company, organization, warehouse, and storage location context.
• LOT_ID, LOT_STATUS, QC_GRADE — lot and quality attributes.
• TRANS_DATE — truncated transaction date used for calendar matching.
• TRANS_QTY, TRANS_QTY2, TRANS_UM, TRANS_UM2 — quantities and their units of measure, with conversion applied via GMICUOM.I2UOM_CV.
• FISCAL_YEAR, PERIOD, PERIOD_DESC, START_DATE, END_DATE — calendar columns that identify the accounting period, including the current period.
• GL_POSTED_IND, EVENT_ID, TRANS_STAT — posting and status indicators.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — audit columns.

Common Use Cases and Queries

The view supports period-scoped inventory reporting, reconciliation between completed and pending movements, and lot-level traceability. A typical query filtering to the current accounting period uses the calendar columns exposed by the view:

• Reporting all transactions for an organization within the current period by comparing SYSDATE against START_DATE and END_DATE.
• Comparing completed versus pending activity by grouping on the type discriminator.
• Extracting UOM-normalized quantities for cost or yield analysis.
• Auditing GL posting status via GL_POSTED_IND for a given fiscal year and period.

Sample SQL:

SELECT TRANS_ID, ITEM_NO, ORGN_CODE, TRANS_QTY, TRANS_UM, FISCAL_YEAR, PERIOD, PERIOD_DESC FROM APPS.PMIFV_INVENTORY_TRANSACTIONS_V WHERE TRUNC(SYSDATE) BETWEEN START_DATE AND END_DATE AND ORGN_CODE = :org;

Oracle organization security is applied automatically through PMI_SECURITY_PKG.SHOW_RECORD, so results are restricted to organizations the querying user is permitted to view.