Search Results transaction_types

Overview

APPS.BOM_OPEN_INTERFACE_UTL is an internal PL/SQL utility package belonging to the Oracle Bills of Material (BOM) application family. Its principal business function is to support the open interface import process that loads bill of material structures, components, reference designators, component operations, and revision data from external or legacy sources into Oracle EBS. The package body pre-processes staged interface records, resolves surrogate keys such as bill sequence identifiers, assembly item identifiers, organization identifiers, and alternate BOM designators, and populates user-friendly descriptive columns so that the subsequent import/concurrent processing can validate and apply the data. Error rows are written to MTL_INTERFACE_ERRORS when validation fails, enabling users to review and correct rejected records before resubmission.

Key Procedures and Functions

• PROCESS_HEADER_INFO — Populates user-friendly columns for bill header records in BOM_BILL_OF_MTLS_INTERFACE and resolves bill sequence IDs, assembly item IDs, organization IDs, and alternate BOM designators for updates and deletes. It returns 0 on success or a SQLCODE on failure.
• PROCESS_COMPS_INFO — Processes component-level interface rows, deriving and populating descriptive attributes required before the component import is executed.
• PROCESS_REF_DEGS_INFO — Handles reference designator interface rows, preparing them for import into the reference designator structures.
• PROCESS_SUB_COMPS_INFO — Processes substitute component interface rows so that alternate components attached to a bill are correctly resolved and staged.
• PROCESS_COMP_OPS_INFO — Processes component operation interface rows, supporting the linkage of routing operations to BOM components.
• PROCESS_REVISION_INFO — Prepares item revision interface rows, resolving revision identifiers and related descriptive data.
• PROCESS_ALL_ENTITIES — The coordinating procedure that drives processing across all supported entities (headers, components, reference designators, substitutes, component operations, and revisions) in a single invocation.

The package also references a batch identifier parameter that was added in later revisions to support grouped processing of interface records.

Tables Accessed

The package reads and writes the primary BOM interface table BOM_BILL_OF_MTLS_INTERFACE and the associated interface tables BOM_INVENTORY_COMPS_INTERFACE, BOM_REF_DESGS_INTERFACE, BOM_SUB_COMPS_INTERFACE, BOM_COMPONENT_OPS_INTERFACE, and MTL_ITEM_REVISIONS_INTERFACE. It validates against the base definition tables BOM_STRUCTURES_B, BOM_COMPONENTS_B, BOM_REFERENCE_DESIGNATORS, BOM_SUBSTITUTE_COMPONENTS, MTL_ITEM_REVISIONS_B, MTL_ITEM_LOCATIONS, and MTL_PARAMETERS. Rejected or invalid rows are logged to MTL_INTERFACE_ERRORS, and BOM_INTERFACE_DELETE_GROUPS is referenced to manage batch delete operations.

Usage Notes

BOM_OPEN_INTERFACE_UTL is not intended for direct invocation by end users. It is called by the Bills of Material open interface concurrent programs and related import processes that stage data in the BOM interface tables. Because the package is referenced by another package in the BOM module, customizations should avoid modifying it and instead invoke the standard concurrent program that orchestrates the interface. In the context of the search term transaction_types, the package does not itself expose a transaction type parameter; transaction semantics are governed by the process_flag values on the interface rows, where specific flag values indicate insert, update, or delete operations processed by these routines.