Search Results check_intransit_availability

Overview

OPI_DBI_INV_VALUE_UTL_PKG is a utility package in the Oracle E-Business Suite Applications (APPS) schema, delivered as part of the Oracle Product Information (OPI) reporting and analytics layer used by the Discrete/Process Inventory intelligence dashboards. The package is classified as an OTHER API and is declared with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the calling user rather than the definer. Its header identifies it as a "noship" build (115.1), dating to April 2003, indicating it belongs to the original inventory valuation reporting infrastructure.

The package provides shared helper logic for the inventory value and intransit reporting tables that feed the Daily Business Intelligence (DBI) inventory subject areas. Broadly, it supports two concerns: currency conversion rate retrieval and validation of intransit availability conditions. The package is referenced by three other database objects, confirming it acts as a low-level utility layer rather than an end-user entry point.

Key Procedures and Functions

The ETRM metadata documents two callable functions:

• GET_CONVERSION_RATE — Returns a NUMBER. Its signature includes errbuf and retcode parameters declared IN OUT NOCOPY, which is the standard Oracle Concurrent Programs convention for reporting status and error text. This indicates the function is designed to be invoked from a concurrent program, where it resolves currency conversion rates used to normalize inventory valuation figures into a reporting currency.
• CHECK_INTRANSIT_AVAILABILITY — Accepts an organization identifier (p_org_id) and returns a NUMBER. This is the function associated with the user search term "check_intransit_availability." It evaluates whether intransit inventory data is available or valid for the specified inventory organization, allowing downstream extraction or reporting logic to branch on that condition. It is likely used as a guard before populating or querying intransit staging data.

Parameter lists beyond those shown in the header excerpt should not be assumed; only the return type and, for CHECK_INTRANSIT_AVAILABILITY, the single organization parameter are documented.

Tables Accessed

The package reads and writes the following tables via APPS synonyms:

• MTL_PARAMETERS and HR_ORGANIZATION_INFORMATION — source inventory organization attributes and classification, used to resolve organization context and validate the supplied org identifier.
• OPI_DBI_CONVERSION_RATES — stores conversion rate data consumed or produced by GET_CONVERSION_RATE.
• OPI_DBI_INTRANSIT_STG — intransit staging table central to CHECK_INTRANSIT_AVAILABILITY.
• OPI_DBI_INV_BEG_STG, OPI_DBI_ONHAND_STG, OPI_DBI_ONH_QTY_STG, OPI_DBI_OPM_INV_STG, OPI_DBI_WIP_STG — the remaining valuation staging tables covering beginning balances, on-hand quantities, OPM inventory, and WIP, which the package supports during extraction and validation.

Usage Notes

This package is typically invoked indirectly. GET_CONVERSION_RATE is structured for concurrent program invocation, evidenced by the errbuf/retcode convention, and would be called during the DBI inventory value data load. CHECK_INTRANSIT_AVAILABILITY is a programmatic guard, called by the three dependent packages or by custom extraction code before processing intransit staging data for a given organization. Direct invocation from Oracle Forms is unlikely. Custom extensions should call these functions within PL/SQL, respecting the AUTHID CURRENT_USER behavior, which requires the calling schema to hold appropriate privileges on the underlying OPI_DBI and MTL tables.