Search Results insert_rout_status

Overview

GMD_ROUT_MIGRATION is a PL/SQL migration package owned by the APPS schema in Oracle E-Business Suite. It belongs to the Oracle Process Manufacturing (OPM) family of modules and, based on its name and header comment ($Header: GMDRTMGS.pls 115.4 2003/02/21 ...), it was originally authored to support data migration and conversion utilities for OPM routings (recipes). The package is declared with AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the invoking schema rather than the package owner, which is typical for internal migration and utility routines in OPM.

The package is classified as an "OTHER" API in the ETRM documentation, indicating that it is not part of the supported, public application programming interface. It is an internal utility rather than a published, supported integration surface.

Key Procedures and Functions

The package exposes two documented procedures, both parameterless in the excerpted source:

• INSERT_ROUT_STATUS — Populates status information related to OPM routings. Given its name and the package's migration context, it is used to seed or refresh routing status records as part of a migration or conversion process.
• INSERT_TRANSFER_PERCENT — Added under Bug#2200539 (annotated in the source as "BEGIN Bug#2200539 P.Raghu" / "END Bug#2200539"). It handles the insertion of transfer-percent data, a concept used in OPM routings to define the proportion of material transferred from one routing step or operation to another. This is the specific routine users searching for "insert_transfer_percent" will encounter.

No parameter lists are published in the available metadata; the documented signatures are therefore described by purpose only.

Tables Accessed

ETRM documents four tables referenced through APPS synonyms:

• FM_FORM_EFF_BAK — A backup/history table for formula effectivity data. Its presence confirms the package participates in migration backup and staging operations.
• FM_ROUT_DEP — Stores routing dependencies; the package reads or writes these to maintain relationships between routing steps during conversion.
• GMD_ROUTINGS_B — The base table for OPM routings, the central entity the migration addresses.
• GMD_STATUS — The OPM status code table, referenced by INSERT_ROUT_STATUS to resolve or assign routing statuses.

Usage Notes

GMD_ROUT_MIGRATION is an internal, one-time or scheduled migration utility, not a transactional business API. It is typically invoked during OPM implementation, upgrades, or data-conversion projects, and it carries a noship header tag indicating it was not shipped to customers as a supported deliverable. Because the package is not referenced by any other documented packages and is not exposed through a public API classification, it should be treated as a private routine rather than an integration point.

Practitioners searching for INSERT_TRANSFER_PERCENT generally encounter this package while investigating how transfer-percent values were populated in GMD_ROUTINGS_B or diagnosing DML against the FM and GMD base tables. Any direct invocation from custom code should be preceded by a full backup of the affected tables, since the presence of FM_FORM_EFF_BAK and the migration-oriented procedure names signal destructive or bulk-insert behavior. For supported routing maintenance, the standard OPM forms and public APIs should be used instead.