Search Results bom_bom_copyorg_imp




Overview
Explore in AI Chat

Overview

BOM_BOM_COPYORG_IMP is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the ETRM metadata as an "OTHER" API. Its name reflects its function: it supports the Copy Bill of Materials From Template and cross-organization copy operations within Oracle Bills of Material. In EBS 12.1.1 and 12.2.2, the package provides the import-side logic used when BOM structures are copied from a source organization (or a template bill) into a destination organization. The "IMP" suffix indicates it is the import routine invoked after source data has been staged, extracting component, substitute, reference designator, and routing information and writing it into the target organization's engineering or manufacturing bill of materials. The ETRM record notes a Status of VALID and documents a dependency on SYS.STANDARD, confirming it is a supported, active object in the APPS schema.

Key Procedures and Functions

ETRM documents a single public procedure for this package:

  • IMPORT_BOM — the entry point that performs the import of a bill of materials into the destination organization. It orchestrates the reading of staged source data and the insertion of the corresponding BOM records, drawing on the tables listed below to resolve the target organization parameters and item identifiers before populating component-level structures. No parameter list is documented in the ETRM metadata, so signature details should be confirmed against the live package specification in the target environment.

The package body also appears in the ETRM record under "Package Body," and the object is self-referenced in the dependency listing, which is consistent with typical BOM copy packages that call internal helper routines not exposed as public APIs.

Tables Accessed

The documented table references, resolved through APPS synonyms, define the data footprint of the import operation:

  • BOM_COMPONENT_OPERATIONS — routing/operation associations for components in the copied bill, written when the source BOM carries operation assignments.
  • BOM_REFERENCE_DESIGNATORS — reference designator details for components, preserved during the copy.
  • BOM_SUBSTITUTE_COMPONENTS — substitute component records, copied so that approved alternates carry over to the destination organization.
  • MTL_PARAMETERS — organization-level parameters used to validate the destination organization and determine default behavior for the import.
  • MTL_SYSTEM_ITEMS_KFV — the item key flexfield view, used to resolve and validate item identifiers in the destination organization.
  • PLITBLM — a standard Oracle PL/SQL table type used for in-memory collections during processing.

Usage Notes

BOM_BOM_COPYORG_IMP is not intended for direct invocation by end users. In practice it is called by the Oracle Bills of Material forms and concurrent programs that implement "Copy Bill from Template" and cross-organization BOM copy, including the standard copy concurrent request. Custom or extension code should invoke the supported public API surface rather than the internal routines, and only after validating that the destination organization, item, and bill parameters are correctly set up, since the procedure relies on MTL_PARAMETERS and MTL_SYSTEM_ITEMS_KFV for resolution. Because ETRM records it with an "OTHER" API classification and zero referencing packages, it should be treated as an internal implementation package; Oracle does not publish a formal parameter contract for it, and its signature may change between patch levels. Integrations requiring BOM copy should use the documented open interfaces or the standard concurrent program instead.