Search Results gem5_reference_no_s

Overview

GMF_SUBLEDGER_PKG is the Process Manufacturing subledger update package in Oracle E-Business Suite. It drives the Subledger Update Process that transfers cost and accounting distributions originating in Process Manufacturing (OPM) execution and costing activity into the Oracle General Ledger subledger staging tables. The package body header, script version 120.10 dated December 2006, describes the object as the "Subledger Update Process pkg," confirming its role as the controlled entry point for converting OPM cost transactions into journal-ready subledger records.

The package operates at the boundary between OPM costing and financial accounting. It resolves the accounting context — legal entity, ledger, cost type, cost method, calendar, and open period — before processing transactions, and it respects the fiscal policy and period status definitions maintained in the Process Manufacturing costing tables. In the 12.1.1 and 12.2.2 releases it is classified as an OTHER API under the APPS schema, meaning it is a scheduled batch component rather than a published, callable business interface.

Key Procedures and Functions

The documented interface exposes nine procedures and functions. Their roles are described below; parameter lists are not part of the published contract.

• UPDATE_PROCESS — The main driver. It orchestrates the subledger update run, reading qualifying cost transactions and writing the resulting accounting entries into the GMF subledger structures.
• VALIDATE_PARAMETERS — Confirms that the accounting context supplied to the run is complete and consistent, including legal entity, ledger, cost type, cost method, and period.
• INSERT_CONTROL_RECORD — Creates the control row that governs the run. The package notes that scheduled_on in the control table is always set to sysdate, because the program is invoked at the appropriate time by the Concurrent Manager.
• CHECK_COSTING — Verifies the state of costing prior to subledger transfer, ensuring the run is performed against valid, completed cost data.
• POPULATE_GLOBAL — Loads the package-level global variables declared in the specification, such as the legal entity, ledger, cost type, cost method, and current period identifiers, so downstream logic can reference a consistent context.

The remaining documented procedures follow the same pattern of parameter validation, context population, and controlled processing. The body also declares a comprehensive set of FND_LOG runtime level constants and a module name of GMF.PLSQL.GMF_SUBLEDGER_PKG, indicating that all activity is instrumented through the FND logging framework.

Tables Accessed

The package references its tables through APPS synonyms. Costing and method data come from CM_MTHD_MST, which supplies cost method codes and cost type classification. Batch and resource activity is read from GME_BATCH_HEADER and GME_RESOURCE_TXNS. Period and fiscal control is derived from GMF_FISCAL_POLICIES, GMF_PERIOD_BALANCES, and GMF_PERIOD_STATUSES, while GL_LEDGERS, GL_PERIODS, GL_PERIOD_SETS, GL_PERIOD_STATUSES, and GL_SUBR_STA provide the general ledger context and the subledger staging destination. HR_ORGANIZATION_INFORMATION resolves organization-level attributes, and GEM5_REFERENCE_NO_S supplies reference numbers for generated subledger records. FND_APPLICATION and FND_LOG_MESSAGES support application lookup and log message resolution.

Usage Notes

GMF_SUBLEDGER_PKG is normally invoked by a concurrent program submitted through the Concurrent Manager, which is why the control record timestamp is sysdate rather than a user-supplied value. It is not referenced by any other package in the documented metadata, so it sits at the top of its call chain. Custom code should not call the procedures directly; integrations requiring subledger transfer should submit the standard concurrent request instead. Users searching on "order_management" should note that this package belongs to the Process Manufacturing costing and subledger flow, not to order management, and that its cost accounting output ultimately feeds the same general ledger used by order management transaction accounting.