Search Results get_onhand_balance

Overview

OPI_DBI_INV_VALUE_INIT_PKG is an Oracle EBS inventory valuation initialization package owned by APPS. It is a member of the Operational Intelligence (OPI) Daily Business Intelligence reporting framework and is responsible for establishing the baseline inventory quantity and value balances consumed by the DBI inventory value dashboards. The package is classified as OTHER under the ETRM convention, meaning it is an internal worker rather than a published public API.

The body carries a header timestamp of 2008/03/07 (version 120.31) and is marked noship, confirming it is an internal ETL component rather than a shipped customer API. Its role is to perform the initial (first) extraction of inventory valuation data, seeding the reporting tables with inception balances before incremental daily activity extraction takes over.

Key Procedures and Functions

• RUN_FIRST_ETL — The primary driver procedure. It orchestrates the initial load: seeding inventory type codes, cleaning staging tables, maintaining DBI logs via OPI_DBI_BOUNDS_PKG.MAINTAIN_OPI_DBI_LOGS, and invoking the extraction of inventory transaction quantity and value. It also delegates to OPI_DBI_INV_VALUE_OPM_INIT_PKG.RUN_OPM_FIRST_ETL for process manufacturing, and finally calls GET_INCEPTION_INV_BALANCE. The RUN_FIRST_ETL block is the entry point for the entire initialization flow.
• GET_INCEPTION_INV_BALANCE — Establishes inception-period inventory balances by aggregating on-hand, intransit, WIP, and costed discrete inception quantities. It is the parent of GET_ONHAND_BALANCE, GET_INTRANSIT_BALANCE, GET_WIP_BALANCE, COST_DISCRETE_INCEPTION_QTY, and COST_OPM_INCEPTION balances.
• INTRANSIT_SETUP — Configures intransit inventory parameters required by GET_INTRANSIT_INITIAL_LOAD and downstream balance extraction.
• GET_OPM_ITEM_COST — Retrieves Process Manufacturing (OPM) item cost information used during OPM inception valuation.

The package declares global constants g_sysdate, g_user_id, g_login_id, and configuration globals for inception date, currency codes, and rate types, plus exceptions INITIALIZATION_ERROR (-20900) and UOM_CONV_ERROR (-20901).

Tables Accessed

• GME_BATCH_HEADER, GME_MATERIAL_DETAILS — OPM batch and material detail data used to derive process manufacturing inception quantities and values. These are directly relevant to the searched term gme_batch_headers.
• CST_ITEM_COSTS, CST_STANDARD_COSTS, CST_QUANTITY_LAYERS — Costing sources for discrete inception valuation and quantity layer balances.
• MTL_MATERIAL_TRANSACTIONS, MTL_TRANSACTION_ACCOUNTS — Transaction quantity and accounting value extraction for the initial load.
• MTL_SUPPLY, MTL_SYSTEM_ITEMS, MTL_PARAMETERS, MTL_INTERORG_PARAMETERS — On-hand, item, and organization/parameter configuration used in balance and intransit calculations.
• GMF_TRANSACTION_VALUATION — OPM transaction valuation for process inventory value extraction.
• CM_ALYS_MST, CM_CMPT_MST, CM_MTHD_MST — OPM cost analysis, component, and method master data supporting OPM cost derivation.

Usage Notes

OPI_DBI_INV_VALUE_INIT_PKG is invoked during the initial setup or rebuild of the DBI inventory value reporting area, rather than on a routine schedule. It is referenced by two other packages, confirming it functions as a shared initialization worker within the OPI_DBI family. RUN_FIRST_ETL is the expected entry point; it validates initialization prerequisites and raises INITIALIZATION_ERROR or UOM_CONV_ERROR when fundamental conditions or unit-of-measure conversions fail. Because the package is marked noship and not registered as a public API, it should be called only through the DBI concurrent program or scheduling framework that owns the inventory value initialization sequence, not directly from custom code. The sequential dependency chain embedded in the package header—from discrete first ETL through OPM first ETL to inception balance extraction—must be preserved, as later incremental packages depend on the baseline rows seeded here.