My Oracle Support Banner

How To: Merge Lots then Split To Return Back To The Original Lots (Doc ID 2260489.1)

Last updated on OCTOBER 04, 2023

Applies to:

Oracle Warehouse Management - Version 12.2.4 and later
Information in this document applies to any platform.


In the images below and/or the attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).
Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

As the functionality of splitting a lot, then re-merging that same lot is not documented, the goal here is to document the designed functionality of the following scenario:

Assume first there is the same part, revision, subinventory and locator for all lots. Begin by merging LotB quantity 5 into LotA quantity 5 resulting in LotA quantity 10.

Now split the LotA qty 10 back to LotA qty 5 and LotB qty 5.

It seems the only way to perform this is to first split LotA quantity 10 to "LotA.Temp" quantity 5 and" LotB.Temp" quantity 5 to avoid "lot already exists in org" errors. Once these temp lots are created with the proper quantity, one can then translate them to the LotA quantity 5 and LotB quantity 5.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.