Search Results opi_dbi_inv_value_init_pkg




Overview
Explore in AI Chat

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

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

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.