My Oracle Support Banner

Inter Organization Transfer Creates Duplicate Record On Wms_lpn_contents Table (Doc ID 2394447.1)

Last updated on JUNE 04, 2021

Applies to:

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


Actual behavior

Inter Org transfer creates duplicate records on wms_lpn_contents.

Expected behavior

Inter Org transfer should not create duplicate records on wms_lpn_contents.

The issue can be reproduced at will with the following steps:

1. Create a work orderless in source organization through mobile and execute putaway => 1 record in wms_lpn_contents table
2. Transfer lpn from source organization to destination organization
3. Execute receive transaction in destination organization: a new record is inserted in wms_lpn_contents, so there are two rows for the same parent_lpn_id.


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.