OPM 11i To R12 Upgrade, GMD_SAMPLING_EVENTS With Missing Organization_ids, Inventory_item_ids

(Doc ID 2000590.1)

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.

Symptoms

On : 12.2.4 version, Migration Issues 11i to R12

ACTUAL BEHAVIOR
---------------
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?

EXPECTED BEHAVIOR
-----------------------
Expect organization_id and inventory_item_id to be populated correctly.

Cause

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