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.

Goal

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.
 

Solution

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
Goal
Solution
References


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