Search Results get_pendingtxncount

Overview

GMF_PERIODCLOSE_PUB is the public PL/SQL API for inventory period close in Oracle Process Manufacturing (OPM). Owned by APPS and classified as a public (PUB) API, it exposes the validation and closing logic that controls whether an inventory organization's accounting period can be successfully closed. The package is the programmatic entry point invoked by the period close forms and concurrent programs to determine whether outstanding transaction activity, open periods, or ordering violations should block the close of a given period.

The package is registered with AUTHID CURRENT_USER and is documented across ETRM 12.2.2, with a source header version of 120.2 (dated 2005). It contains four documented procedures and functions, and is referenced by one other package, indicating that it participates in a broader dependency chain within the OPM inventory and costing modules.

Key Procedures and Functions

• GET_PENDINGTXNCOUNT — Returns counts of transactions that remain outstanding for a given organization and closing period. It distinguishes unprocessed material transactions, pending shipping delivery transactions, unprocessed receiving transactions, and pending material transactions. Per the documented header comments, unprocessed material transactions and pending shipping delivery transactions are mandatory blockers; the existence of unresolved transactions of these types prevents period close from proceeding.
• VERIFY_PERIODCLOSE — Checks that the necessary conditions are met before a period is closed. Based on the documented excerpt, it evaluates the closing accounting period and closing end date and returns indicators such as whether an open period exists (x_open_period_exists) and whether periods are being closed in the proper order (x_proper_order). This is the procedure most directly associated with the "verify_periodclose" search term.
• CLOSE_PERIOD — Performs the actual period close operation once verification has succeeded. It is the final step in the close sequence, executed after validation confirms no blocking conditions remain.
• GET_PREV_INV_PERIOD_STATUS — Retrieves the status of the prior inventory period, supporting the ordered-close validation logic and giving callers visibility into the state of adjacent periods.

Tables Accessed

The package operates against the following tables via APPS synonyms:

• GMF_PERIOD_STATUSES — Stores OPM period status information central to validating and executing period close.
• ORG_ACCT_PERIODS — Provides the open/closed status and date ranges of inventory accounting periods, used by VERIFY_PERIODCLOSE.
• MTL_MATERIAL_TRANSACTIONS_TEMP, MTL_TRANSACTIONS_INTERFACE, and RCV_TRANSACTIONS_INTERFACE — Support the pending transaction counts returned by GET_PENDINGTXNCOUNT, covering unprocessed material and receiving activity.
• MTL_PARAMETERS — Supplies organization-level inventory setup and control flags.
• HR_ORGANIZATION_INFORMATION — Resolves organization classification and attributes for the operating unit or inventory organization.

Usage Notes

GMF_PERIODCLOSE_PUB is typically invoked from the OPM Inventory Period Close form and from concurrent programs that drive the close process. The standard flow calls GET_PENDINGTXNCOUNT and VERIFY_PERIODCLOSE first to surface blocking conditions to the user, then calls CLOSE_PERIOD once validation passes. Because it is a PUB API, it may also be called from custom code and extensions; callers should supply the documented API version parameter and check the returned return status, which indicates success or failure. Custom integrations should invoke verification procedures before attempting close, since the documented mandatory transaction types must be resolved to avoid a failed close attempt.