Search Results mtl_transactions

Overview

GMF_PERIODCLOSE_PVT is a private PL/SQL package body owned by APPS that implements period close functionality for Oracle Process Manufacturing (OPM) process organizations within Oracle E-Business Suite 12.1.1 and 12.2.2. Its stated purpose, per the package header, is to generate period ending balances for processing organizations and to serve as the Period Close Private API for Process Organizations. The package header identifies the module as gmf.plsql.gmf_periodclose_pvt and records its creation by Rajesh Seshadri in June 2005. Because the package is classified as a private API (PVT), it is not intended for direct customer invocation; it functions as an internal engine invoked by the public period close interface and by concurrent programs that drive the OPM accounting period close cycle.

Key Procedures and Functions

The package exposes three documented procedures:

• COMPILE_PERIOD_BALANCES — The principal driver, described in the source header as the "Period Balances Concurrent Program for Process Orgs." It accepts an error buffer, return code, organization identifier, and closing accounting period identifier, and orchestrates the compilation of period ending balances for a given process organization and period.
• COMPILE_INV_PERIOD_BALANCES — Compiles inventory-related period balances for the process organization. This is the component most closely associated with the user search term mtl_transactions, since inventory transaction activity in MTL_MATERIAL_TRANSACTIONS is aggregated to produce period ending inventory balances.
• COMPILE_PERIOD_BALANCES_LE — Compiles period balances for legal entity (LE) level processing, extending the balance compilation to the legal entity dimension required for multi-organization and multi-ledger accounting.

The body also contains private helper procedures, including Log_Msg (writes to the concurrent log file), End_Process (standardizes error status and message handling), and Reset_Period_Status (resets the period status for a given organization and accounting period). Forward cursor declarations, such as c_per, select organization code and process-enabled flags for the organization being closed.

Tables Accessed

All tables are referenced through APPS synonyms. The core OPM period close tables are GMF_PERIOD_BALANCES, GMF_PERIOD_BALANCES_GT (global temporary staging), GMF_PERIOD_BALANCES_S (sequence), GMF_PERIOD_STATUSES, GMF_FISCAL_POLICIES, and GMF_PROCESS_ORGANIZATIONS_GT. Inventory data is sourced from MTL_MATERIAL_TRANSACTIONS (the transaction table matching the user's search), MTL_ONHAND_QUANTITIES_DETAIL (on-hand quantity snapshots), MTL_PARAMETERS and MTL_SECONDARY_INVENTORIES (organization and subinventory setup). General Ledger integration draws on GL_LEDGERS, GL_PERIODS, and GL_PERIOD_STATUSES. Organization classification and user context come from HR_ORGANIZATION_INFORMATION and FND_USER.

Usage Notes

GMF_PERIODCLOSE_PVT is invoked indirectly. The Compile_Period_Balances procedure is designed as a concurrent program entry point, accepting the standard concurrent manager OUT parameters x_errbuf and x_retcode, and is typically submitted through the OPM Period Close or Inventory Period Close concurrent programs rather than called interactively. The ETRM metadata records that the package is referenced by zero other packages, confirming it is a leaf-level API called from concurrent program definitions or, in customized environments, from client extensions. The mtl_transactions search term is relevant when investigating why inventory transactions in MTL_MATERIAL_TRANSACTIONS are not reflected in GMF_PERIOD_BALANCES; the COMPILE_INV_PERIOD_BALANCES procedure performs that aggregation. Because the package contains a Reset_Period_Status helper, it also supports reopening or resetting an organization's accounting period status. As a private API, its signatures are not guaranteed across releases and should not be called directly by customer code.