Search Results bom_operation_sequences_s




Overview
Explore in AI Chat

Overview

BOMPASGR is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. Its name and documented procedure list identify it as a routing and operation assignment utility within the Oracle Bills of Material (BOM) module. In EBS 12.1.1 and 12.2.2, manufacturing routing data is staged in interface tables and then validated and transferred into the operational routing, operation sequence, and resource tables. BOMPASGR performs the programmatic portions of that assignment work: resolving organization identifiers, item revisions, routing headers, operation sequence identifiers, resource sequence identifiers, and lookup values such as departments and standard operations.

The package is therefore best understood as a shared assignment and lookup layer used during routing import, item routing association, and interface processing. It is not an end-user-facing API entry point; rather, it is invoked by higher-level concurrent programs and interface processors that must populate the base BOM routing tables from staging data. The ETRM record shows the object status as VALID, and no database object is documented as referencing it directly, though it is referenced by one other package.

Key Procedures and Functions

The documented package exposes thirteen procedures and functions, each scoped to a specific assignment or retrieval task:

The pattern is consistent: assignment procedures write identifiers and structural keys, while retrieval functions supply reference values needed to derive those keys.

Tables Accessed

BOMPASGR reads and writes the core BOM routing and resource tables through APPS synonyms. It accesses BOM_OPERATIONAL_ROUTINGS and its _S sequence-keyed counterpart for routing headers, and BOM_OPERATION_SEQUENCES and BOM_OPERATION_SEQUENCES_S for operation sequences. Resource detail is drawn from BOM_RESOURCES, BOM_DEPARTMENT_RESOURCES, and BOM_STD_OP_RESOURCES, while department and standard operation lookups use BOM_DEPARTMENTS and BOM_STANDARD_OPERATIONS.

Staging and interface processing relies on BOM_OP_ROUTINGS_INTERFACE, BOM_OP_SEQUENCES_INTERFACE, and BOM_OP_RESOURCES_INTERFACE. Item and revision context is obtained from MTL_RTG_ITEM_REVISIONS, MTL_RTG_ITEM_REVS_INTERFACE, and MTL_SYSTEM_ITEMS_INTERFACE_S, with organization defaults drawn from MTL_PARAMETERS. CST_ACTIVITIES and INVPUOPI support costing-activity and inventory-parameter lookups, and DUAL is used for standard single-row selection.

Usage Notes

In Oracle EBS 12.1.1 and 12.2.2, BOMPASGR is invoked indirectly. Typical callers include routing interface concurrent programs, item routing import routines, and the parent package that references it, all of which must resolve sequence identifiers and assign header, operation, and resource records. The presence of the _S tables confirms that sequence-generated identifiers are central to the assignment logic, and the reference to BOM_OPERATION_SEQUENCES_S explains why a search for that table surfaces this package.

Custom code should not call BOMPASGR directly; it is an internal implementation package rather than a published API, and there are no documented interface parameters exposed in the ETRM record. Developers integrating routing data should use the supported routing import interface and concurrent programs, which in turn call this package to perform identifier assignment and reference lookups.