Search Results level_error

Overview

GMD_QC_MIGB12 is an Oracle EBS Application Object Library (APPS) package body belonging to the Oracle Process Manufacturing (OPM) Quality module. Its stated purpose, as documented in the source header, is to contain migration procedures and functions for Quality data as part of the Release 12 migration effort, specifically targeting the reassignment of batch_id values. The package is registered with the ETRM repository under API classification OTHER and is owned by the APPS schema. It forms part of the internal migration toolset used to convert pre-R12 Quality structures into the tables introduced or restructured in Release 12, rather than a business-facing API intended for end users or third-party extensions.

Key Procedures and Functions

The ETRM metadata documents a single public entry point:

• GMD_QC_MIGRATE_BATCH_ID — The primary migration driver exposed by this package. It orchestrates the migration of Quality records against the new batch identifiers created during the 12.x data conversion, coordinating the resequencing of dependent Quality rows so that sample events, specification versions, and material detail references remain consistent with the migrated batch hierarchy.
• GET_MATL_DETAIL_ID (private helper, visible in the package source) — Resolves the new material_detail_id for a supplied new batch_id combined with an existing step_no. Its parameters identify the migration run, the current key of the record (used for error reporting), the record context (1 = sample events, 2 = gmd_wip_spec), and the old material detail identifier; it returns the new material detail identifier and an exception count. This routine isolates the lookup logic that the public driver repeatedly invokes.

No other procedures or functions are exposed in the documented interface; implementation details beyond these are treated as internal to the package body.

Tables Accessed

The package references the following tables through APPS synonyms:

• GMD_SAMPLES and GMD_SAMPLING_EVENTS — Quality sample headers and their sampling events, which are rebound to the migrated batch identifiers.
• GMD_WIP_SPEC_VRS — Work-in-process specification versions tied to batch steps; referenced so specification rows follow the batch migration.
• GMD_SS_MATERIAL_SOURCES — Material source definitions associated with Quality specifications.
• GME_BATCH_MAPPING_MIG — The migration mapping table holding old-to-new batch identifier relationships; this is the authoritative source used to translate legacy batch IDs.
• GME_BATCH_STEPS and GME_MATERIAL_DETAILS — Batch step and material detail records used to derive the new material_detail_id for a given batch/step combination.

Usage Notes

GMD_QC_MIGB12 is an internal migration utility and is not intended for direct invocation from Oracle Forms or standard concurrent program definitions. It is typically called from the Release 12 upgrade and migration driver scripts that populate GME_BATCH_MAPPING_MIG before Quality data is converted. Because it is referenced by one other package, the correct execution order matters: the batch mapping must be complete before GMD_QC_MIGRATE_BATCH_ID runs, otherwise the internal lookup in GET_MATL_DETAIL_ID raises exceptions that are counted and reported through the exception count output. When diagnosing the search term level_error, note that migration packages of this type accumulate row-level errors in the caller's exception table rather than raising a single hard failure, so the reported exception count and the associated key identifiers are the starting point for investigation. In practice, the package should be run only through the supported migration path, within a controlled maintenance window, and with a backup of the Quality tables available.