OPM 11i To R12 Upgrade, GMD_SAMPLING_EVENTS With Missing Organization_ids, Inventory_item_ids
Last updated on MARCH 08, 2017
Applies to:Oracle Process Manufacturing Systems - Version 12.2.4 and later
Information in this document applies to any platform.
On : 12.2.4 version, Migration Issues 11i to R12
90% of the customer's rows in gmd_sampling_events have null organization_id and inventory_item_id. Looking at the data in gmd_sampling_events and ic_whse_mst it appears that all of the sampling event rows with the missing data have warehouses that were migrated as subinventories. Could there be a bug where the organization_id (and therefore inventory_item_id) are not populated correctly when the warehouse on the sampling event is migrated as a subinventory?
Expect organization_id and inventory_item_id to be populated correctly.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms