Search Results opi_dbi_inv_value_utl_pkg




Overview
Explore in AI Chat

Overview

The APPS.OPI_DBI_INV_VALUE_UTL_PKG package body is a utility package within the Oracle E-Business Suite Discrete Build/Inventory (OPI/DBI) intelligence schema. It supports the Oracle Inventory and Warehouse Management analytics infrastructure, specifically the value-based inventory reporting and staging processes that populate the Daily Business Intelligence (DBI) inventory value dashboards and related operational reports. In Oracle EBS 12.1.1 and 12.2.2, this package operates against the staging tables that aggregate on-hand quantities, in-transit quantities, beginning balances, WIP balances, and process manufacturing (OPM) inventory positions, converting them into consistent monetary values for downstream reporting.

The package is classified as OTHER in the ETRM repository and is owned by the APPS schema, with a VALID status. It is referenced by three other database objects, indicating it functions as a shared utility layer whose logic is consumed by multiple higher-level collection or reporting programs rather than being invoked directly by end users. Its responsibilities center on currency conversion and availability validation for in-transit inventory, both of which are prerequisites for accurate valuation in the DBI inventory value collection cycle.

Key Procedures and Functions

The ETRM metadata documents two public program units within this package body:

  • GET_CONVERSION_RATE — Retrieves the applicable currency conversion rate required to translate inventory balances into the reporting (functional or ledger) currency. This routine supports multi-currency inventory valuation by resolving rates against the configured conversion rate staging data, ensuring that on-hand, in-transit, and WIP values are expressed in a common currency for aggregation and comparison.
  • CHECK_INTRANSIT_AVAILABILITY — Determines whether in-transit inventory data is available or applicable for the current collection context, typically by evaluating inventory organization parameters and setup configuration. This function acts as a gating check so that valuation logic is only applied when the organization actually maintains in-transit stock, avoiding spurious or zero-value rows in the staging tables.

Tables Accessed

The package reads and writes the following documented objects, primarily through APPS synonyms:

Usage Notes

This package is not exposed through an Oracle Forms UI. It is invoked programmatically during the DBI inventory value collection cycle, either by concurrent programs that populate the OPI_DBI staging tables or by custom code extending DBI inventory reporting. Because it is referenced by three other database objects, dependent packages and collection routines should be considered the typical callers. The STANDARD dependency reflects Oracle's standard PL/SQL package usage. Given its role in currency conversion and in-transit validation, it should be treated as an internal utility; direct modification is unsupported, and customizations should wrap rather than alter the delivered body.