I have a circumstance as follows:
1) Items in the pending transactions form show as internal order pick allocations
2) The order lines have been closed (old orders)
3) The items are old and have been since replaced with new items and the old items are inactive.
We are doing an R12 upgrade from R11.5.10 and a pre-requisite is to not have any pending transactions, my issue is I can not seem to get rid of these allocations, so I'm looking for ideas.
Any help with this would be greatly appreciated !
I found the following script, INVCLRMOv115.5.sql, has anyone ran this, was it successful?