Search Results write_routing

Overview

GMP_BOM_ROUTING_PKG (source file GMPBMRTS.pls) is an Oracle EBS Process Manufacturing package owned by APPS and defined with AUTHID CURRENT_USER. It supports the interface between process manufacturing formulas, routings, and bill of material structures on one side and the Advanced Planning and Scheduling staging tables on the other. The package is central to the extraction, validation, and loading (export) of effectivity, routing, operation, and BOM component data used in the APS/ASCP planning cycle for process organizations.

Its scope includes effectivity extraction routines, formula and routing validation functions, routing search helpers, and the write procedures that populate the MSC_ST_* staging tables. The package is referenced by three other packages and is normally invoked from process manufacturing concurrent programs rather than directly by end users.

Key Procedures and Functions

• EXTRACT_EFFECTIVITIES — extracts process effectivity records using the given apps link, delimiter, instance, and run date, returning a status flag.
• TIME_STAMP and LOG_MESSAGE — utility routines for timestamping and writing log output during batch processing.
• GMP_DEBUG_MESSAGE — diagnostic logging routine added under a defect fix for troubleshooting.
• CHECK_FORMULA and CHECK_FORMULA_FOR_ORGANIZATION — boolean functions that determine whether a formula is valid, standalone and within the context of a specific organization.
• VALIDATE_FORMULA and VALIDATE_FORMULA_FOR_ORGN — wrapper procedures that invoke the corresponding formula validation checks.
• INVALIDATE_RTG_ALL_ORG — invalidates routing information across all organizations for a given routing identifier. This is the routine associated with this document and is typically called when routing data must be reset or flushed prior to a subsequent planning load.
• VALIDATE_ROUTING — validates a routing against an organization, header locale, and returns a routing validity flag.
• SEARCH_OPERATION_LEADTIME — returns top and bottom leadtime range values for an operation / effectivity combination, added under a defect fix.
• LINK_ROUTING and LINK_OVERRIDE_ROUTING — establish the routing-to-operation linkage and the override linkage used during staging writes.
• EXPORT_EFFECTIVITIES — exports effectivity records as part of the export phase.
• BSEARCH_ROUTING and BSEARCH_SETUPID — binary search helpers used to locate routing identifiers and setup identifiers within staged collections.
• WRITE_PROCESS_EFFECTIVITY, WRITE_BOM_COMPONENTS, WRITE_ROUTING, WRITE_ROUTING_OPERATIONS — the primary staging writers. Each accepts an effectivity-related identifier and returns a status flag, populating the MSC_ST_* interface tables.

Tables Accessed

The package reads and writes through APPS synonyms. AD_APPLIED_PATCHES is queried for patch-level tracking. GMD_OPERATIONS and GMP_SEQUENCE_TYPES provide the process manufacturing operation and sequence type definitions referenced during routing validation. IC_ITEM_MST supplies process item master data. MSC_APPS_INSTANCES identifies the planning instance. DBMS_SESSION is used for session-level context. The MSC_ST_BOMS, MSC_ST_BOM_COMPONENTS, MSC_ST_OPERATION_COMPONENTS, MSC_ST_OPERATION_NETWORKS, MSC_ST_OPERATION_RESOURCES, MSC_ST_OPERATION_RESOURCE_SEQS, MSC_ST_PROCESS_EFFECTIVITY, MSC_ST_ROUTINGS, and MSC_ST_ROUTING_OPERATIONS tables are the APS staging targets that receive the extracted and transformed process manufacturing structures.

Usage Notes

GMP_BOM_ROUTING_PKG is invoked from process manufacturing concurrent programs and programs that perform APS/ASCP data collection; it is not intended for direct interactive use. The presence of AUTHID CURRENT_USER indicates that it executes with the privileges of the calling schema, so callers must hold the necessary privileges on the process and staging tables. Custom code should avoid calling the extraction and export routines outside of the standard planning cycle, since INVALIDATE_RTG_ALL_ORG and the export writers manipulate staging content that the planning collection process depends upon. Defect-fix annotations in the source (GMP_DEBUG_MESSAGE, SEARCH_OPERATION_LEADTIME) indicate the package continues to receive targeted enhancements under Oracle support, and the header version (120.7.12020000.1) confirms applicability across the 12.1.1 and 12.2.2 releases.