Search Results mtl_system_items_s




Overview
Explore in AI Chat

Overview

BOMPLDCI is an Oracle Applications package body owned by the APPS schema and validated in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It belongs to the Oracle Bills of Material product family and serves as a load and validation utility for item and cost data processed through the EBS interface tables. The package name follows the BOM module naming convention, and its documented procedures indicate that it is used during item import and cost interface processing rather than during interactive online entry. Its role is to validate source data, resolve organization context, and move records from interface staging tables into their base transaction tables, which allows external systems, legacy conversions, and bulk data migrations to create or update items, descriptive elements, and cost records through supported Oracle APIs and table structures.

Key Procedures and Functions

ETRM documents two callable units in this package body.

  • GET_VALIDATION_ORG — Resolves and returns the validation organization used during item and cost interface processing. The organization is derived from the BOM parameters and related profile option and responsibility context, ensuring validation, descriptive element, and cost logic is applied against a single, consistent inventory organization.
  • BMLDITE_LOAD_ITEM — Performs the core item load operation for interface processing. It reads staged item records, applies validation against descriptive element structures and flexfield definitions, and moves the validated rows into the base item and descriptive element tables, along with any associated cost information.

Tables Accessed

The dependency list shows the package operating across three functional areas.

Usage Notes

BOMPLDCI is an internal Oracle Applications package and is not a documented public API. It is typically invoked indirectly through Oracle's item import concurrent programs and interface processing routines, including import-related concurrent requests and Oracle Order Management or inventory item processing flows. Because the package depends on MTL_SYSTEM_ITEMS_INTERFACE and MTL_SYSTEM_ITEMS_INTERFACE_S, records must first be staged into those interface tables before the load logic executes. The reference to SO_LINES_ALL and MTL_SALES_ORDERS indicates that sales order and demand references can appear in the source data and are validated during processing.

Custom code should not call BOMPLDCI procedures directly. The supported approach for item and cost loading is to populate the documented interface tables and submit the standard Oracle import concurrent programs, allowing the package to manage validation, organization context, and concurrent-safe sequencing. The MTL_SYSTEM_ITEMS_S and MTL_SYSTEM_ITEMS_INTERFACE_S references confirm that multi-organization views, rather than the base tables alone, are used in the load path, so callers must ensure the correct operating unit and organization context is set. The package is not referenced by any other database object, so changes in release upgrades should be reassessed independently.