My Oracle Support Banner

Mapping Between Container (LPN Id) To Onhand Quantity For WMS And Non-WMS Organizations (Doc ID 2789486.1)

Last updated on NOVEMBER 02, 2023

Applies to:

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


On : 12.2.6 version, Inventory Transactions

Need clarification on mapping between Container (LPN id) to Onhand qty

1) Reference script used for populating on interface tables (with TRANSFER LPN ID), where objective is to take receipt of inventory along with LPN ID
2) However tables like mtl_onhand_quantities_detail, mtl_material_transactions are not getting populated with the lpn_id which are required to achieve data integrity.


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.