Migration from 11i to R12- Sales Order Line Warehouse Not Updated With New Org Structure

(Doc ID 2008720.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Process Manufacturing Systems - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Migration Issues 11i to R12
After migration found that warehouses that are migrated as subinventory are not updated like that on the sales order line. This did work in our previous migration, but not anymore.

See that former Inventory Organizations (IO's) that migrated to Subinventories (SI's) are migrated correctly, but for the sales orders the order lines are not migrated correctly. For example: former IO MMO became a SI under IO 100. This means that order lines should have the warehouse updated from MMO into 101. This didn't happen. The organization structure did change, but the sales order lines are still having MMO as a warehouse. And also, the allocations are gone.

The issue can be reproduced at will with the following steps:
1. Run migration from 11i to R12

The issue has the following business impact:
Due to this issue, sales order data is not being updated by migration as expected therefore the data cannot be used in R12.


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