Search Results bom_routinginterface_pub




Overview
Explore in AI Chat

Overview

BOM_ROUTINGINTERFACE_PUB is a public PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It provides a programmatic entry point for importing routing information into the Bills of Material (BOM) module through the open interface tables. The package forms part of Oracle's published API layer, as indicated by its PUB classification, meaning it is intended for direct invocation by external programs, concurrent programs, and custom code rather than being an internal implementation detail. Its central role is to take staged routing and operation data—already validated and populated in the interface tables by upstream processes—and transfer it into the production BOM routing structures.

The package occupies a specific position in the routing import workflow. Callers populate the interface tables with the desired routing definitions, then invoke this package to perform the actual import. The package encapsulates the validation, sequencing, and error-handling logic that converts interface rows into permanent routing records.

Key Procedures and Functions

The documented metadata lists a single public program unit:

  • IMPORTROUTING — This procedure performs the import of routing data from the BOM interface tables into the base routing tables. It is the principal and only documented entry point exposed by the package. As a published procedure, IMPORTROUTING is designed to be called directly by clients that have already staged their data. The procedure coordinates the processing of routing headers, operation sequences, operation resources, and item revision relationships that reside in the various interface tables. It relies on the FND_API utility package for standard API error and message handling, consistent with Oracle's API conventions.

The metadata does not document parameter lists for IMPORTROUTING, so specific argument signatures should be confirmed against the deployed package specification in the target instance.

Tables Accessed

The package reads and writes the following documented tables, accessed through APPS synonyms:

Collectively these tables support staging, validation, and error tracking across the full routing import cycle.

Usage Notes

BOM_ROUTINGINTERFACE_PUB is typically invoked in the context of concurrent program execution or custom batch routines that populate the routing interface tables and then call IMPORTROUTING to commit the data. Oracle's standard routing interface concurrent program and related forms leverage this API to bridge staging and production data. Because the metadata indicates the package is referenced by zero other packages, it is a leaf-level consumer in the dependency graph: external callers depend on it, but no other PL/SQL package wraps it.

When integrating, ensure interface tables are properly loaded and validated beforehand, and monitor the FND_API-based error reporting to capture per-record failures. The package is valid in both EBS 12.1.1 and 12.2.2, and behavior is expected to be consistent across those releases.