Search Results migrate_obsolete_columns




Overview
Explore in AI Chat

Overview

INV_OPM_ITEM_MIGRATION is a public PL/SQL package owned by APPS that supports the Process Manufacturing (OPM) convergence initiative in Oracle E-Business Suite. Its header comment identifies it as a migration-only utility, created by Jatinder Gogna on 22 March 2005, and sourced from the file INVGIMGS.pls. The package exists to move item definitions from the legacy OPM/GMI data model into the Oracle Discrete Manufacturing inventory item model, so that formerly process-only items become accessible to the broader Oracle Inventory, manufacturing, and regulatory frameworks.

The classification of this object as OTHER rather than as a formal public API reflects its purpose: it is an internally scoped migration engine rather than a general-purpose integration interface. All of its procedures are intended to execute against a controlled migration run, identified by a migration run identifier, and they report failures through an output counter rather than raising conventional application exceptions.

Key Procedures and Functions

  • GET_ODM_ITEM — Retrieves the Oracle Discrete Manufacturing (ODM) representation of an OPM item for a given migration run, item, and organization. It accepts mode and commit indicators, supports an optional item code, and defaults the item source to GMI. It returns the resulting inventory item identifier and a failure count.
  • GET_ODM_REGULATORY_ITEM — Performs the equivalent retrieval for regulatory item definitions, keyed by item code and organization within a migration run, returning the inventory item identifier and failure count.
  • MIGRATE_OPM_ITEMS — Executes the principal item migration, converting OPM item records into the target inventory item structure. It is the central driver invoked for a migration run.
  • MIGRATE_OBSOLETE_COLUMNS — Transfers data from obsolete OPM/GMI columns onto their replacement flexfield columns, using a migration run, an obsolete column name, and a flexfield column name, returning a failure count.
  • VALIDATE_ITEM_CONTROLS — Validates item control setup for the migration run, confirming that the attribute control environment is compatible with the item data being converted. This procedure is the entry point most commonly associated with the search term "validate_item_controls."
  • VALIDATE_DESC_FLEX_DEFINITION — Validates the descriptive flexfield definition used for migrated items, ensuring that the flexfield structure required by the migration exists and is correctly configured.

Tables Accessed

The package operates across OPM, inventory, and Oracle Application Object Library metadata. Core OPM sources include IC_ITEM_MST_B, IC_ITEM_MST_TL, IC_ITEM_CPG, IC_LOTS_STS, GR_ITEM_GENERAL, and GR_MULTILINGUAL_NAME_TL. Migration control and staging data reside in GMI_MIGRATION_PARAMETERS, GMI_OBSOLETE_ITEM_COLUMNS, and IC_ITEM_MST_B_MIG. Flexfield and profile validation draws on FND_DESCR_FLEX_CONTEXTS, FND_DESCR_FLEX_COLUMN_USAGES, FND_COLUMNS, FND_TABLES, FND_PROFILE_OPTIONS, and FND_PROFILE_OPTION_VALUES.

Usage Notes

Because the package is a migration utility, it is not invoked from end-user forms during normal transactional processing. It is typically executed during a controlled OPM convergence cutover, often through custom driver scripts or dedicated concurrent programs supplied by the migration effort, and is referenced by six other packages. The use of a migration run identifier, explicit commit flags, and failure counters indicates that callers are expected to orchestrate procedures in sequence and to inspect failure counts before committing. On EBS 12.1.1 and 12.2.2, the same source file applies, though online patching in 12.2.2 means migration activity should be scheduled within an appropriate adop phase.