Search Results gmi_perd_bal_id_s

Overview

GMI_INVENTORY_CLOSE_CONC is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema. It supports the Oracle Process Manufacturing (OPM) inventory period-close process, which finalizes stock balances for a given warehouse and accounting period so that inventory values can be frozen and passed to costing and general ledger. The package is invoked as the underlying program unit of a concurrent program; the suffix "_CONC" indicates it exists to be executed in a concurrent manager context rather than being called interactively from a form. Its status is documented as VALID in ETRM 12.1.1/12.2.2, and the API classification is OTHER, meaning it is not a published public API but an internal OPM routine.

The package does not reference the APPS.GMI_CLOS_WAREHOUSES object by name in a way that creates an outgoing dependency, but it does consume that table as a documented data source to determine which warehouses are eligible for the close run.

Key Procedures and Functions

Two documented procedures are exposed by the package body:

• RUN — The entry point executed by the concurrent manager. It initializes the concurrent request output and log files through FND_FILE and FND_MESSAGE, then drives the close processing across the warehouses selected for the run. It is effectively a driver that sequences the period close logic and reports progress and errors to the concurrent manager log.
• INVENTORY_CLOSE — The worker routine that performs the actual inventory period close for a warehouse and period. It consolidates pending transactions and adjusts the period balance records so that the period can be closed. It relies on the sequence GMI_PERD_BAL_ID_S, which is the source of unique identifiers for rows written to IC_PERD_BAL.

The package body also contains an internal reference to GMICCAL (the OPM calendar package) and to itself (recursive or helper calls), and it reads SY_REAS_CDS for reason code validation when adjustments are written.

Tables Accessed

All table access is via APPS synonyms. The principal tables and their roles are:

• GMI_CLOS_WAREHOUSES — the list of warehouses selected for the close run.
• IC_WHSE_MST, IC_LOCT_MST, IC_ITEM_MST, IC_ITEM_MST_B — warehouse, location and item master data used to validate and enrich transactions.
• IC_LOCT_INV, IC_LOTS_MST — on-hand location inventory and lot balances consumed during the close.
• IC_TRAN_PND, IC_TRAN_CMP, IC_ADJS_JNL — pending transactions, completed transactions and adjustment journal entries posted to the period balance.
• IC_PERD_BAL — the period-balance table that holds the closing balance; new rows receive IDs from the GMI_PERD_BAL_ID_S sequence, which is the object most users are searching for when they reach this package.
• SY_REAS_CDS, DUAL, and FND_FILE/FND_MESSAGE — reason codes, trivial selects, and concurrent output/log handling respectively.

Usage Notes

GMI_INVENTORY_CLOSE_CONC is normally invoked through the OPM Inventory Close concurrent program; the RUN procedure is the concurrent entry point. It is not referenced by any other database object, so no OPM package calls it directly — the only supported invocation path is the concurrent manager or a custom runner that emulates one. When troubleshooting period-close failures, check the concurrent manager log produced via FND_FILE, and verify that GMI_PERD_BAL_ID_S is accessible for generating IC_PERD_BAL primary keys, since a broken or missing sequence is a common cause of close errors in OPM inventory.