Migration from 11i to R12- Sales Order Line Warehouse Not Updated With New Org Structure
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