Search Results migrate_organization




Overview
Explore in AI Chat

Overview

INV_MIGRATE_PROCESS_ORG is an Oracle EBS Oracle Inventory (INV) migration utility package owned by the APPS schema and declared with AUTHID CURRENT_USER. Its purpose, as reflected in the header comment of the source file INVPOMGS.pls, is to migrate and update organization-related setup data into the Discrete (Oracle Manufacturing) tables. The package supports a migration-run framework identified by a run identifier, and it writes status and failure information to a migration log so that administrators can audit and diagnose conversions of inventory organizations.

The package is classified as OTHER in the ETRM API registry, meaning it is an internal, non-public utility rather than a supported open interface or public API. It is designed to be executed during implementation and data conversion activities rather than in day-to-day transactional processing.

Key Procedures and Functions

  • UPDATE_ORGANIZATION — Updates existing organization values. It accepts a migration run identifier, a commit flag, and returns a failure count through an OUT parameter, allowing the caller to determine how many records could not be processed.
  • CREATE_LOCATION — Creates locations in the Discrete tables. Documented inputs include the migration run identifier, organization identifier, subinventory code, location name, location description, active start date, and commit flag, with a failure count returned as an OUT parameter. This is the procedure most frequently associated with the search term create_location, and it is the entry point used when migrating item location definitions into a target organization.
  • MIGRATE_ORGANIZATION — The orchestrating procedure that drives the migration process for an organization, coordinating the update and location-creation steps within a single migration run.

Tables Accessed

The package reads and writes a broad set of inventory, HR, and legacy staging tables through APPS synonyms. Organization and location master data are held in HR_ORGANIZATION_UNITS_S, HR_ORGANIZATION_INFORMATION, HR_ORGANIZATION_INFORMATION_S, and HR_LOCATIONS_ALL. Inventory organization parameters are read from MTL_PARAMETERS, with subinventories in MTL_SECONDARY_INVENTORIES and material statuses in MTL_MATERIAL_STATUSES. Item location records are written to MTL_ITEM_LOCATIONS and MTL_ITEM_LOCATIONS_S. Legacy migration staging entities include GL_PLCY_MST, GL_SEVT_TTL, IC_LOCT_MST, IC_WHSE_MST, SY_ADDR_MST, and SY_ORGN_MST, which supply the source values being transformed.

Usage Notes

INV_MIGRATE_PROCESS_ORG is referenced by four other packages, indicating it forms part of a larger migration call graph rather than being invoked directly by end users. It is typically called from custom PL/SQL migration scripts or concurrent programs during an inventory organization conversion, where the caller supplies the migration run identifier and a commit flag to control transaction boundaries. The commit parameter allows the caller to defer commits until a batch of records is processed, which is important for performance and restartability. Because the package is an unsupported internal utility, it should not be embedded in production transactions; it is best used under the supervision of an implementation team, with results validated against the migration log and the MTL_ITEM_LOCATIONS tables after execution.