Search Results orgn_co_err

Overview

The APPS.GMI_INVENTORY_CLOSE_CONC package is an Oracle EBS concurrent-program interface package belonging to the Process Manufacturing (OPM/GMI) inventory module. Its business purpose is to execute period-end inventory close processing for a given organization, warehouse, fiscal year, and accounting period within Oracle Process Manufacturing. The package validates the requested close parameters, verifies the state of the GMI inventory calendar and warehouse records, and drives the posting of period balances and closing transactions required to finalize an inventory period.

The source header ($Header: gmisubrs.pls 115.2 ...) identifies the module as part of the GMI subscription/close framework. The package is declared AUTHID CURRENT_USER, and it is classified in the ETRM metadata under an API classification of OTHER, meaning it is not a formally published public API but a supporting concurrent-program wrapper.

The search term "orgn_co_err" maps directly to the package's constant INVCAL_CO_ERR (constant value -24). This is one of the package's predefined return error codes, and it represents an organization/company-level error encountered during inventory calendar validation. Users encountering orgn_co_err in a concurrent request log or error message are seeing a close-validation failure associated with the inventory calendar company/organization check rather than a data corruption issue.

Key Procedures and Functions

The package exposes two documented procedures:

• RUN — The concurrent-program entry point. It receives the standard concurrent manager OUT parameters (errbuf, retcode) plus the close-selection parameters that identify the target close: sequence, fiscal year, period, period ID, start date, end date, operating code, organization code, and close indicator. It orchestrates validation and delegates the actual closing work.
• INVENTORY_CLOSE — Performs the inventory close for a specific fiscal year, period ID, period number, warehouse code, operating code, and period start/end dates. This is the workhorse routine that processes the detailed close logic against the period balance and transaction staging tables.

The package also declares numerous subtypes and constants, including the return-code constants used for error reporting (INVCAL_FISCALYR_ERR, INVCAL_PERIOD_ERR, INVCAL_PERIOD_CLOSED, INVCAL_CO_ERR, INVCAL_WHSE_CLOSED, INVCAL_DATE_PARM_ERR, INVCAL_ORGN_PARM_ERR, INVCAL_WHSE_PARM_ERR, and INVCAL_WHSE_ERR). These negative codes allow the concurrent program to report precise validation failures.

Tables Accessed

• IC_CLDR_DTL — Inventory calendar detail; source of period start/end dates and organization code validation.
• IC_WHSE_MST — Warehouse master; validates warehouse code and status.
• IC_ITEM_MST / IC_ITEM_MST_B — Item master and its base table; item attributes used in balance processing.
• IC_LOCT_MST, IC_LOCT_INV, IC_LOTS_MST — Location master, location inventory (on-hand), and lot master for quantity and lot-level close data.
• IC_TRAN_PND, IC_TRAN_CMP, IC_ADJS_JNL — Pending transactions, completed transactions, and adjustment journals processed during close.
• IC_PERD_BAL — Period balances; the primary target of period-end balance roll-forward.
• GMI_CLOS_WAREHOUSES, GMI_PERD_BAL_ID_S — GMI close warehouse control and the period-balance ID sequence used to generate close records.
• SY_REAS_CDS — Reason codes applied to closing adjustments.
• DUAL — Utility single-row queries for parameter and calendar checks.

Usage Notes

GMI_INVENTORY_CLOSE_CONC is typically invoked by the concurrent manager on behalf of the OPM Inventory Close concurrent program, which passes the P_* run parameters. The RUN procedure is the correct concurrent entry point; INVENTORY_CLOSE should not be called directly unless the caller reproduces the parameter validation performed by RUN.

Because the package is not referenced by any other package per ETRM metadata, it functions as a standalone concurrent wrapper rather than a shared library routine. When troubleshooting the orgn_co_err condition, the concurrent request log should be reviewed for return code -24 (INVCAL_CO_ERR), which directs attention to inventory calendar organization/company setup rather than to transaction data.