Results for “rcv_gml_conv_mig”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

RCV_GML_CONV_MIG is a PL/SQL package body owned by the APPS schema that supports the Inventory Convergence project for Oracle Process Manufacturing (GML) implementations running on Oracle E-Business Suite 12.1.1 and 12.2.2. Its purpose is to reconcile and complete Receiving (RCV) data that was migrated from a legacy GML environment into the standard EBS receiving tables. During such migrations, lot numbers and unit-of-measure attributes frequently arrive in a partially converted state: lot numbers may be missing on receiving transactions, secondary UOM and secondary quantity values may not be populated, and lot supply records may not reflect the final migrated lot. This package addresses those gaps by running a set of bulk update procedures against the RCV tables, keyed from the migration staging tables.

Key Procedures and Functions

The package exposes four documented procedures. No public functions are declared.

• RCV_MIG_GML_DATA — The main entry point and driver procedure. It takes no parameters and sequentially calls the three subordinate update procedures, providing a single callable unit to complete the migration reconciliation.
• UPDATE_RCV_LOT_TRANSACTIONS — Populates the LOT_NUM column on RCV_LOT_TRANSACTIONS using the latest migrated lot number. Historical defect fixes (Bug#11670689, Bug#12591131) added optimizer hints and restricted processing to transactions whose lots were already migrated, improving performance and avoiding updates to unmigrated data.
• UPDATE_RCV_SUPPLY — Populates the secondary unit of measure and secondary quantity columns on RCV_SUPPLY, aligning supply records with the converted item and UOM definition.
• UPDATE_RCV_LOTS_SUPPLY — Updates lot numbers on RCV_LOTS_SUPPLY so that lot supply records reference the final migrated lot identifiers.

Tables Accessed

The package reads from migration staging and setup tables and writes to the RCV transactional tables. Staging sources include GML_RCV_LOTS_MIGRATION, IC_ITEM_MST_B_MIG, and IC_LOTS_MST_MIG, which carry the converted item and lot definitions produced by the convergence process. MTL_SYSTEM_ITEMS_B, MTL_UNITS_OF_MEASURE, MTL_PARAMETERS, and MTL_TRANSACTION_REASONS supply item, UOM, organization, and reason validation data. RCV_SHIPMENT_LINES and RCV_TRANSACTIONS provide the receiving transaction context needed to correlate migrated lots with specific receipts. The three RCV targets — RCV_LOT_TRANSACTIONS, RCV_SUPPLY, and RCV_LOTS_SUPPLY — are updated in place. GML_PO_MIG_ERRORS is available for logging migration errors encountered during processing.

Usage Notes

RCV_GML_CONV_MIG is a migration utility, not a runtime transactional API, and is not referenced by any other package in the ETRM inventory. It is typically invoked directly from SQL*Plus or a custom concurrent program during an Inventory Convergence cutover, after the GML-to-EBS lot and item migration programs have completed but before receiving data is opened to users. The callable syntax is rcv_mig_gml_data;. Because the procedures perform set-based updates across the full RCV_LOT_TRANSACTIONS, RCV_SUPPLY, and RCV_LOTS_SUPPLY tables, execution should be scheduled during a maintenance window, preceded by a backup of the three target tables, and followed by validation of lot number and secondary UOM completeness. The package is not exposed through standard EBS forms or menus.