Search Results bom_open_interface_api

Overview

The concurrent program BMCOIN is owned by the BOM — Bills of Material product module in Oracle E-Business Suite. It is presented to users under the name Bill and Routing Interface and is described in the ETRM metadata as performing a "Bill of Materials Entity Bulkload from Interface Tables." Its function is to import bill of material structures and routings that have been staged in the BOM open interface tables, converting those staging rows into validated, active BOM and routing entities within Oracle Bills of Material. The program is enabled and available for submission.

The executable name, BOM_OPEN_INTERFACE_API, makes explicit the link between this concurrent program and the open interface API layer. Users who search for the term "bom_open_interface_api" are in effect seeking the PL/SQL interface routine that the concurrent program invokes to process staged data.

Execution Details

The documented execution metadata for BMCOIN is as follows:

• User-facing name: Bill and Routing Interface
• Description: Import Bills and Routings
• Product: BOM — Bills of Material
• Enabled: Yes
• Execution Method: PL/SQL Stored Procedure
• Argument Method: Standard
• Executable: BOMOIAPI
• Execution File: Bom_Import_Pub.Import_Interface_Rows
• Subroutine Name: (none specified)

The execution file Bom_Import_Pub.Import_Interface_Rows is the packaged procedure that the concurrent manager invokes at runtime. Because the argument method is Standard, the program accepts the standard concurrent program arguments defined for it (for example, organization and batch-related selections) rather than a custom argument scheme.

How to Run

Users submit BMCOIN through the standard Submit Requests (SRS) window in Oracle E-Business Suite: navigate to the relevant responsibility, choose Submit a New Request (single request), then select Bill and Routing Interface from the list of concurrent programs. The program executes as a PL/SQL stored procedure against the BOM open interface tables.

Before submission, source data must first be loaded into the interface tables (typically by an external system, a data conversion script, or a feeder process). Parameter values govern which staged rows are processed — commonly the organization and any batch or group identifier — so that only the intended set of interface rows is imported. Because the argument method is Standard, the exact parameter list is defined by the executable registration. After the request completes, the concurrent manager log and output should be reviewed for rejected or error rows, which are reported back into the interface tables for correction and resubmission.

Related Objects

• Execution package: Bom_Import_Pub.Import_Interface_Rows — the API procedure invoked by BMCOIN.
• Open interface tables: The standard BOM open interface tables that stage bills and routings prior to import (for example, the BOM interface tables for bill and routing entities).
• Executable: BOMOIAPI, the registered concurrent executable.
• Related concurrent program: Other BOM import/interface programs that share the open interface infrastructure.
• APIs: The BOM open interface public APIs referenced through Bom_Import_Pub, which validate and create BOM and routing records.

In practice, BMCOIN serves as the batch, concurrent-manager entry point for the BOM open interface, while the underlying Bom_Import_Pub API performs the row-level validation and creation logic.