My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

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


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.