Search Results inv_decimals_pub




Overview
Explore in AI Chat

Overview

INV_DECIMALS_PUB is a public PL/SQL API belonging to the Oracle Inventory (INV) application, owned by the APPS schema and shipped in a VALID state in Oracle E-Business Suite 12.1.1 and 12.2.2. The package encapsulates the business rules that govern unit of measure (UOM) precision handling within Oracle Inventory. Inventory quantities in EBS are not stored or displayed with arbitrary precision; each unit of measure carries decimal-precision attributes (for example, a primary quantity precision and a secondary quantity precision) that determine how many fractional digits are meaningful, how values are rounded, and whether two quantities may be considered equivalent.

The package therefore provides a centralized, server-side implementation of quantity validation, conversion, and comparison logic. By exposing this logic through a public API rather than embedding it in individual forms or reports, Oracle ensures that every consumer applies identical rounding and tolerance rules, which is essential for inventory accuracy, transaction validation, and cross-UOM consistency. The package follows the standard EBS API conventions, leveraging FND_API, FND_MSG_PUB, and FND_MESSAGE for the error-handling and message framework, FND_PROFILE for profile option retrieval, and INV_CONVERT for UOM conversion rate lookups.

Key Procedures and Functions

The ETRM documentation identifies seven documented entry points in this public package. They are described below by purpose; parameter lists are intentionally not reproduced here.

  • VALIDATE_COMPARE_QUANTITIES — Validates whether two quantities expressed in related units of measure can be legitimately compared, applying UOM decimal-precision and conversion rules before the comparison is accepted.
  • CONVERT_UOM — Converts a quantity from one unit of measure to another, returning the converted value adjusted to the decimal precision of the target UOM rather than a raw floating-point result.
  • GET_UOM_PROPERTIES — Retrieves the decimal-precision attributes associated with a given unit of measure, allowing callers to determine the number of meaningful fractional digits for quantity handling.
  • COMPARE_QUANTITIES — Compares two quantities for equality or relative magnitude, taking into account the precision tolerances implied by their units of measure so that insignificant fractional differences do not produce false mismatches.
  • VALIDATE_QUANTITY — Validates that a supplied quantity conforms to the precision rules of its unit of measure, flagging values that exceed the permitted number of decimal digits.
  • GET_PRIMARY_QUANTITY — Returns the primary quantity associated with a UOM or item context, supporting the derivation of the base quantity used in inventory transactions and balances.

One additional documented procedure is named in the ETRM inventory of entry points; the six above constitute the substantive functional surface used by callers.

Tables Accessed

The only documented table referenced by INV_DECIMALS_PUB (through APPS synonyms) is MTL_SYSTEM_ITEMS. This table is the master definition of inventory items and stores the primary unit of measure and related UOM attributes for each item. The package reads MTL_SYSTEM_ITEMS to resolve the UOM context for an item when validating, converting, or comparing quantities, since the applicable precision rules depend on the item's designated UOM. No documented write operations against this table are attributed to the package; it functions as a reference read. The package additionally depends on INV_CONVERT, which encapsulates the MTL_UOM_CONVERSIONS logic used to obtain conversion rates between units of measure.

Usage Notes

INV_DECIMALS_PUB is a widely consumed inventory utility. ETRM records indicate it is referenced by 42 other database objects, making it one of the more heavily depended-upon public APIs in the Inventory schema. It is typically invoked from Inventory forms and concurrent programs that must validate or convert quantities, from other inventory APIs that need consistent precision handling, and from custom extensions that perform quantity arithmetic against Inventory data. The package is not documented as being referenced by any object in the reverse direction beyond its consumers, confirming its role as a leaf-level utility API.

Custom code should call this package rather than reimplementing rounding logic, because the profile options and item-level UOM attributes resolved at runtime determine the correct precision behavior. Because the package raises errors through FND_MSG_PUB, callers should follow the standard EBS API error-handling pattern: check the returned status and, on failure, retrieve and process the message stack before proceeding.