Search Results check_valid_uom

Overview

BOM_RESOURCES_PKG is the Oracle Manufacturing (Bills of Material) PL/SQL package that encapsulates the core insert, update, locking, and validation logic for resource definitions stored in the BOM_RESOURCES entity. In Oracle EBS 12.1.1 and 12.2.2, resources represent the people, machines, and outside processing capabilities used to build assemblies, together with their rates, costing attributes, and capacity characteristics. The package declares AUTHID CURRENT_USER and exposes a procedural interface through which Oracle Forms, concurrent programs, and custom extensions can create and maintain resource records consistently, without directly manipulating the underlying base and translation tables. It centralizes uniqueness checking, currency and unit-of-measure validation, and optimistic locking, ensuring that resource data—ranging from cost element and activity associations to batch capacity and competence/qualification attributes—is written according to the application's business rules.

Key Procedures and Functions

• INSERT_ROW — Creates a new resource record, populating columns such as resource code, organization, unit of measure, cost element, purchase item, resource type, autocharge type, basis type, accounts, batch attributes, and the standard DFF attribute columns. It also returns the generated resource identifier and ROWID to the caller.
• LOCK_ROW — Acquires a row-level lock on an existing BOM_RESOURCES row, used to serialize updates in interactive or concurrent processing.
• UPDATE_ROW — Applies changes to an existing resource row, including rate, capacity, costing, and descriptive flexfield attribute updates.
• CHECK_UNIQUE — Validates that a resource code (and related keys) does not already exist within the organization, preventing duplicate resource definitions.
• GET_UOM_FROM_GL_SETS_OF_BOOKS — Retrieves the unit of measure associated with the ledger/set of books context, supporting currency- and UOM-sensitive validations.
• CHECK_VALID_UOM — Confirms that a supplied unit of measure is valid—typically against MTL_UNITS_OF_MEASURE—before a resource is saved. This is the validation invoked when a caller passes a UOM such as an item, batch, or capacity UOM to be verified.

Tables Accessed

The package operates on BOM_RESOURCES and its companion BOM_RESOURCES_S for the base resource data and translation/secure columns. It validates UOM values against MTL_UNITS_OF_MEASURE, which supplies the list of defined units of measure used by UOM validation logic in CHECK_VALID_UOM and related checks. DUAL is used for scalar lookups and expressions that require no physical table access. These references are made through APPS synonyms, so callers must have the appropriate APPS privileges in effect.

Usage Notes

BOM_RESOURCES_PKG is typically invoked indirectly through the Oracle Bills of Material resource maintenance forms and by concurrent or interface programs that load resource definitions. Custom code that needs to programmatically create or update resources should call INSERT_ROW or UPDATE_ROW rather than issuing direct DML, and should invoke CHECK_VALID_UOM to validate user-supplied units of measure beforehand. Because the package uses AUTHID CURRENT_USER, privilege resolution and synonym visibility depend on the calling schema. No packaged objects were documented as referencing this package, indicating it is a lower-level API consumed by forms and external interfaces rather than by other EBS packages.