Search Results bom_open_interface_utl




Overview
Explore in AI Chat

Overview

APPS.BOM_OPEN_INTERFACE_UTL is a server-side PL/SQL utility package that drives the bulk upload of bills of material (BOM) data into Oracle E-Business Suite through the open interface tables. Its purpose is to take rows staged in the BOM open interface tables — headers, components, reference designators, substitute components, component operations, and revisions — validate them, and push them into the base BOM and inventory tables. The package is declared AUTHID CURRENT_USER, so it executes with the privileges of the calling schema, and its header identifies the source file as BOMUBOIS.pls.

The package is classified as OTHER in the ETRM 12.2.2 registry, meaning it is not a formally published public API but an internal processing engine. It is primarily the workhorse behind the BOM open interface concurrent programs, which is why it exposes functions that mirror each interface entity rather than a single monolithic entry point. The p_batch_id parameter present on every processing function reflects a batch-processing design added in 2005, allowing one interface run to be scoped and tracked as a discrete batch.

Key Procedures and Functions

The package exposes eight documented functions. Each follows the same calling convention: organization and security context arguments (org_id, all_org, user_id, login_id, prog_appid, prog_id, req_id), an err_text IN OUT NOCOPY parameter for error reporting, and a p_batch_id, returning an INTEGER status.

  • Process_Header_Info — processes header-level BOM interface rows, creating or updating bill of material headers.
  • Process_Comps_Info — processes component interface rows, transferring components into the BOM structures.
  • Process_Ref_Degs_Info — processes reference designator interface rows for components that carry designator assignments.
  • Process_Sub_Comps_Info — processes substitute component interface rows.
  • Process_Comp_Ops_Info — the function matching the search term; it processes component operation rows, moving operation sequence and resource information associated with a component into the base component operations tables.
  • Process_Revision_Info — processes item revision interface rows, validating and loading revisions against inventory item revisions.
  • Process_All_Entities — an orchestration function that invokes the individual entity processors in the correct dependency order.
  • Transaction type constants (G_Create, G_Update, G_Delete, G_NoOp) govern how each interface row is applied.

Tables Accessed

The package operates across the interface and base tables. Interface-side tables include BOM_BILL_OF_MTLS_INTERFACE, BOM_INVENTORY_COMPS_INTERFACE, BOM_COMPONENT_OPS_INTERFACE, BOM_REF_DESGS_INTERFACE, BOM_SUB_COMPS_INTERFACE, and MTL_ITEM_REVISIONS_INTERFACE, which hold staged upload data. Base tables written or validated against include BOM_STRUCTURES_B, BOM_COMPONENTS_B, BOM_REFERENCE_DESIGNATORS, BOM_SUBSTITUTE_COMPONENTS, and MTL_ITEM_REVISIONS_B. Supporting lookups include MTL_PARAMETERS, MTL_ITEM_LOCATIONS, and MTL_INTERFACE_ERRORS for error staging. BOM_INTERFACE_DELETE_GROUPS supports delete-mode processing.

Usage Notes

BOM_OPEN_INTERFACE_UTL is invoked from the BOM open interface concurrent programs and from custom PL/SQL loaders that populate the interface tables and then call the processors. It is referenced by one other package, indicating the usual pattern is orchestration through Process_All_Entities or a wrapper. Direct invocation should supply a valid batch ID, a populated interface set, and the standard concurrent request context, then inspect err_text and MTL_INTERFACE_ERRORS for row-level failures. In 12.1.1 and 12.2.2 the behavior is consistent; the package is not a supported public API and should be treated as internal to the BOM open interface flow.